I would like to migrate databases from one Azure SQL Managed instance to another and from Azure SQL Managed instance to Azure SQL DB. What is the best approach for it with minimum downtime for 5TB database?
I have checked a few approaches like:
Data migration service- Doesn't support Azure Managed Instance as source.
Failover group- It doesn't support same region secondary.
Copy/Move- This cannot be used as the current databases are in failover group.
Is there any other way to migrate with minimum downtime?
Thanks!
1条答案
按热度按时间ddarikpa1#
You can use Transactional Replication for this.