What's the best way to move a normal SQL server database to SQL Azure? Is it right that you can't restore from a backup file? The only way I've found so far is to script the database (and its data) and run those scripts on the SQL Azure database but this is slow when you have lots of data.
25
votes
6 Answers
27
votes
Use the SQL Azure Migration Wizard if running SQL 2008: http://sqlazuremw.codeplex.com/
For older versions the best thing I've seen is to either first upgrade to 2008 then port, or (unfortunately) to port the data using scripts as you've suggested. If you have to do so, might I suggest SubSonic for generating your scripts?
1
votes
0
votes
0
votes
Use Microsoft Data migration assistant tool which can be downloaded from here. https://www.microsoft.com/en-us/download/details.aspx?id=53595
First you have to install it. By using the Azure portal create new SQL database.Now you can deploy your local SQL database into Azure SQL database. If you have some warnings at the end of the migration process please ignore it.