将离线(本地桌面应用程序)数据库与中央服务器和多台电脑同步的最简单解决方案?
我有一个使用本地数据库的桌面应用程序。 (这可以是 SQLite、SqlCe、PostgreSQL 或我能够在本地安装的任何其他数据库,我还没有决定使用哪一个。)
计划是实现以下目标:
用户可以订阅某种云服务。如果他这样做,他的本地数据库应该与在线数据库同步(所有用户一个,或者每个用户一个,无论最简单的解决方案是什么),这样他就能够在多台 PC 之间同步他的本地数据库数据,可以在线访问他的数据。 (就像 dropbox 对文件所做的那样。)
实现这一目标的最佳、最简单(最好是最便宜)的解决方案是什么?我正在研究 DataObjects.net,但找不到太多有关其同步功能的文档。或者,还有其他选择吗?例如,我从某种允许本地缓存的云服务开始,并为未订阅该服务的用户使用本地缓存。
欢迎任何指示、提示或经验。
I have a desktop application which uses a local database. (This can be SQLite, SqlCe, PostgreSQL or any other database I will be able to install locally, I haven't decided which one to use yet.)
The plan is to achieve the following:
A user can subscribe to some kind of cloud service. If he does his local database should be synced with the online database (one for all users, or one per user, whatever the easiest solution is) so he will be able to sync his local database data between multiple PC's, can access his data online. (Much like dropbox does for files.)
What is the best, easiest (and preferably cheapest) solution to achieve this? I am looking into DataObjects.net but I can't find much documentation about their Sync feature. Or, are there other alternatives? For example, I start with some kind of cloud service which allows local caching and use the local caching for users who do not subscribe to the service.
Any pointers, tips or experiences are welcome.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
OData 可用于同步数据:
http://nicksnettravels.builttoroam.com/post/2010/08/03/OData-Synchronization-with-WCF-Data-Services.aspx
此示例并非特定于您的要求,但可以用作一个起点。
OData can be used for sync data:
http://nicksnettravels.builttoroam.com/post/2010/08/03/OData-Synchronization-with-WCF-Data-Services.aspx
This example is not specific to your requirement, but can be used as a starting point.
也许您可以通过查看 Microsoft 来尽可能接近开箱即用的解决方案同步框架。到目前为止,我还没有亲自尝试过这个框架,但它看起来很有希望,希望它能像描述的那样工作。
Maybe you get as near as possible to an out of the box solution by taking a look into the Microsoft Sync Framework. Till now i didn't try the framework on myself, but it looks promising and hopefully it will worked as described.