Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Need Steps to Migrate Sharepoint data into SQL Server

  Asked By: Amie    Date: Apr 19    Category: Sharepoint    Views: 1389

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?



2 Answers Found

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

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

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.

Related Topics:



Related Post