This is a continuation of the
Configure a SQList replication and export SharePoint lists and libraries to SQL Server with the Replication Wizard article where "Export from this site and its sub-sites" is selected as part of the replication.
Step 4: Select which sub-sites to export
At this point you are presented with the list of all sub-sites that belong to your SharePoint site (the root site is also included).
You have two ways to select which sub-sites you want SQList to export; this is determined by the "By Default" selection:
- Export only the sub-sites selected below: using this option, SQList will only export the sub-sites that you select in the table below. This is the mode to use if you only want to export certain sub-sites onto your SQL database.
- Export all sub-sites, except those excluded below: using this option, SQList will export all sub-sites in your SharePoint site, with the exception of those you de-select in the table below. Be aware that in this mode, SQList will automatically export new sub-sites added to the SharePoint site at a later stage.
Once you select a default option, you can override it for individual sub-sites by selecting:
- Export sub-site: select or deselect this checkbox to include or exclude the sub-site from being exported;
For our example, we choose to export all sub-sites.
Step 5: Select the lists you want to export
The list selection at this stage works exactly like the list selection for a single site, but there is a major difference behind the scene:
- the list presented, is not the list of individual SharePoint lists belonging to all sub-sited, but the distinct list of the names of all lists across all sub-sites (apologies for excessive use for the word "list"...).
This means that with this type of export, you cannot select an individual lists but only all lists by specific names.
For example, for the "
Products" list, SQList will export all lists named "
Products" across all sub-sites.
One additional option you have with this mode, is to "
Generate a unified view of all lists with the same name". If you select this option, SQList will automatically create a view, in the destination SQL database, that select all items from all lists with the same name, across all sub-sites.
For example, taking the "Products" list mentioned above, SQList will create a view that select all items from all "Products" lists across all sub-sites.
That is it, click "Next >" to export your data.
Step 6: Complete
After saving your changes and starting the SQList service, the lists you selected will be exported as normalised tables in the destination database.
And you're done!
This is all you need to do to get your SharePoint lists exported as normalised tables into your SQL Server database.
Click "Finish" to save your changes and start the SQList Service.
When the SQList Service is started, SQList Manager switches to the "Service Status" tab, from where you can monitor the correct functioning of SQList. If there are errors,they will be displayed in the "Event Viewer" window.
You can also use the "Table Status" tab to send us an "Event Report" in case you are getting errors that you cannot resolve. When we receive an Event Report we get back to you as soon as possible.
And that is it. You can now take a look at your SQL database and see the tables being created and populated by SQList.
Note that you do not need to keep SQList Manager open for the replication to continue as that is done by the SQList Service in the background.