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.

Using SSIS to Export Lists from SharePoint to SQL Server – An Alternative Approach

If you are looking at exporting SharePoint List data to SQL server then one of the most common approaches is to use SQL Server Integration Services or SSIS to get the job done the steps are something like:

THIS IS A LONG AND PAINFUL PROCESS!
 
What’s more you will need to make changes every time your SharePoint list schema changes.
THERE MUST BE AN EASIER WAY? YES THERE IS!
What if I could show you how to set up continuous export of SharePoint list and library data including all blobs and attachments from MULTIPLE SharePoint lists and libraries in 5-10 minutes?  What if I told you this could also keep the SharePoint lists and library schemas up to date in sql server in normalised SQL Server database tables.
Take a look at AxioWorks SQList which is a lightweight windows service that requires no changes to your SharePoint infrastructure. It works with SharePoint 2007, 2010, 2013 and SharePoint online in Office365.  It will selectively replicate lists and libraries in a SharePoint site as a set of normalised tables to any SQL Server database.
Below is a demo of how you can get your SharePoint lists, libraries, files and attachment into normalised sql server databases and continuously replicate them in just a few minutes:

Latest articles

What went down at MS Ignite 2021: Power Automate and Power Virtual Agent Edition

14 Jan 2022

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

What went down in MS Ignite 2021 : Power Apps Edition

30 Dec 2021

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only do we get a view of all their […]
[read article]

AxioWorks Newsletter December 2021: How has 2021 been for you?

28 Dec 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

AxioWorks Newsletter November 2021: What has AxioWorks been up to?

03 Dec 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

What went down in MS Ignite 2021 : Power BI Edition

30 Nov 2021

When we talk about the biggest annual tech conferences of the year, Microsoft Ignite comes to mind where not only we get a view of all their product […]
[read article]

AxioWorks Newsletter October 2021: Focus on customer service and a webinar on its way

01 Nov 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Gain valueable Insights into your PowerApps using Application Insights

25 Oct 2021

Power Platform provides a great way for citizen developers to develop Apps using low-code /no-code tools like PowerApps, PowerAutomate, and PowerBI. […]
[read article]

AxioWorks Newsletter September 2021: Focus on our sales effort

18 Oct 2021

Hello Reader, Welcome to another exciting issue of our monthly Newsletter! Each month, we try our best to bring to you content that is relevant and […]
[read article]

Why use SQList to generate Power BI reports from SharePoint lists, rather than using the Power BI native connector to SharePoint?

18 Oct 2021

The main reason is that in practical terms using the native connector only works for small amount of data and simple queries. When you start using it […]
[read article]

SharePoint Online List vs SQL Server as Data Source in Power-BI

15 Sep 2021

Lists are primarily used as a source of data storage in the world of SharePoint and in most scenarios these lists can grow really fast especially if […]
[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

*