Easiest way to extract SharePoint list data to a separate SQL Server table?

sharepoint etl sharepoint-api
BuddyJoe picture BuddyJoe · Nov 21, 2008 · Viewed 55.4k times · Source

Edited: What is the easiest way to scrape extract SharePoint list data to a separate SQL Server table? One condition: you're in a work environment where you don't control the SQL Server behind the SharePoint Server, so you can't just pull from the UserData table.

Is there there any utilities that you can use to schedule a nightly extract?

Is Microsoft planning any improvement here for "SharePoint 4"?

Update Jan 06, 2009:
http://connectionstrings.com/sharepoint
For servers where office is not installed you will need:
this download

Answer

Kevin I picture Kevin I · Dec 9, 2008

There is a SSIS SharePoint task you can use to grab the data info a regular dataflow: http://www.codeplex.com/SQLSrvIntegrationSrv

Related questions

Best way to resolve file path too long exception

I created a app that downloads all document libraries in a SP Site , but at one point it giving me this error (I tried looking at google but couldn;t find anything, now if anyone knows any trick to solve …

Read More
Auto number column in SharePoint list

In a SharePoint list I want an auto number column that as I add to the list gets incremented. How best can I go about this?

Read More
How do you upload a file to a document library in sharepoint?

How do you programmatically upload a file to a document library in sharepoint? I am currently making a Windows application using C# that will add documents to a document library list.

Read More