开发者

Synchronizing two SQL Server databases using MS Sync Framework

I have one central SQL Server database which can be offline from time to time. I have a desktop application using Local DB Cache (SQL CE) to synchronize with the central database and I also have a web application with its own SQL Server that I'd also would like to keep synchronized. All synchronizations must be bidirectional.

Is there a way to synchronize my central database with web applicatio开发者_如何学Pythonn's database in the same way as I synchronize my central database with desktop client?

I know about collaboration scenarios and peer-to-peer synchronization but I would like to avoid manual provisioning of databases. I'd like to use integrated sql server 2008 change tracking just like in the SQL CE <--> SQL Server scenario.


I had the same question once: sync framework server to server synchronization
In the end i did the syncronization myself(using stored procedures) and it wasn't that hard. Or you can use replication(in my project there was a term to use as little traffic as we can, so i've implemented my own mechanism for my needs)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜