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 the SQL Server Migration wizard

In the previous chapter, the SQL Azure Migration wizard was introduced, herein the practical implementation of using it to migrate from on-site SQL Server 2008 R2 November-CTP (SQL Server 2008 R2 can also be used) to SQL Azure server will be described. In order to do this, you will need to perform the following steps:

  1. Click SQLAzureMW application file from its location on your computer.
  2. The following Select Process of the ScriptWizard is displayed. You have several options in using this tool, as shown in the following screenshot:
    Using the SQL Server Migration wizard
  3. Choose the SQL Database option under Analyze and Migrate category and click Next ...

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