-
Book Overview & Buying
-
Table Of Contents
Microsoft SQL Azure Enterprise Application Development
By :
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.
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 Chapter 4, SQL Azure Tools. Also make sure that you have configured the scripting in Tools, such that the script option is Script for database engine type to SQL Azure Database and that the Tools window appears, as shown in the following screenshot...
Change the font size
Change margin width
Change background colour