none
Change sync schema for a table in Sync Framework 2.1 RRS feed

  • Question

  • Using MSF 2.1 to sync between SQL and CE DB's. I have some issues how to deal with the Schema changes on the server side(i.e if Tables are already synchronized).

    1) If i add a new column to a Table that is already synchronized? Do i need to deprovision and provision once again?

    2) How to add a new table A to synchronisedScope (i.e a scope already existing)? Create a new scope consisting of tables (A and SynchronisedScope Tables).

    Any help is appretiated

    Thanks


    lavanyar
    Tuesday, December 7, 2010 3:27 PM

Answers

  • Sync Fx doesnt allow you to modify the scope definition either to add a table or modify the columns. so yes, you will have to deprovision and re-provision. note that if your client database has rows already, they will fire conflicts when you sync because Sync Fx will try to upload them as well and at the same time download the same rows from the server as well.

    • Proposed as answer by Ganeshan Thursday, December 9, 2010 5:54 PM
    • Marked as answer by Yunwen BaiModerator Tuesday, May 24, 2011 7:38 AM
    Tuesday, December 7, 2010 3:30 PM
    Moderator

All replies

  • Sync Fx doesnt allow you to modify the scope definition either to add a table or modify the columns. so yes, you will have to deprovision and re-provision. note that if your client database has rows already, they will fire conflicts when you sync because Sync Fx will try to upload them as well and at the same time download the same rows from the server as well.

    • Proposed as answer by Ganeshan Thursday, December 9, 2010 5:54 PM
    • Marked as answer by Yunwen BaiModerator Tuesday, May 24, 2011 7:38 AM
    Tuesday, December 7, 2010 3:30 PM
    Moderator
  • Thanks for quick reply,

    It will be hard to keep track on client side. since i can change schema on server side but to keep track of each client its going to become more complicated.

    Any suggestions?

     


    lavanyar
    Tuesday, December 7, 2010 4:30 PM
  • What is 'Fx'? Is that Sync Effects?
    Wednesday, May 11, 2011 8:37 PM