none
Table schema change RRS feed

  • Question

  • Hi,

    We have an issue with Sync Framework.

    We have updated the DB Schema (add new column to an existing table "MyTable") on the client and server side.

    But on the client side when synchronising, there is a missmatching with the _Bulkinsert SP generetared by Sync Framework (column added is missing)

    So we have checked the "Table Type" and the new column recently added is missing and also in the SP bulkdelete, delete, insert, etc...

    We have found a solution is to delete all SP and Table Type, start a synchronisation and SP and Table Type are created properly.

    How can we avoid this operation and manage that case by code ?

    Thank you

    Friday, June 15, 2012 6:32 PM

All replies

  • Sync Fx will not automatically modify the scope definition to match schema changes. so you either deprovison and reprovision  or hack the sync fx objects to add/remove a column in the scope.

    Sunday, June 17, 2012 12:42 PM
    Moderator