Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

     

    Thanks, 

    Ann Tang
    Wednesday, June 2, 2010 6:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    Try

    Update tableName1 set column1 = column1

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