将SharePoint Online与本地SQL Server同步 [英] sync SharePoint Online with On-Premises SQL Server

问题描述

如何编写读取/获取SharePoint Online文档库并保存所有列(元数据+文档)并将其保存到SQL Server数据库的服务.

How to write a services which reads/gets SharePoint Online document library and save all columns (metadata + document) and save it into SQL Server database.

基本上，我想将SharePoint Online数据/文档库与本地SQL Server同步.然后，我将开发一个Web应用程序，该应用程序可以从本地SQL Server搜索和下载文档.

basically i want to sync SharePoint Online data / document library with On-Premises SQL Server. Than i will develop an web application which search and download document from On-Premises SQL Server.

请指导，是否可行以及如何开始.

Please guide, is it possible and how to get started.

Thx

iffi

推荐答案

嗨

您可以通过Visual Studio编写控制台程序.

You can write a Console Program by Visual Studio.

并且您可以引用Net Client Object Module来在SharePoint Online中阅读文档.

And you can reference Net Client Object Module for read the document in SharePoint Online.

然后在本地写入SQL Server或SharePoint.

Then write to SQL Server or SharePoint On Premises.

您可以在客户端服务器或PC中为任务计划部署控制台程序.

You can deploy the Console Program for a Task Schedule in Client Server or PC.

参考链接:

https://docs.microsoft.com/zh-cn/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-code

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/complete-basic-operations-using-sharepoint-client-library-code

这篇关于将SharePoint Online与本地SQL Server同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！