从SharePoint Access Web数据库迁移到SQL Server [英] Moving from SharePoint Access web database to SQL server
问题描述
大家好，
看不到将数据从SharePoint Online上的Access Web数据库迁移到SQL数据库的明显方法.仅成功迁移了表定义.
Can't see an obvious way to migrate data from Access web database on SharePoint Online to SQL database. Successfully migrated table definitions only.
谢谢.
Paul
推荐答案
Paul，
当我们在Access 2010中设计Web数据库并将其发布到SharePoint时，发布过程将创建一个SharePoint网站，并且所有数据库对象和数据都将移动到该网站的SharePoint列表中.
When we design a Web database in Access 2010 and publish it to SharePoint, the publishing process creates a SharePoint site and all of the database objects and data are moved into SharePoint lists in that site.
因此，在您的情况下，数据存储在SharePoint Online列表中.
So in your case, the data stores in SharePoint Online list.
如果要将这些数据移动到sql数据库，则可以将此列表导出到excel，然后将此excel文件导入到sql server.
If we want to move this data to sql database, we can export this list to excel and import this excel file to sql server.
参考:
https://www.linkedin.com/pulse /5-way-export-sharepoint-data-sql-server-paul-gallagher
B 问候，
Grace Wang
Grace Wang
这篇关于从SharePoint Access Web数据库迁移到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
