Menu
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.
439
This Azure service can migrate SQL Server databases to Azure SQL Database through the Azure portal or automatically through PowerShell. Database Migration Service requires you to select a preferred Azure virtual network during provisioning to ensure connectivity to your source SQL Server databases.
Open the Data Migration Assistant (DMA). Select File and then choose New assessment. Specify a project name, select SQL Server as the source server type, and then select Azure SQL Managed Instance as the target server type. Select the type(s) of assessment reports that you want to generate.
Azure fully supports running any edition of SQL Server on IaaS (VM). Combined with 'Always On' availability groups you will be able to achieve full compatibility with legacy on-premises SQL installs.
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?
105
Thank you:
http://blogs.msdn.com/b/brunoterkaly/archive/2013/09/26/migrating-an-on-premises-sql-server-2012-database-to-windows-azure-sql-database.aspx
44
Use the SQL Azure Migration Wizard if running SQL 2008:
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
