How can I migrate my on-premises SQL Server database to the Cloud?

Question

How can I migrate my on-premises SQL Server database to the Cloud?

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question.] Source: FAQ

Answer 1

First create an Azure virtual machine with a SQL Server instance. Then migrate your on-premises databases to that instance. For data migration strategies, see Migrate a SQL Server database to SQL Server in an Azure VM.

Source: Azure Documentation FAQ.

Answer 2

Why not try using the Azure Database Migration Service?

• https://azure.microsoft.com/en-us/services/database-migration/

If your saying "to the Cloud" mean migrating to Azure's PaaS DB (SQL Database), take a look at the Azure Database Migration Service documentation.

• Azure Database Migration Service documentation