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.

How to run SQList from command line

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

Important: if you are running version 8 and multiple instances, you need to append the instance name to the command line; e.g.:

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

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.