Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Need Steps to Migrate Sharepoint data into SQL Server

  Asked By: Amie Goodwin         Date: Apr 19, 2010      Category: Sharepoint      Views: 246
 

I need steps to migrate my Sharepoint data into SQL Server.
I had data in the form of XML files in Sharepoint. I need to place the XML data into SQL Server.
What is best way to migrate the data from Sharepoint to SQL?

Tagged:                  

 

2 Answers Found

 
Answer #1       Answered By: Julia Washington          Answered On: Apr 19, 2010       

As far as I know, you will have to write .Net code: Infopath form data  are stored in "standard" xml  file that can be read by .Net code.
It is quite easy to loop through each ListItem (SPListItem class), to read the file(SPListItem.File property), to parse it and to insert the data into sql  server.
Do you want to keep the Xml format or do you want to store the data in native sql format ?

 
Answer #2       Answered By: Shashwat Takle          Answered On: Apr 19, 2010       

From my perspective I would like to save the whole XML as table record.
Since SQL 2005 already support XML type, then we can do normal query. And we have benefit having original data, and no parsing in export-import process. Thus, if in the future we need to restore the data  we still have the original data - or may be we need additional information, we still have the original

 
Didn't find what you were looking for? Find more on Need Steps to Migrate Sharepoint data into SQL Server Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].