0

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!

Rajan
  • 43
  • 5
  • The only other methods I have used is copying the database using bacpacs and Storage Accounts or using Backups/Restore. Both are time-consuming tasks. – Alberto Morillo Jul 14 '23 at 12:46

1 Answers1

0

You can use Transactional Replication for this.

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67
  • Hi David, thanks, transactional replication will help replicating the databases across managed instance and azure SQL DB but i am worries about the additional load it will generate on the production instance. – Rajan Jul 15 '23 at 13:48
  • Yes. The resource consumption is mostly on the instance hosting the distribution database which can be remote. – David Browne - Microsoft Jul 15 '23 at 14:05