One interesting feature of SQList is that it can be used to export files from SharePoint and SharePoint Online to SQL Server and SQL Azure along with the associated metadata and then keep that data in constant synch. SQList is a unique windows service that will synchronize SharePoint lists and libraries including binary content like files and attachments to a normalised set of SQL Server tables. All tables and mappings are taken care of by the software so it can be set up in minutes. No changes are required to SharePoint or SQL Server.
Here are some of the features of SQList:
- Continuously exports SharePoint lists and documents to single or multiple SQL Server databases.
- Dynamically builds a normalised set of SQL tables.
- Export sub-sites automatically: export lists and libraries from a SharePoint site and its sub-sites in a single replication.
- Union view: SQList can automatically generate an aggregated SQL view of similar lists and libraries across a site structure.
- Quick setup with granular selection of lists, libraries, and sites to export.
- Can be installed anywhere and does not require any changes to SharePoint.
- You only need one license to export data from different SharePoint servers.
- Uses standard SQL and HTTP connections and can connect via local network or the Internet.
- No need to map tables and columns, SQList will do that for you.
- No list view threshold issues, SQList uses native SharePoint change tracking capabilities which negates the requirement to add indexes to columns or to increase that pesky list view threshold.
- Expose your SharePoint data to SQL Server Reporting Services (SSRS).
- Supports all versions of SharePoint including SharePoint Online.
- Supports all versions of SQL Server including SQL Azure.