How to fully re-sync data from server to client RRS feed

  • Question

  • I established a incremental synchronization between client and the server using SQL tracking. And I want to know if there is a way to re-download all the data from server and overwrite my local file if necessary.

    For example, I made some changes on my local SqlCE, but I'd like to discard all the local changes and re-download the data from server to client.

    Sunday, April 11, 2010 12:48 PM


  • here's your options:

    1. Delete your sdf and create a new, empty sdf. If your table creation option is set to CreateNewTableOrFail, it will re-create the tables

    2. Retain the sdf but set the table creation option to DropExistingOrCreateNewTable or TruncateExistingOrCreateNewTable

    3. Just re-run the Local Database Cache Designer wizard.


    Sunday, April 11, 2010 1:02 PM