Geek Answers Handbook

Is there .NET technology for synchronizing local and remote SQL Server databases?

1) I have a desktop application (machine A) using C # and SQL Server. I have another local machine (machine B), it also has its own instance of SQL server. I want to sync an As database with a Bdatabase. This process must be completed over a period of time.

2) I also have an ASP.NET web application running on a web server (C machine). I also want to synchronize the As database with the Cs database. (SQL Server also.)

I need to develop a solution to this problem. The problem is that I'm not quite sure which technology I will use. I have to use .NET technology or similar Microsoft technology. Our main application was written in C #.

+5
source share
4 answers

There are at least two MS tools you can use: SQL replication or Sync Framework .

It depends on how deep and complex your problem is. For example: do you need a finely tuned instrument or anything — synchronization at any time? In addition, another difference between the two is how you want to deal with “stand-alone concurrency conflicts”. If on your server A, B, C in your example, someone changes the record on server A, and B has a copy of the previous version, modifies and publishes it, which one should win in your scenario? Maybe the last, maybe the first, maybe no one?

SQL- SQL Server ( -). MS-Sync Framework .NET, - .

+3

SQL Server . -. , "merge".

.

this .

Change . When you see that you are interested in price, replication is performed in all versions of SQL Server, but its functionality is very limited in versions of the lower end. However, if you have a higher level version, it is already included.

+4
source

I suggest taking a look at Redgate Sql Compare and Sql Data Compare http://www.red-gate.com/products/

Do not waste time / money on the invention of the wheel :)

+2
source

More articles:


All Articles