sql-server database-migration azure-sql-managed-instance

Migrate databases across Azure SQL Managed Instance

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!

Solution

You can use Transactional Replication for this.

Query to find position in a string before keyword and extract data before that position
Correlate these tables dynamically (or automated)
Manage the order of updates when using a filtered unique index?
How to use an UPDATE Query with an INNER JOIN to update fields within a table
Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
What are row, page and table locks? And when they are acquired?
Aggregate into custom groups
Work with multiple where statements with different conditions
Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
How can I find sql server port number from windows registry?
SSIS OLE DB Destination Editor - Create New Table not an option?
How to Apply Gridify Filtering on an ICollection<T> in EF Core?
SQL Server Cursor vs WHILE loop
How do I control parameter sniffing and/or query hints in entity framework?
Select with like is not returning the correct results
I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
using Object_id() function with #tables
Conditionally filter results of query based on a single flag
Fill down from a specific row based on criteria
Spark sending LIMIT to SQL Server on display function
database restore failing with move
Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
different deleting OUTPUT behaviour based on source table
How to simulate a deadlock in SQL Server in a single process?
Is "SET NOCOUNT OFF" necessary in a stored procedure?
EF Core takes a lot of time, sometimes, to perform SELECT query
Dynamic T-SQL - Alter column definition to max length of field
SQL Server: Update table based on JSON
Best index(es) to use for an OR Statement in SQL Server
In a select with a group by, get the last value of a column not in the group by