Migration of SQL Datatabase and its data to Azure SQL Database

BULK INSERT T-SQL Statement is not supported in SQL Azure. You can use BCP to load data, for that the user who connects needs to have write permissions on the database or tables, you can add that user to "db_datawriter" database role in that specific database

 

To perform the migration perform the following steps:

 

1. Use the BCP utility to draw data out of your SQL Server into a file
2. Then move the data from the file to SQL Azure
3. It will be not easy to write BCP scripts by hand….Use some utility for these scripts.

Since writing BCP utilities can be cumbersome and require lots of efforts. To resolve this problem use the following BCP tool for the migration of schema and its data.

 

Migration Tool : http://sqlazuremw.codeplex.com/

 

 

Note: There are some feature which are not supported by Azure SQL and require manual intervention or workaround in your database or application. Please refer the Microsoft link to know about more http://msdn.microsoft.com/en-us/library/ff394115.aspx