O'Reilly logo

Microsoft SQL Azure: Enterprise Application Development by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using SQL Server Management Studio with scripts

SQL Server Management Studio can be used to create scripts for all database objects including databases. This can be used to move a database from your on-site SQL Server 2008 R2 to SQL Azure. This is a general procedure that can be used with databases on other server versions as well. For running scripts on SQL Azure in SQL Server 2008 R2 using SSMS, please read the Scripting support for SQL Azure section in Chapter 4, SQL Azure Tools.

Creating a script for the Northwind database

We will now migrate the Northwind database from the on-site server (HODENTEK3\KUMO) to SQL Azure. Make sure you have configured Script for server version to SQL Server 2008 R2 from Tools | Options in SSMS, as described in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required