I was wondering how to append data from a SQL Server database to another on a second computer. I've already used the MERGE method by setting the source and target table from the same SQL Server but this time the case is different. I'm trying to retrieve records from 2 standalone POS machines in a grocery stores to the server.

Is there any easy way to achieve this? Is a SQL Server stored procedure using the computer's name or ip address the way to go?

CodePudding user response：

we have solved this problem on many projects and it depends on the scenario of your synchronization, whether it is a manual or automated etc.

In one project, we finally programmed our own synchronization service in .NET. But today we prefer products that offer this functionality out-of-the-box. I personally have experience with DevArt Data Compare, which works great, can be automated and can synchronize data from multiple sources into one (https://www.devart.com/dbforge/sql/datacompare/). In our case, we used it to synchronize from a production server to several test servers via Data Compare and it is orchestrated from one asset.

In addition to Data Compare we also used SymmetricDS (https://github.com/JumpMind/symmetric-ds) which is now unmaintained and is offered in a commercial version (https://www.jumpmind.com/products/symmetricds/overview). It is definitely a good tool but for us the Data Compare from DevArt was better in terms of price and it is able to solve most synchronization scenarios for a good price.

Regards.