Importing and Exporting Database Objects - Cloud Database Development and Management - page 174

5.4 Windows Azure SQL Database Migration Wizard

With Windows Azure SQL Database Migration Wizard, you can migrate SQL Server databases to
Windows Azure SQL Database, especially those older versions of databases created on SQL Server
2005 and SQL Server 2008. It allows the database administrator to fully or partially migrate the
database schema and data to Windows Azure SQL Database. Before the migration process starts,
Windows Azure SQL Database Migration Wizard analyzes the source database for compatibility
issues. Once incompatibilities are identiied, Windows Azure SQL Database Migration Wizard
will allow the database administrator to ix them when possible. To avoid some of the incompat-
ibilities, the database administrator can choose to migrate:

◾ Database schema and data

◾ Database schema only

◾ Data only

he database schema includes database objects such as tables, views, stored procedures, and
so on. During the analysis process, Windows Azure SQL Database Migration Wizard creates
SQL scripts that create database objects. he database administrator can modify the SQL scripts
to resolve incompatibilities. Windows Azure SQL Database Migration Wizard can execute the
modiied scripts on Windows Azure SQL Database to generate the database that is compatible
with Windows Azure SQL Database.

ACTIVITY 5.3 DATABASE MIGR ATION WITH
SQL AZURE MIGR ATION WIZARD

1. Download SQL Azure Migration Wizard from the following website to your virtual
machine:
http://sqlazuremw.codeplex.com/

2. Open the downloaded folder. Double click the ile SQLAzureMW and click Extract
all as shown in Figure 5.15. After the extraction is completed, double click the
SQLAzureMW ile again and click Run to start the wizard.

3. On the Select Process page, under the title Analyze/Migrate , click the option
Database shown in Figure 5.16.

4. Click Next to go to the Connect to Server dialog. Make sure that the server name
is localhost , the authentication is Use Windows NT Integrated Security , and the
database is Master DB as shown in Figure 5.17. hen, click Connect .

5. After the server is connected, on the Select Source page, you will be prompted to select
the database for migration. Select the database Computer_Store .

6. Click Next to go the Choose Objects page. Take the default and click Next again.

7. On the Script Wizard Summary Page, click Next . When prompted to save the SQL
script, click Yes .

8. After the SQL script is saved, you will be prompted to conigure the connection to
Windows Azure SQL Database. Make sure that the server type is Windows Azure SQL
Database , enter your Windows Azure SQL Database server name, the authentication is
Use a speciic user ID and password , and then enter your user name and password to
Windows Azure SQL Database (Figure 5.18). hen click the Connect button.