question

DenisMcD0542 avatar image
DenisMcD0542 asked ·

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

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


azure-sql-virtual-machines
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

vipullag-MSFT avatar image
vipullag-MSFT answered ·

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.


Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

mappie-kochi avatar image
mappie-kochi answered ·

Why not try using the Azure Database Migration Service?

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.

Share
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.