SQL Compact 到 SQL Express 实时合并/同步
我有一个应用程序当前使用 SQL Compact Edition 作为其数据库来捕获实时数据。 我的一些用户希望编写自己的应用程序，以便在我的应用程序捕获这些数据时查询和报告这些数据。 但是，SQL Compact 版本与我的应用程序一起在进程内运行，因此不允许外部进程连接到它。
我正在考虑使用一种方法将此数据实时复制到用户提供的外部数据库服务（SQL Express 或标准 SQL Server），然后他们可以在我的应用程序继续写入 SQL 时使用该数据进行查询/报告袖珍的。
关于最佳方法有什么建议吗？ 我读过一些有关同步框架的内容，但它似乎更针对批量同步，而我需要（相对）接近实时的同步。
我很好奇其他人是否遇到过类似的情况以及他们是如何解决这个问题的。 任何建议将不胜感激。
I have an application that currently uses SQL Compact Edition as its database for capturing realtime data. Some of my users would like to write their own applications to query and report against this data while it's being captured by my application. However, SQL Compact edition runs in-process with my application and therefore does not allow outside processes to connect to it.
I'm considering using an approach to replicate this data in real-time to an outside database service provided by the user (SQL Express or standard SQL Server) that they could then use to query/report against while my application continues to write to SQL Compact.
Any recommendations on the best approach for this? I've read a bit about the Sync Framework, but it appears to be more targeted at batch sync-ing, whereas I need to sync in (relatively) near real-time.
I'm curious if other folks have run into similar scenarios and how they have addressed this. Any suggestions would be greatly appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您打算让用户在已经运行 SQL CE 的计算机上安装 SQLExpress，为什么不让您的“实时”应用程序直接写入 SQLExpress？ 当然这只是对连接字符串的更改？
If you're going to have your users install SQLExpress on the machine that is already running SQL CE, why not get your "real time" application to write directly into SQLExpress? Surely it's only a change to a connection string?