SyncFramwork 和 SQL Server
我正在使用 SyncFramework 我有一张表。因为我必须向上同步一些列，向下同步一些列，向上和向下同步一些列......
我怎样才能在客户端和服务器的单一模式中做到这一点......dbs......
有没有机会。 ..如果不可能，请告诉我如何为每个...侧面和每个方向编写不同的模式...
以下是我的表中的列：
**Column Direction**
AddressID x both
AddressIDpda
AccountID x down
Line1 x down
Line2 x down
Line3 x both
Line4 x both
ApartmentNumber x down
City x down
StateOrProvince x down
PostalCode x down
ObjectID x down
ObjectType x down
CreatedOn x Both
ModifiedOn x both
MoveToCRM x both
twg_PDAupdated x up
twg_PDAcreated x up
twg_User x up
I am using SyncFramework I have one table. In that I have to sync some columns up and some columns down and some columns up and down.....
How can I do this in a single schema for client and server....dbs...
Is there any chance... if not possible please tell me how to write different schemas... for each...side and each direction....
The following are columns in my table:
**Column Direction**
AddressID x both
AddressIDpda
AccountID x down
Line1 x down
Line2 x down
Line3 x both
Line4 x both
ApartmentNumber x down
City x down
StateOrProvince x down
PostalCode x down
ObjectID x down
ObjectType x down
CreatedOn x Both
ModifiedOn x both
MoveToCRM x both
twg_PDAupdated x up
twg_PDAcreated x up
twg_User x up
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
最简单的方法是定义 3 个具有不同对象前缀或模式的范围。然而，您最终会得到多个同步对象（例如，9个触发器、24个插入/更新/删除存储过程、3个选择更改存储过程等...）
，或者您可以侵入范围配置表，以便同步框架调用您的自定义存储过程以不同方式插入/更新列。
the easiest you can do this is to define 3 scopes with different objectprefix or schema. you will however end up with multiple sync objects (e.g., 9 triggers, 24 insert/update/delete stored procs, 3 select changes stored procs, etc...)
or you can hack your way into the scope config table so that sync framework calls your custom stored procs for inserting/updating columns differently.