将SharePoint列表与SQL表同步 [英] Sync SharePoint List with SQL table

问题描述

大家好，

有没有方法可以将SharePoint列表与SQL表同步.我无法创建外部列表，因为它是现有列表.或者在BCS中，我们可以使用现有的SharePoint列表进行同步吗?

Is there way to sync SharePoint List with SQL table .I can't create external list because is it existing list. Or In BCS can we use existing SharePoint list for synchronization ?

推荐答案

KKNW，

我们无法使用现有列表使用bcs进行同步.首先是创建一个ect，其次是创建与自定义共享点列表完全不同的外部列表.

We cannot use an existing list for synchronizaion using bcs. First things is creating an ect and second is to create the external list which is completely different to custom sharepoint list. 

我建议您编写一个控制台应用程序以将列表数据移动到数据库，然后创建ect和外部列表.  

What i suggest you to write a console application to move your list data to database and then create ect and external list.  

下面是供您参考的几个链接-

Below are few links for your reference-

https://stackoverflow.com/questions/8855127/real-time-sync-from-sharepoint-to-sql-server

https://stackoverflow.com/questions/8855127/real-time-sync-from-sharepoint-to-sql-server

https://social.technet.microsoft.com/Forums/lync/zh-CN/6b85bd9d-4dfb-4750-9912-0b1b67790e68/syncing-sharepoint-list-data-with-sql-server-table?forum = sharepointgeneralprevious

https://social.technet.microsoft.com/Forums/lync/en-US/6b85bd9d-4dfb-4750-9912-0b1b67790e68/syncing-sharepoint-list-data-with-sql-server-table?forum=sharepointgeneralprevious

https://social.msdn.microsoft.com/Forums/sharepoint/zh-CN/9cf5628d-0537-496a-a307-8173705aee80/synchronization-sharepoint-list-with-sql?forum=sharepointdevelopmentlegacy

https://social.msdn.microsoft.com/Forums/sharepoint/en-US/9cf5628d-0537-496a-a307-8173705aee80/synchronization-sharepoint-list-with-sql?forum=sharepointdevelopmentlegacy

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