Migrating SQL Server 2008 to Windows Azure SQL database using the SQL Database Migration Wizard

This experience uses the SQL database migration Wizard (SQLAZUREMW) to migrate SQL Server 2008 databases to Azure SQL database. Of course, SQLAZUREMV can also migrate SQL Server 2005/2012/2014 to azure SQL Database.

There are several versions of SQLAZUREMV:
1. SQLAZUREMW v3x applies to. NET Framework 3.5 and SQL Server R2 SP1
2. SQLAZUREMW v4x applies to. NET Framework 4.5 and SQL Server 2012
3. SQLAZUREMW v5x applies to. NET Framework 4.5 and SQL Server 2014

All versions are downloaded here.

→ Sign in to the management portal in Windows Azure

→ Click "SQL database" on the left

→ Click "new" at the bottom left of the page

Select the appropriate "service layer" version, select the default collation is "SQL_Latin1_General_CP1_CI_AS", select the server, click on the bottom right corner of the "tick" button.

If you have not yet created the server, create the server first:

Click the "Tick" button in the lower right corner.

→ Click "SQL database" on the left

→ Click on "Server"

→ Click server name

→ Click "Configure"

→ Click "Add to allowed IP address", add the current IP address to "whitelist" and click "Save".

→ Double click on "SQLAzureMV.exe"

→ Tick "database" in the interface and click "Next"

→ In the "Connect to Database ..." window, tick "SQL Server Authentication", fill in the user name and password, specify the database name, tick "Save login Information", click "Connect" button

→ Click "Next" in the interface

→ tick "Generate scripts for all objects" in the interface and click "Next"

→ In the "Script Wizard Summary" screen, click "Next"

Jump out of the "Generate Script" prompt and click "Yes"

→ In the results summary screen, there are "execution results" and "SQL Script" tabs, click "Next"

Note: If there are errors or incompatibilities in the generated SQL script, they will appear in red font, when you can save the SQL script to the hard disk, and then modify it in SQL Server Management Studio, You can open the modified SQL script file directly in SQLAZUREMV.

→ To the "management Portal" copy the server name, similar to "xxxxxx.database.chinacloudapi.cn" format, fill in the following:

Note: In the User Name field, fill in the "Server name @xxxxxx", the xxxxxx after @ is consistent with the xxxxxx in "xxxxxx.database.chinacloudapi.cn". The user name in is incorrect.
In the Execute script prompt that jumps out, tap Yes.

Click "Connect".

→ Click "Next" in the interface

The migration successfully shows the following interface:

→ Click "Exit".

→ open "sql Server Management Studio", fill in the relevant information in the interface, click "Connect"

Attention:
0 The server name is similar to the "xxxxxx.database.chinacloudapi.cn" format, and the user name is similar to the "server name @xxxxxx" format.
0 can also be https://xxxxxx.database.chinacloudapi.cn/, to determine whether the address, user name, password is correct.
0 if SQL Sever 2008 has not yet allowed remote connections, refer to here.

→ After successful login, the following interface is displayed:

At this point, use the SQL database Migration Wizard (SQLAZUREMW) to migrate the SQL Server 2008 databases to Azure SQL database, Success!

Migrating SQL Server 2008 to Windows Azure SQL database using the SQL Database Migration Wizard