Is there any way or development tool available to generate SQL Azure compliant script locally on a developer machine ?Regards, Hemant
asked May 18, 2011 at 05:46 AM in Default
yes, it is possible.. In SSMS when you right click on the database, Select Tasks/Generate Scripts.. Then after selection of object and selecting destination of the final script (file, clipboard, script window), There is a Advanced button. In the Advanced scripting options there is row called "Script for the database engine type", where you can select "SQL Azure Database"
answered May 18, 2011 at 06:18 AM