azure synapse
#azure-synapse#migrate-to-sql-managed-instance

Migrate to SQL managed instance

This article shows you how to perform a SQL Server migration in Azure Arc to Azure SQL Managed Instance in the Azure portal for your SQL Server instance enabled by Azure A

This article shows you how to perform a SQL Server migration in Azure Arc to

Azure SQL

Managed Instance

in the Azure portal for your

instance enabled by Azure Arc.

You can try Azure SQL Managed Instance

for free

for up to a year.

is a fully managed lift-and-shift platform as a service (PaaS)

target to run your SQL Server workloads on the Azure cloud platform. After your SQL Server

instance is enabled by Azure Arc, you can assess your SQL Server data estate to identify an

optimal SQL Managed Instance configuration. Then you can migrate your SQL Server

databases to SQL Managed Instance directly from the Azure portal.

When your SQL Server instance is enabled by Azure Arc, you can:

Evaluate and assess whether your SQL Server instance is ready to migrate to SQL

Managed Instance.

Identify potential migration issues, and learn how to mitigate them.

Optimize for performance and cost with guidance around service tiers, configuration, and

sizing.

Discovery of SQL Server instances and generation of readiness reports happen automatically

every weekend, but you can start them manually at any time. The process takes only a few

minutes to complete. No extra configuration or setup is required.

First, you choose an appropriate SQL Managed Instance target and prepare your environment.

Then, you can migrate your SQL Server databases to SQL Managed Instance directly from the

Note

You can provide feedback about your migration experience.