I am having the task to copy the data of a Sharepoint list into the three different sql tables.
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.