Best Practices Moving from SQL Server to SQL Azure

  • Estimated read time: 1 min read
  • Written by Chad Campbell on May 2nd 2012

  1. When you choose your objects, I recommend going one object at a time. Personally, I go in the following order: Tables, Views, Stored Procedures, User-Defined Functions... Basically, I go in the order that they are shown in the "Generate and Publish Scrips" dialog.

  2. Use the "Advanced Scripting" dialog

    • Change "Include If NOT EXISTS" to true.
    • Turn "Script DROP and CREATE" to "Script DROP and CREATE".
    • Turn "Script for the database engine type" to "SQL Azure Database".
    • Turn "Script USE DATABASE" to false.

This should be automatically disabled when you change the database engine type as previously described. But, if for some reason, it doesn't get disabled, ensure that this value is "false."​


Comments

comments powered by Disqus

Chad Campbell
Chad Campbell

Chad is an independent software professional. He has been named a Microsoft MVP five times. His books have been translated into multiple languages and distributed worldwide. He holds a computer science degree from Purdue University, where he also studied psychology.

Chad has built sites, apps, frameworks, libraries, and platforms using Java, .NET, and Node. He's ran his own startups and has created software for Fortune 100 companies. In short, Chad knows how to create software. From ideation to delivery. From start-to-finish.


Follow Chad Online