Migrate SQL Server database to SQL Azure

Question

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.

Answer 1

Pre-requisites are:

• Install SQL Server 2016 or later version

• Enable TCP/IP protocol

• Create a single database in SQL Azure

For detailed steps, you can follow the steps mentioned in this tutorial.