Tuesday, April 12, 2016

Migrating data from SQL sever (On Prem) to Azure

I was trying to migrate the data from SQL Server 2012 to Azure DB. There are different ways to this , one of being exporting the data tier and importing back to Azure.

However, during exporting data tier some times you land up with bunch of exceptions as seen below. Its time consuming to get rid of these and sometimes you don't know what to do other than by searching or any trial and error.

I found a very cool tool that does this for you. Please download sqlazuremw for the SQL version you have from codeplex available at https://sqlazuremw.codeplex.com/



I downloaded it for SQL Server 2012 and works like a gem ! 
                                            
Steps:

1. Select the Analyze/Migrate option and connect to source
2. Do the analysis of the source database
3. Connect to target server
4. Start the migration

Haven't seen any issues so far. You could visit http://sqlazuremw.codeplex.com/workitem/list/basic for any known issues.

No comments: