Share via

Azure SQL Replicate

Handian Sudianto 6,096 Reputation points
2023-02-25T08:07:35.8566667+00:00

Hello, it's possible to replicate SQL databse on Azure SQL Server to SQL Server on-prem?

Azure SQL Database
0 comments
Accepted answer
  1. Ronen Ariely 15,206 Reputation points
    2023-02-25T08:31:52.33+00:00

    Hi,

    it's possible to replicate SQL databse on Azure SQL Server to SQL Server on-prem?

    yes, with some limitations.

    It is well documented here:

    https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql&WT.mc_id=DP-MVP-5001699

    If the limitation does not fit your case, then you can sync data which is not the same but might solve your need:

    https://www.sqlshack.com/how-to-set-up-azure-data-sync-between-azure-sql-databases-and-on-premises-sql-server/

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.