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.

Exporting SharePoint Documents and Metadata to SQL Server

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.

Latest articles

AxioWorks Newsletter February 2024: Partnerships, Upcoming SQList Update, and Summit Invitation

27 Feb 2024

Hello Reader, This February has been pivotal for AxioWorks as we’ve focused on laying strong foundations for the year. Here are the key […]
[read article]

How AxioWorks SQList Aligns With the Priorities of Software Buying Decision Makers

26 Feb 2024

As outlined in the “2024 Global Software Buying Trends” report by Gartner Digital Markets, the criteria that predominantly influence […]
[read article]

Maximising Power BI Reporting from SharePoint: The Strategic Advantage of AxioWorks SQList over Native Connectors

15 Feb 2024

In today’s data-driven environment, making informed decisions rapidly can offer a significant competitive edge. This is where Power BI comes […]
[read article]

AxioWorks Newsletter January 2024: A Promising Start to the New Year!

29 Jan 2024

Hello Reader, We hope this newsletter finds you well and thriving. At AxioWorks, we are embracing the new year with great enthusiasm and are […]
[read article]

Exciting New Partnership and Innovative SharePoint Tools from AxioWorks and Lightning Tools

17 Jan 2024

AxioWorks is excited to announce a strategic partnership with Lightning Tools, a leader in creating innovative SharePoint components. This […]
[read article]

AxioWorks Newsletter November 2023: ESPC23, new partnership, and SQList update!

30 Nov 2023

Hello Reader, Welcome to this month’s edition of the AxioWorks newsletter! We’re thrilled to bring you updates on our recent […]
[read article]

Why Support Legacy SharePoint Versions Like SharePoint 2010?

16 Nov 2023

In the fast-paced world of technology, where new versions and updates are continuously rolled out, a recurring question often arises: “Why […]
[read article]

Why Companies are choosing SQList over Power Automate

30 Oct 2023

In the realm of synchronisation services, AxioWorks’ SQList and Microsoft’s Power Automate (earlier known as PowerApps) have emerged as […]
[read article]

AxioWorks Newsletter October 2023: An exhilarating month.

28 Oct 2023

Hello Reader, As we step into the season of autumn, we are thrilled to share with you the latest developments and opportunities unfolding at […]
[read article]

Why Choose SQList for SharePoint Data Extraction Over DIY Solutions

16 Oct 2023

In the ever-evolving world of technology and data management, the question often arises: “Why should I use a product like #SQList when I can […]
[read article]

Get SharePoint and SQL news to your inbox

Stay up-to-date with industry news and trends, SQL and SharePoint innovations and all the latest from AxioWorks by subscribing to our monthly newsletter.

Subscribe to the AxioWorks newsletter

*