如何打开 SDF 文件(SQL Server Compact Edition)? [英] How do you open an SDF file (SQL Server Compact Edition)?
问题描述
我有一个 SDF 文件，我想检索它的架构并使用一些 UI 查询它.我怎样才能做到这一点?我的机器上没有安装 Visual Studio，我想安装尽可能少的软件.
I have an SDF file and I would like to retrieve its schema and query it with some UI. How can I do this? I have no Visual Studio installed on the machine and I would like to install as little software as possible.
推荐答案
尝试 Microsoft 的 sql server management studio(2008 版或更早版本).从这里下载.不确定许可证，但如果您下载 EXPRESS EDITION，它似乎是免费的.
Try the sql server management studio (version 2008 or earlier) from Microsoft. Download it from here. Not sure about the license, but it seems to be free if you download the EXPRESS EDITION.
您或许还可以使用更高版本的 SSMS.对于 2016 年，您需要安装扩展程序.
You might also be able to use later editions of SSMS. For 2016, you will need to install an extension.
如果您有选择，您可以将 sdf 文件复制到另一台允许您使用其他软件污染的机器.
If you have the option you can copy the sdf file to a different machine which you are allowed to pollute with additional software.
更新:来自 Nick Westgate 的评论，格式很好
Update: comment from Nick Westgate in nice formatting
这些步骤并不那么直观:
The steps are not all that intuitive:
- 打开 SQL Server Management Studio，或者如果它正在运行，请选择文件 -> 连接对象资源管理器...
- 在连接到服务器"对话框中，将服务器类型更改为 SQL Server Compact Edition
- 从数据库文件下拉列表中选择
- 浏览更多...>
- 打开您的 SDF 文件.
这篇关于如何打开 SDF 文件(SQL Server Compact Edition)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
