Data Migration from SQL Server to SQL Azure

Data Migration from SQL Server to SQL Azure

You can transfer data to Microsoft Azure SQL Database by using the following:

• SQL Server 2008 Integration Services (SSIS) 
  
• The bulk copy utility (BCP.exe)
  
• System.Data.SqlClient.SqlBulkCopy class
  
• Scripts that use INSERT statements to load data into the database
  

Microsoft Azure SQL Database does not support:

• The RESTORE statement.
  
• Attaching a database to the Azure SQL Database server.