SQList Manager
SQList Manager provides an interface to monitor and control the SQList service, and to specify the details of the source SharePoint sites and target SQL Server databases.
Target Databases
Firstly specify your target database server, server instance and login details, mixed mode authentication is supported. Up to 20 target databases can be entered if using SQList Professional, 5 with SQList Standard and 1 with SQList Entry.
SharePoint Sites to Export
Once your target databases are specified, simply enter the URLs for the SharePoint sites you wish to export along with a SharePoint user account that has at least read access to those sites. For each site you can choose one or more of your target databases to be exported to.
Start the Service
Once the new configuration is saved and deployed, the service is started. The status tab displays all status and replication events logged by the service, which are also stored in the Windows event log.
Normalised Tables Generated
In SSMS we can see the newly created tables for lists, document libraries and list attachments, prefixed with the site name entered in the SQList Manager. List attachments are stored in their own tables as binary objects.
SharePoint Columns Created and Tables Populated
Querying the tables generated from the list, we see columns have been created and populated.
Continuous Export
When you add new list items, documents, lists, and libraries to SharePoint they are rapidly echoed to your target database (by default, the service checks for changes every 10 seconds).
