与服务器离线数据库同步 [英] Offline database synchronization with Server

问题描述

我们正处于一个客户端 - 服务器架构，在远程服务器连接客户端离线。服务器本质上是一个SQL Server 2008中，有几张桌子，每万条记录。每个客户端应用程序（WPF）将需要存储服务器的数据复制其脱机使用（在SQL防爆preSS？）。理想情况下，当客户端应用程序启动时它会击中服务器获取那边的新变化，并同步其数据库具有相同的数据服务器（没有太多的用户交互）。

We are having a client-server architecture where client goes offline when connects remotely to server. Server is essentially a SQL Server 2008, with few tables each with thousands of records. Each client application (WPF) would require to store replica of Server data for their offline use (in SQL Express?). And ideally when client application starts up it would hit the server for fetching new changes over there and sync its database to have same data as of the Server (without much of user interaction).

我在寻找对C导向的解决方案100％$ C $，它可以部署到远程客户端无需耗时的安装过程或需要用户干预即可完成。我使用微软同步框架V1和ADO.NET同步服务来处理类似的情况在一年前。原来是用表重组噩梦，写的存储过程的所有其他更改跟踪场景，配料是痛苦了。微软最近发布了同步框架的更新版本有一些新的特点。我没有时间来评估这些功能呢。

I'm looking for 100% code oriented solution, which can be deployed to remote clients without time consuming setup procedures or that require user intervention to complete. I've used Microsoft Sync Framework v1 and its ADO.NET Sync Services to handle similar scenario a year ago. It turned to be a nightmare with table restructuring, writing SPROCs for every other change tracking scenarios, and batching was painful too. Microsoft has recent released an updated version of Sync Framework with some new features. I haven't got time to evaluate those features yet.

是否有任何其他工具/技术与服务器同步脱机数据库？示例，文档，建议是AP preciated。

Is there any other tools / technologies to synchronize offline databases with a Server? Samples, documentation, suggestions are appreciated.

推荐答案

我回到了同步框架，这一次用它与SQL Server 2008的效果比较好，而且我能够揭露同步功能，通过WCF。请看详细的code <一个href="http://stackoverflow.com/questions/1656652/syncing-sql-server-2008-databases-over-http-using-wcf-sync-framework">here在SO

I went back to sync framework and this time used it with SQL Server 2008. Results were better, and I were able to expose sync functionality over WCF. See detailed code here in SO

这篇关于与服务器离线数据库同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！