How do you reset a single table for synchronization? RRS feed

  • Question

  • I am using DownloadOnly synchronization to SQLCE on the client and there are times when I need to reset a single synchronized table but leave other tables that are scynchronized intack.  What is the best way to reset a single table in the database so that it will reload all of the data the next time it is synchronized?
    Wednesday, June 2, 2010 4:31 PM


All replies

  • Hey,

    You could try to do a dummy update on a column of the table you want to reload and next time it will be synced again.



    Ann Tang
    Wednesday, June 2, 2010 6:20 PM
  • Doing a dummy update on a column does not seem to help.  I keep getting the following error when I change the table schema:

    Data Definition Language (DDL) operations are not allowed on this table, or on any system table or tracked user table.  Disable tracking before you run DDL operations.

    and I have not found anything that will let be disable tracking in SQLCE

    Friday, June 4, 2010 6:31 PM
  • Try

    Update tableName1 set column1 = column1

    Ann Tang
    Friday, June 4, 2010 11:26 PM