开发者

Is there a "Not For Replication" equivalent in Sync Framework

开发者 https://www.devze.com 2023-02-22 05:55 出处:网络
I\'m looking for a way to prevent triggers from f开发者_运维技巧iring during a synchronization in Sync Framework 2.1.This was a no brainer with the \"Not For Replication\" attribute when using MS SQL

I'm looking for a way to prevent triggers from f开发者_运维技巧iring during a synchronization in Sync Framework 2.1. This was a no brainer with the "Not For Replication" attribute when using MS SQL replication.


unfortunately, there is none in the Sync Fx SDK. you can however programmatically disable the triggers (sending "DISABLE TRIGGER ON ) before the sync and enabling it afterwards. please note though that the tracking tables will be out of sync with the base table (e.g., you may have deleted rows but the tracking doesnt have the tombstone records for it)

0

精彩评论

暂无评论...
验证码 换一张
取 消