同步框架 2.1 未完成同步
我正在使用同步框架从 Sql Server 2008 R2 数据库同步数据。当我在计算机上从安装的 wpf 应用程序或 Visual Studio 运行同步时，一切都会正确同步。
当我在另一台机器上安装该程序时，会出现此问题。当我查看 Sql Profiler 中运行的查询列表时，似乎同步正在运行，但是更改并未分配给 sqlce 数据库。
I am using sync framework to sync datat from an Sql Server 2008 R2 database. when I run sync on my machine, from the installed wpf application or from visual studio, everything syncs properly.
The problem occurs when I install the program on another machine. It seems like the sync runs , when I look at the list of queries running in Sql Profiler, however the changes are not propergated to the sqlce data base.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
跟踪客户端上发生的情况。您可能会明白为什么没有插入行。请参阅以下 MSDN 文章如何：跟踪同步过程
Trace what happens on the client. You'll probably see why the rows are not being inserted. See the following MSDN article How to: Trace the Synchronization Process
我有一个非常相似的问题：
我们正在使用同步框架将多个站点同步到中央服务器。在生成数据的系统升级之前，一切都运行良好。现在在某些站点中我遇到插入错误，一些与 FK 约束有关，一些与尝试将 Null 插入不可为空列的正常插入有关。
据我所知，_selectchanges SP 返回一些不存在的行或包含无效数据，这会导致bulkinsert SP 中出现错误。
解决方法是重新配置范围并重新同步所有数据，从而解决问题。
我正在尝试找到根本原因，以便我可以处理它，重新同步所有数据对我们来说并不是很好的解决方案，而且并不总是可行。
有什么想法或想法吗？
编辑：
数据库架构与以前相同，仅更改了数据。
I have a very similar problem:
We are using sync frame work to sync multiple site to central server. everything was working very well until the system producing the data was upgraded. now in some site i get insert errors, some about FK constraints and some about normal inserts trying to insert Nulls to non null-able columns.
from what i could find the _selectchanges SP is returning some non existing rows or with invalid data which then causes the errors in bulkinsert SP.
A workaround is to re-provision the scope and re-sync all data this straightens things out.
I'm trying to find the root cause so i can handle it re-syncing all data is not very good solution for us and not always possible.
Any thoughts or ideas?
Edit:
DBs schema is the same as before, only data is being changed.