Migrate to SQL Azure from SQL Server 2008

Migrate SQL Server 2008 R2 to Microsoft cloud database SQL Azure:

If you’re a small company, migrating your SQL server databases from an on-premise SQL Server 2008 to cloud SQL Azure service makes perfect sense. In such a manner you are able to cut some of the overhead you incur by having SQL Server in house. You can also use the “Pay what you Consume” model which can be beneficial in database computing costs. Finally you do not have to worry about high availability and redundancy as this feature is built into the cloud databases from Microsoft SQL Azure.

For this discussion on SQL Azure we are simply going to list the steps that are involved in migrating database from SQL server 2008 database to a SQL Azure at a higher level. Further details of this are included in the sample training video towards the end of this Azure article. For today’s purpose we will be using SQL Azure migration wizard which is a free utility that can be downloaded from this website:

http://sqlazuremw.codeplex.com/

Using this utility we will not only move SQL Azure database objects including tables, stored procedures, views and functions but also move the underlying data in SQL Azure database. In order to transfer the SQL Server database you have to follow the following steps:

9 Easy steps to Migrate SQL Server 2008 R2 to SQL Azure:

1. Download the migration and wizard utility from this location,
http://sqlazuremw.codeplex.com/
2. Installed the application on your database server and start the Migration wizard.
3. Select SQL Azure Database under the Analyze and Migrate option.
4. Make a connection to the source SQL database which in our case is going to be Northwind running on SQL Server 2008 R2.
5. Select all the necessary SQL Server database objects like procs, views, tables and functions and any other advanced options that you would like to migrate to SQL Azure. This will generate the TSQL (Transact SQL) code for creation of objects and movement of data to the cloud database.
6.Make a connection to the destination server which in our case is going to be SQL Azure in the Microsoft cloud environment
7. Choose to create a new database and select the proper Cloud database edition and database size
8. Finally go ahead and execute the TSQL Scripts
9. Connect to the destination SQL Azure database and verify that objects and data are migrated.

The above steps on SQL Azure Migration are illustrated in this video:

Migrate SQL Server to SQL Azure

Video Location: http://sqlazuretutorials.com/free-videos/Migrate-SQL-Azure-Youtube.wmv
For more information and training videos, visit our SQL Azure video page.

This entry was posted in Migration and tagged , , , . Bookmark the permalink.

4 Responses to Migrate to SQL Azure from SQL Server 2008

  1. My coder is trying to persuade me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using Movable-type on various websites for about a year and am concerned about switching to another platform. I have heard good things about blogengine.net. Is there a way I can import all my wordpress posts into it? Any kind of help would be greatly appreciated!

  2. sqlblog says:

    Do not have much experience on .Net or Php so sorry not able to shed any light on this.
    Thanks

  3. Gabriel says:

    Hi,

    I’m learning to build a small website and at the same time I’m trying hosting it in Azure.
    I had finally managed to create membership and roles hosted on a local SQLExpress database. To my horror when publishing the application to Azure this database isn’t transfered automatically to Azure as well. So I started googling around and the only real option seems to be using the MigrationWizard from Codeplex. However, this doesn’t support SQLExpress and I don’t have a real SQL Server available. Is there any other way to migrate this SQLExpress membership database to Azure?

  4. sqlblog says:

    Hi Gabriel,

    I understand the frustration with this. Personally have not worked a whole lot with SQLExpress so not sure 100% if this is going to work. Buy try these steps:

    -Download and Install Free eval SQL 2008 edition from here
    http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx

    -Backup your db on SQLExpress with “backup database”

    -Restore on SQL Server 2008 with “restore database”

    -Then use the Migration Wizard to move the db from SQL 2008 to the cloud.

    Let me know if this works. Also we would appreciate if you found this helpful to mention our site on some other blogs/sites. Good day!!