Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does a .NET technology for synchronizing local and remote SQL server databases exist? [closed]

1) I am having a desktop application (machine A) using C# and SQL Server. I have another local machine (machine B) it also has its own SQL server instance. I want to synchronize A’s database with B’database. This process should happen in a time interval.

2) I also have an ASP.NET web application running on web server (machine C). I also want to synchronize A’s database with C’s database. (SQL Server as well.)

I have to develop a solution for this problem. The problem is I am not quite sure what technology I am going to use. I have to use a .NET technology or similar Microsoft technology. Our main application was written in C#.

like image 626
Thabo Avatar asked Jan 30 '12 21:01

Thabo


2 Answers

I would use Red Gate. http://www.red-gate.com/products/sql-development/sql-comparison-sdk/

They do a great job with both data and schema synchronization.

like image 125
Hogan Avatar answered Sep 28 '22 19:09

Hogan


SQL Server replication can do this for you. It uses a publish-subscribe approach. I think you may be looking for "merge" replication.

This one-page article will give you some highlights.

And this will tell you all the details.

Edit: Seeing that you are interested in pricing, replication is in all versions of SQL Server, but its functionality is very limited on the lower-end versions. However, if you have a higher-end version, it's included already.

like image 24
DOK Avatar answered Sep 28 '22 19:09

DOK