How to Migrate SharePoint List data to sql server ?

Question

_{Friday, September 7, 2012 2:06 PM}

Hi,

I want to migrate a SharePoint list data to a a table in SQL server 2008.
can any one guide in doing so or is there any sample available for the same?

Thanks,

reddy

All replies (2)

_{Friday, September 7, 2012 2:23 PM}

Hi Reddy,

it depends on how big you list is

if you have few items i would suggest using data sheet view to copy the items or open with access and then copy the items

http://mscerts.programming4.us/sharepoint/SharePoint%202010%20%20%20Use%20the%20Datasheet%20View%20to%20Add,%20Edit,%20or%20Delete%20Items%20and%20Files.aspx

if its too big you can try using ssis 

you can use sharepoint webservices to acess data

http://social.technet.microsoft.com/wiki/contents/articles/3469.calling-sharepoint-webservice-in-the-ssis-package-en-us.aspx

http://dataqueen.unlimitedviz.com/2011/06/how-to-use-a-sharepoint-list-as-a-data-source-in-your-ssis-package/

http://msdn.microsoft.com/en-us/library/hh430809.aspx

_{Friday, September 7, 2012 2:31 PM}

First, create your database in SQL Management Studio with all the columns you want. From there you'll want to export your SharePoint list to Excel. I would recommend saving as a csv but if you want to keep it as Excel be sure to save as the older .xls format. Then go back to SQL Server Mgmt Studio. Connect to the desired database, right click then choose Tasks > Import Data. Choose data source: flat file for .csv or Excel for .xls. Just follow the prompts from there and you should get your data into SQL.