SharePoint 和 SQL Server Compact 数据文件
我正在为一家组织从事咨询工作，希望获得比 Access 数据库更进一步的功能。一般来说，他们想要跟踪校园内建筑物之间的网络线路（显然，我有点混淆了，就这样吧）。当然，他们希望在 SharePoint 中完成，而无需因用户数量有限而付出巨大的软件开发和维护工作。
因此，我们的想法是通过 Infopath 表单（以及一些用于一些基本报告功能的自定义代码）进行初始数据输入。但是，由于存储的数据量很大，SharePoint 列表将无法正常工作。
是否可以将单个 SQL Server Compact sdf 文件发布到 SharePoint 文档库来保存此数据？ （公司的 DBA 很令人讨厌）。我知道 SDF 文件有 4 GB 的限制。
I'm doing a consulting job for an organization wanting something a small step above what an Access Database would do. Generally, they want to track network lines between buildings on their campus (obviously, I'm obfuscating a bit, just go with it). And of course, they want it done in SharePoint, WITHOUT a huge software development and maintenance effort due to a limited number of users.
So, the idea is to do initial data entry via an Infopath form (and some custom code for a few basic reporting features). However, SharePoint lists aren't going to work due to the amount of data being stored.
Is it possible to publish a single SQL Server Compact sdf file to, say, a SharePoint document library to hold this data? (DBAs for the company are being obnoxious). I'm aware of the 4 GB limit on SDF files.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是可能的，但如果文件大小 > ，您可能会遇到真正的麻烦。 30MB。
SharePoint 旨在存储“正常”大小的协作文档，这些文档通常平均为 100 KB。 800KB - 2MB 之间。这些文档作为 BLOB 存储在 SQL Server 和 SharePoint 搜索索引中（如果您打开了索引）。
It is possible, but you could be asking for real trouble if the file size is > 30 MB.
SharePoint was designed to store "normal" sized collaboration documents which typically avg. between 800KB - 2MB. These documents are stored as BLOBs in SQL Server and in the SharePoint Search index (if you have indexing turned on).