On selected editions, it is possible to run a SQList synchronisation on demand, rather than as a service that continually checks for changes. This is useful when you do not need to have changes in SharePoint immediately replicated to SQL server, but rather at schedule intervals (e.g. once a day).

SQList can run as a console application, so it can be executed in a command prompt window, a batch file, or as a schedule job (e.g. using Windows task scheduler).

To run a synchronisation, simply execute SQList as follow:

"C:\Program Files\AxioWorks\SQList\AxioWorks.SQList.ReplicationService.exe" singleCycle

The singleCycle parameter instructs SQList to stop running after one synchronisation cycle, rather than keep checking for changes indefinitely. All log messages will be sent to the SQList log, accessible via SQList Manager.

A few notes:

  • The executable AxioWorks.SQList.ReplicationService.exe is located in the SQList installation folder, by default: C:\Program Files\AxioWorks\SQList;
  • SQList must be run with administrator privileges;
  • If there are errors, SQList will not retry the replication but proceed to the end of the cycle.