Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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 Bai Tuesday, May 24, 2011 7:38 AM
    Tuesday, December 7, 2010 3:30 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    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 Bai Tuesday, May 24, 2011 7:38 AM
    Tuesday, December 7, 2010 3:30 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    What is 'Fx'? Is that Sync Effects?
    Wednesday, May 11, 2011 8:37 PM