managed instance link between 2 managed instances

Fatih Korhan 5

Hello,

We have databases running on Azure SQL Managed Instance. We would like to move this database instance to another resource group without any interruption. We are considering using the managed instance link for this purpose.

My question is: Does the managed instance link work between two managed instances?

Thank you.

ShaktiSingh-MSFT 15,336 Reputation points

2024-07-22T14:29:27.14+00:00

Hi Fatih Korhan •,

Welcome to Microsoft Q&A forum.

As I understand, you want to move Azure SQL Managed Instance from one Resource Group to another using Managed Instance link.

Managed Instance link feature enables near real-time data replication between SQL Server and Azure SQL Managed Instance.

I am checking on this internally and will get back.

Thanks for your patience.
Fatih Korhan 5 Reputation points

2024-07-23T06:18:01.15+00:00

Hi @ShaktiSingh-MSFT ,

I hope it's working between 2 managed instances. I'm waiting your response.

Thank you.

1 answer

ShaktiSingh-MSFT 15,336 Reputation points

2024-07-24T08:43:35.88+00:00

Hi Fatih Korhan •,

Thanks for your patience.

We have got the below reply from the internal team:

No,

MI Link does not work explicitly as a feature for moving data, but we have Database Copy & Move functionality: Copy or move a database - Azure SQL Managed Instance | Microsoft Learn

Thanks
Please sign in to rate this answer.
Fatih Korhan 5 Reputation points

2024-07-24T12:24:15.8733333+00:00

Hi @ShaktiSingh-MSFT ,

Copy & move don't work for us. but thanks for your effort.

Fatih Korhan 5 Reputation points

2024-07-24T12:38:21.8833333+00:00

Hi @ShaktiSingh-MSFT ,

Copy & move function doesn't work for us. But thanks for your effort.

ShaktiSingh-MSFT 15,336 Reputation points

2024-07-25T05:42:29.02+00:00

Hi Fatih Korhan •,

Could you please let us know the issue with Copy/Move in your case so that we can assist?

Thanks

Fatih Korhan 5 Reputation points

2024-07-25T11:36:33+00:00

Hi @ShaktiSingh-MSFT ,

We want to migrate our managed instance along with all its databases while ensuring minimal downtime. We are unable to utilize the copy/move option due to the following reasons:

Stopping the managed instance before migration results in significant downtime due to the time required for copying all data.

Continuing migration operations without stopping the managed instance leads to potential data loss.

We need to copy data near-real time, after that we can make migration operations with minimal downtime.

Please advise on the best approach to achieve this migration with minimal impact on our operations.

ShaktiSingh-MSFT 15,336 Reputation points

2024-07-26T04:09:36.4+00:00

Hi Fatih Korhan •,

Thanks for the reply.

Let me check on this and come back.

ShaktiSingh-MSFT 15,336 Reputation points

2024-07-29T04:19:10.6266667+00:00

Hi Fatih Korhan •,

Reply from internal team is:

There is no need to stop the instance.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

managed instance link between 2 managed instances

1 answer

Your answer