SQL Server Database Replication

sidhardh abhimanyu 1 Reputation point
2022-10-24T11:29:25.893+00:00

HI All,

Currently we have All the databases are in Shared VM Sql Server instance , because of the speed and load issues ,

we are planning to move one of data bases to sql server instance hosted on azure vm , so the expected system looks like this

253429-screenshot-2022-10-21-at-60421-pm.png

so some of the apps will connect to shared hosting instance and mobile app users can connect to azure instance ( these 2 databased need to be in sync)

i tried merge replication ,but because its adding extra column (rowguid) to the tables our apps are not working while the replication runs

any other solution to achieve this two way sync ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,961 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,471 Reputation points
    2022-10-25T07:42:13.37+00:00

    Hi @sidhardh abhimanyu ,

    Please refer to these documents:
    What is SQL Data Sync for Azure?
    Tutorial: Set up SQL Data Sync between databases in Azure SQL Database and SQL Server
    You can learn how to set up SQL Data Sync by creating a sync group that contains both Azure SQL Database and SQL Server instances.
    Hope this would give you some idea.

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

  2. Erland Sommarskog 112.7K Reputation points MVP
    2022-10-24T21:52:10.223+00:00

    i tried merge replication ,but because its adding extra column (rowguid) to the tables our apps are not working while the replication runs

    So you are confessing that you are using SELECT *? Or else why does the application stop working?

    Since you are considering Merge Replication, I take it that there are updates in both places? That is obviously a challenge, since you easily can get update conflicts.

    I believe Transactional Replication can be bidirectional. Then you can of course implement homegrown solutions that are tailored for your needs. (And sometimes it makes sense. And sometimes it makes absolutely no sense at all:)


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.