allenkent
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.
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.
You could do this with PowerShell. There are other ways of course, but PowerShell might be a good solution for you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
https://www.youtube.com/watch?v=O0OjT_VEObI
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.
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.