Is it possible reverse Sync databases from Azure SQL managed Instance to On-premises SQL Server 2019

Thyagarajulu B M 121 Reputation points
2023-07-03T10:13:01.32+00:00

Hi Team,

We have been migrating the databases from on-premises SQL server to Azure SQL MI using Azure data Studio.

Is there any migration tool to migrate the databases from Azure SQL MI to On-premises SQL server?

Is it possible reverse sync data between Azure SQL MI and On-premises SQL server

Azure Database Migration service
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
115 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 29,387 Reputation points Microsoft Employee
    2023-07-03T14:05:02.8733333+00:00

    Hi, @Thyagarajulu B M Welcome to the Microsoft Q&A forum and thanks for reaching out here.

    As I understand correctly you are asking if there is a migration tool to migrate databases from Azure SQL Managed Instance to On-premises SQL Server and if it is possible to reverse sync data between Azure SQL MI and On-premises SQL Server.

    You can follow this document Here which explains how to restore a database from Azure SQL Managed Instance to SQL Server using the Azure Portal.

    Let me know if this document helps or if you need any additional information.

    Regards

    Geetha


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.