将数据从本地数据库同步到远程数据库 [英] synchronize data from local data base to remote data base

问题描述

嗨
我正在使用sql server 2008 r2 ..

我正在客户端系统中运行pos系统..直接连接到远程服务器...
但我要->
客户端系统在该系统中具有自己的数据库..
因此在这种情况下，我的pos ..也可以在离线模式下运行...

并且应该有同步选项...因此，只要客户端单击同步"按钮
或用户首次登录应用程序时..

因此，本地数据库中的所有更改都应在删除数据库中进行更新.反之亦然.

请给我建议我如何执行同步操作

客户端数据库和远程数据库都具有相同的架构...

解决方案

有很多方法.最好的一个非常友好的是SyncService，它在.Net内部.您可以在这里查看:

http://msdn.microsoft.com/en-us/library/dd938879.aspx [ ^ ]

这是示例和代码的下载链接:
http://www.microsoft.com/download/en/details.aspx?id=16515 [ ^ ]

希望对您有所帮助，
干杯.

hi
i am using sql server 2008 r2..

i am running pos system in client system.. which is direct connected to remote server...
But i want ->
client system have own data base in there system..
so in that case my pos .. can run in offline mode too...

and there should be synchronize option ... so whenever client click on synchronize button
or when ever user login first time into application..

so all the changes in local data base should update in remove data base .. and vice versa..

Please give me suggestion how can i perform synchronize operation

both client and remote data base have same schema...

解决方案

There are a lot of methods. The best one which is very friendly is SyncService which is in .Net internally. You can take a look at it here:

http://msdn.microsoft.com/en-us/library/dd938879.aspx[^]

this is a download link for samples and codes:
http://www.microsoft.com/download/en/details.aspx?id=16515[^]

I hope it will help,
Cheers.

这篇关于将数据从本地数据库同步到远程数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！