Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I generate a SQL Azure compatible script using SQL Server management Studio?

April 26, 2017azure compatible Management Script sql SQL Server Studio

0

Posted

How can I generate a SQL Azure compatible script using SQL Server management Studio?

1 Answer

0

Posted

The version of SQL Server Management Studio (SSMS) included with SQL Server 2008 R2 includes support for SQL Azure. The Express edition of SSMS can be downloaded from Microsoft SQL Server 2008 R2 RTM – Management Studio Express. To generate an SQL Azure compatible script using SSMS, perform the following steps: 1. In SSMS, select the database, right-click, select Tasks, and then select Generate Scripts. 2. Under Set Scripting Options, click Advanced and set Script for database engine type to SQL Azure Database 3.