在离线 .mdb 文件和在线 .mdb 文件之间同步数据库
我想得到专家的建议,我试图找到解决问题的方法,不幸的是没有找到。我正在使用以下
- VS 2010
- .NET 4.0
- Windows 窗体
- OLEDB、.mdb 来存储数据库
我已经制作了 Windows 窗体应用程序,现在我想要数据库/.mdb 文件的两个副本,一个是脱机的,另一个是在线可用的,我想要同步两个文件,以防两端发生任何更改。我想要有关实施的描述方面的建议,特别是如果组件可用于完成此类工作。
I want suggestions from the experts, I ve tried to find the solution of the concern issue, unfortunately didn't able to find one. I am using the following
- VS 2010
- .NET 4.0
- Windows Forms
- OLEDB, .mdb for storing database
I ve made windows form application already, now i want two copies of a database/.mdb file, one is offline and other is available online, i want to sync both files in case of any changes have been made at either end. I want suggestions in terms of description regarding implementation specially if the components are available to do such sort of job.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
Jet 引擎有一个本机同步机制,称为 Microsoft Jet 和复制对象 (MS JRO),您可能需要使用它。 这是参考,并且有一个请在此处查看一些代码示例。
The Jet engine has a native synchronisation mechanism, called Microsoft Jet and Replication Objects (MS JRO), which you may want to use. This is the reference, and have a look here for some code samples.
我发表了一篇关于在线离线数据库同步的文章。在这里您可以找到如何同步多个数据库(相同架构)。应该有一个主数据库,其他数据库将根据它进行更新。你可以试试这个: http://blog.ankitverma.com/2010/03 /onlineoffline-database-synchronization/
I posted an article upon on-line off-line database synchronization. here you can find how to synchronize multiple databases (same schema).there should be one master database and others will be updated according to it. you can try this : http://blog.ankitverma.com/2010/03/onlineoffline-database-synchronization/