Link to home
Start Free TrialLog in
Avatar of allenkent
allenkentFlag for United States of America

asked on

Export Sharepoint 2010 LIST to SQL nightly

I have a SharePoint 2010 Foundation and I would like to have a single list exported and then imported into my SQL 2008 (or 2005) machine. I need this because I need to build a clean automated email report nightly. Currently I have Data Source with SharePoint List data source type but the reporting is limited.

What is my best option? My true goal is to get this list into a SQL table so I can build real reports using Visual Studio.
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image

You could do this with PowerShell. There are other ways of course, but PowerShell might be a good solution for you.
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of allenkent

ASKER

This got me on the right path. The following video ended up answering step by step on how to do this process.

https://www.youtube.com/watch?v=O0OjT_VEObI
Avatar of G4lly
G4lly

You can also look at AxioWorks SQList which will continuously export SharePoint Online and SharePoint onpremise lists, libraries, files and attachments into normalised SQL Server Tables.

Really useful when wanting to write complex SSRS reports or if you want to surface the data on the web etc via ASP .NET etc.