每次都完全同步表（即不是增量的） [英] Full sync of table every time (i.e. not incremental)

问题描述

我无法在源数据库上实施更改跟踪。 但我希望我的客户端数据库（SQL Server CE）至少在我的应用程序启动时刷新。 这导致我认为每次
同步时我必须放弃并重新创建客户表。 这可能吗？ 如何？

I am not able to implement change tracking on my source database.  Yet I want my client database (SQL Server CE) to refresh at least at my application's startup.  This leads me to think I must drop and re-create the client tables each time during the sync.  Is this possible?  How?

推荐答案

同步框架v2.1 SqlSyncProvider或DbSyncProvider使用触发器来跟踪已更改的内容。如果无法做到这一点，您可以在服务器和SQLCe同步数据库之间创建同步关系，并使它们保持同步。但对于真正的客户端，你可以
只需复制同步数据库并使用它。在这种情况下，将保存同步时间。只需要处理ce sync db，这仍然有一些好处。不确定这对您的情况是否有帮助。

Sync framework v2.1 SqlSyncProvider or DbSyncProvider uses triggers to track what has changed. If that's not possible, you could create a sync relatishiop between the Server and a SQLCe sync db and keep them in sync. But for the real client, you can just copy the sync db over and use it. In that case, sync time will be saved. Only coping of the ce sync db is needed, which still has some benefit. Not sure whether that may help in your case.

这篇关于每次都完全同步表（即不是增量的）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！