SharePoint to SQL server

Question

My requirements is
1.how to fetch data from SharePoint online to SQL server using scheduler.
2. The job scheduler must be written in c# console application.

Rajkiran Swain · Accepted Answer

I would suggest to use the REST API and write the custom code to extract the data in to your external database as needed. and don't use console . The perfermance wise, it will impact your application .     refer the below link . http://www.axioworks.com/2017/04/5-ways-to-export-sharepoint-data-to-sql/

Nanddeep Nachan · Answer

Azure function could be one of the better option.

Nanddeep Nachan · Answer

Example of creating an azure function: https://docs.microsoft.com/en-us/azure/azure-functions/functions-create-first-azure-function

Satyaprakash Samantaray · Answer

Hi Raj, thats good idea actually due to performance issue rest API is a better choice.
Can you share any sample project

Satyaprakash Samantaray · Answer

Can anyone share any sample project?

Satyaprakash Samantaray · Answer

hi nanddeep can you give a sample demo through code