How to handle add/remove tables from scope
-
24 พฤศจิกายน 2552 22:56I didn't find any documentation about how to handle scope changes like adding/removing tables form one scope. The following is my implementation based a post from this forum. What I did is check if the table has been provisioned first. If it did, skip the creation of all the procedures, triggers and tracking table. If not, create them using SqlSyncScopeProvisioning. And update Scope_config table with new xml config_data.
The problem I observed is when I remove one table and then add it gain. The changes made between removing and adding is not synced. It seems correct based on sync framework's concept. But what I am expecting is those changes could be synced between two servers. Should I store sync timestamp at the moment of removing the table and sync from there when adding the table back? If anyone has any thoughts, please let me know. Thanks.
- ย้ายโดย Max Wang_Chinasoft 21 เมษายน 2554 22:28 forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
ตอบทั้งหมด
-
28 พฤศจิกายน 2552 9:24ผู้ดูแล
How exactly do you "remove/add" the table from/back to sync ? and did you check the tracking table for this base table to see if the changes you made were properly tracked ?
thanks
Yunwen
This posting is provided "AS IS" with no warranties, and confers no rights. -
30 พฤศจิกายน 2552 15:26For example, we have 3 tables: A, B and A_B. One scope is used to sync with these three tables. After a few times of sync, we do not need to sync A_B anymore, so A_B should remove from the scope. Or we have a new table C and Relationship table A_C. So the scope need to add A and A_C. What's the best practice to handle this? Thanks.
-
2 ธันวาคม 2552 0:13 Hello,
Dynamically changing scope definition (add / remove tables) is not a supported scenario currently.
Patrick- เสนอเป็นคำตอบโดย Patrick S. LeeMicrosoft 2 ธันวาคม 2552 0:13
- ทำเครื่องหมายเป็นคำตอบโดย Yunwen BaiMicrosoft, Moderator 3 ธันวาคม 2552 9:49
