Our use of cookies

We use cookies to tailor your experience, gather analytics, and provide you with live assitance. By clicking "Accept" or continuing to browse our site you agree to the use of cookies. For more details please read our Cookie Policy.

Our knowledge base is currently being reorganised: if you do not find the information you are looking for please try the following options:

How do I re-sync all data from scratch?

Sometimes, it may happen that you need to re-sync all data from scratch in the database; for example, some tables became corrupted, or certain data have been deleted by mistake.

If that is the case, this is how to force SQList to perform a complete re-sync.

If you would like to recreate all tables:

  1. Stop the SQList service;
  2. Drop all tables created by SQList in the database, including the two named "(SQList.Sites)" and "(SQList.SyncStatus)";
  3. Re-start the service;
  4. SQList will recreate everything from scratch.

If instead you only want a complete re-sync of the data:

  1. Stop the SQList service;
  2. Delete all rows from the tables "(SQList.Sites)" and "(SQList.SyncStatus)";
  3. Re-start the service;
  4. SQList will keep the tables and check all data from scratch, and re-sync only where necessary.