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.
104 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 28,542 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