Our blog

In this post I’m going to summarise all the updates to SQList in v5 releases (5.0, 5.1, 5.2, 5.3 and 5.4 at the time of writing) It’s probably worth saying that upgrades from v4 are available to all SQList customers who subscribe to our preventive maintenance plan. If you like more information about his or a would like a quote for an upgrade please contact our sales department. There have been a few potentially breaking changes in as part of the SQList v5 releases! Look out for […]
[read article]

01 Apr 2017 | Share:

5 Ways To Export SharePoint Data to SQL Server SharePoint provides us with a great way of capturing and managing data which has seen a huge increase in business data stored in SharePoint On Premise and SharePoint Online lists and libraries. This often means we have the requirement to report against this data. SharePoint doesn’t always make this easy for us! We can install reporting services into a SharePoint site but it’s still not easy to report against the data. As a consequence of the […]
[read article]

01 Apr 2017 | Share:

We are proud to announce the release of SQList v5.3. Today we announce some great new features in our SQList 5.3 release, namely: Export SharePoint lists that exceed the list view threshold Export attachments, without binary data Duplicate site configurations and database connections Configurable timeout for SharePoint web service connections Various bug fixes Let’s look at these changes in a bit more detail: Export SharePoint lists that exceed the list view threshold SharePoint limits […]
[read article]

28 Mar 2017 | Share:

Set up a scheduled export of SharePoint lists and libraries to SQL Server Tables In this article we will see how to: Schedule exports of SharePoint lists and libraries to normalised SQL Server database tables without any development effort Use the windows task scheduler and SQList to provide automated replications of complicated SharePoint data structures Get around SharePoint list threshold and lookup threshold issues Make SharePoint data available to SSRS, PowerBI, Tableau, SAP HANA and […]
[read article]

05 Mar 2017 | Share:

We are proud to announce the release of SQList v5.0. The following new features have been added to this release: Warning: There are a few potentially breaking changes in this release! Look out for this symbol  Archive SharePoint Data in SQL / Maintain deleted list items in SQL tables We have added a setting that enables you to maintain deleted list items in the replicated SQL table. This can be useful it you want archive SharePoint list items to SQL server.To disable the removal of deleted […]
[read article]

02 Oct 2016 | Share:

Features include: Support for SharePoint 2007, 2010, 2013 and SharePoint Online in Office365 Exports all the lists and libraries in a SharePoint site as a set of normalised tables to any SQL Server database; Selective replication: precisely control the lists and files you wish to replicate; Parallel list sychronisation: replicate multiple sites and lists in parallel for enchanced performance; Continuously updates the target SQL tables (data and structure) as your SharePoint site changes, every […]
[read article]

12 Sep 2016 | Share:

As of SQList v5 Professional, we have added a feature that will allow SharePoint list and library items to be archived to a SQL Server table. What do I mean by this? We now have a setting that enables you to maintain deleted list items in the replicated SQL table. Once you have set up replication from a SharePoint lists or library to SQL server, using the SQList manager, items deleted in SharePoint will not be deleted in the corresponding SQL table. They will simply be marked as […]
[read article]

02 Sep 2016 | Share:

We’ve put together a 1minute video to explain our SQList tool: […]
[read article]

01 Jun 2016 | Share: