Best approaches for migrating On-premise SQL Server to Azure SQL or Azure SQL MI

Question

What are the best approaches for migrating On-premise SQL Server to Azure SQL or Azure SQL MI

Answer 1

Hi @Naveen Kumar Kakarla (Quadrant Resource)

There are multiple approaches for migrating an on-premise SQL Server to Azure SQL or Azure SQL Managed Instance. Here are some of the best approaches:

1. Azure Database Migration Service (DMS): Azure DMS is a fully managed service that simplifies the migration process. It supports both online and offline migrations and provides features like schema and data migration, high availability, and minimal downtime .
2. Azure SQL migration extension for Azure Data Studio: This extension provides a user-friendly interface for migrating SQL Server databases to Azure SQL or Azure SQL Managed Instance. It offers features like assessment, performance data collection, and right-sized Azure recommendations .
3. Native backup and restore: This approach involves taking a backup of the on-premise SQL Server database and restoring it to Azure SQL or Azure SQL Managed Instance. It is a straightforward method but may require some downtime .

These are some of the recommended approaches for migrating an on-premise SQL Server to Azure SQL or Azure SQL Managed Instance. The choice of approach depends on factors like migration complexity, downtime tolerance, and specific requirements of the migration project .

Please find the Migration guide: SQL Server to Azure SQL Managed Instance

Thank You!

Answer 2

Hi @Naveen Kumar Kakarla (Quadrant Resource),

This guide helps you migrate your SQL Server instance to Azure SQL Managed Instance and Azure SQL DB, you may take a reference to.

Migration guide: SQL Server to Azure SQL Database

Migration guide: SQL Server to Azure SQL Managed Instance

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.