0

I am having the task to copy the data of a Sharepoint list into the three different sql tables. enter image description here

Sql table details are:

cLetterSection

SectionID(Identity column)

SectionLanguage(depends on image header if "section" then English, if "section_1031" then German)

SectionName(section column value will be populated here)

cLetterConfig

ConfigID(Identity column)

Language(depends on image header if "section" then English, if "section_1031" then German)

SectionID(foreign key from cLetterTemplate table)

Option(option column value will be populated here)

cLetterReasonRel

ConfigID(foreign key from cLetterConfig table)

CancellationReasonGroupCode(applicableTo column value will be populated here)


Actually I am the new in this area, could any one suggests how to do this.

  • what is the SharePoint version 2010 or 2013& above ? – TARUN Feb 21 at 7:17
  • It has Sharepoint version 2010. – Dipesh Tare Feb 21 at 8:31
0

You can CSOM or SSOM to fulfill you requirement

You can create a console app to copy the data from the sharepoint lists to SQL tables. Please userSharePoint 2010 CSOM dll as mentioned in the Nuget package manager for SP 2010 SharePoint.Client.dll - CSOM for this purpose

please check the below for the reference

https://social.msdn.microsoft.com/Forums/azure/en-US/31f2fd7d-ff7b-4fe1-95a1-4070b96068cb/programmatically-insert-list-items-to-sql-server-table?forum=sharepointdevelopmentprevious

  • I am not getting any thing. – Dipesh Tare Feb 21 at 10:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.