SharePoint site synchronized with SQL database

Question

I am building a SharePoint site with several SharePoint lists.

I want to synchronize those SharePoint lists with a SQL database.

How should I do?

Answer 1

Hi @Miguel Moreira da Silva ,

It seems that you are using SharePoint Online, right?

If so, there are some choices for your reference:

1, Business Connectivity Services (BCS) should meet your needs. But it's a feature that's about to be retired. The official recommendation is that you use Power Apps instead. But Power Apps is currently not supported in the Q&A forum, you can learn more about Power Apps. If you encounter any problems, you can go to the Power Apps Community to create a new discussion.

2, I found a blog that introduced sync SharePoint list to SQL Database using Microsoft Flow & Azure Function App:

https://technovert.com/blog/sync-o365-sharepoint-list-data-to-azure-sql-db-table-using-microsoft-flow-azure-function-app/

3, Use third-party tools.

For your reference:

https://techcommunity.microsoft.com/t5/sharepoint-developer/sharepoint-list-sync-with-sql-server-database/m-p/4633

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.