Migrate managed databases to Azure SQL

Patrick 1 Reputation point
2020-09-16T16:56:35.76+00:00

We have multiple instances of SQL Managed Instances running and are looking to move our databases to Azure SQL with an elastic pool. I see documentation on migrating from on premise to Azure SQL but what is the best method to bring over databases from an Azure SQL Managed Instance?

Azure Database Migration service
{count} votes

1 answer

Sort by: Most helpful
  1. Ronen Ariely 15,081 Reputation points
    2020-09-17T12:43:12.467+00:00

    Good day @Patrick ,

    It's great question and you are probably right. I made a short search and I did not found any documentation on doing so. With that being said, this is really simple and there are multiple option to make a copy of the database but if you want to take the safe road then your best solution is probably to create Transactional replication and to push the data to the Azure SQL Database. For more information about Transactional replication with Azure SQL Managed Instance, check the following document:

    https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-transactional-overview

    Note 1: Azure SQL Data Sync does not support Azure SQL Managed Instance.

    Note 2: Using Export and import is not a safe way since using bacpak does NOT guarantee transactional consistency ! You might lose data or worse get data which is not consistent

    0 comments No comments