打开 SQL Server Management Studio，或者如果它正在运行，请选择“文件”->“连接对象资源管理器...
在“连接到服务器”对话框中，将服务器类型更改为 SQL Server Compact Edition
从数据库文件下拉列表中选择
浏览更多...>
打开您的 SDF 文件。
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.
You might also be able to use later editions of SSMS. For 2016, you will need to install an extension.
If you have the option you can copy the sdf file to a different machine which you are allowed to pollute with additional software.
Update: comment from Nick Westgate in nice formatting
The steps are not all that intuitive:
Open SQL Server Management Studio, or if it's running select File -> Connect Object Explorer...
In the Connect to Server dialog change Server type to SQL Server Compact Edition
From the Database file dropdown select < Browse for more...>
You can open SQL Compact 4.0 Databases from Visual Studio 2012 directly, by going to
View ->
Server Explorer ->
Data Connections ->
Add Connection...
Change... (Data Source:)
Microsoft SQL Server Compact 4.0
Browse...
and following the instructions there.
If you're okay with them being upgraded to 4.0, you can open older versions of SQL Compact Databases also - handy if you just want to have a look at some tables, etc for stuff like Windows Phone local database development.
(note I'm not sure if this requires a specific SKU of VS2012, if it helps I'm running Premium)
发布评论
评论（3）
下载并安装 LINQPad，它适用于 SQL Server、MySQL、SQLite 以及 SDF (SQL CE 4.0)。
打开 SDF 文件的步骤：
单击添加连接
选择自动构建数据上下文，然后< strong>默认 (LINQ to SQL)，然后下一步。
在提供程序下选择SQL CE 4.0。
在数据库下选择附加数据库文件，选择浏览以选择您的.sdf文件。
单击确定。
Download and install LINQPad, it works for SQL Server, MySQL, SQLite and also SDF (SQL CE 4.0).
Steps for open SDF Files:
Click Add Connection
Select Build data context automatically and Default (LINQ to SQL), then Next.
Under Provider choose SQL CE 4.0.
Under Database with Attach database file selected, choose Browse to select your .sdf file.
Click OK.
尝试 Microsoft 的 SQL Server Management Studio（2008 版或更早版本）。 从此处下载。不确定许可证，但如果您下载 EXPRESS EDITION，它似乎是免费的。
您也许还可以使用 SSMS 的更高版本。对于 2016 年，您将需要安装扩展。
如果您可以选择可以将 sdf 文件复制到另一台计算机，您可以使用其他软件污染该计算机。
更新：尼克韦斯特盖特的评论格式很好
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.
You might also be able to use later editions of SSMS. For 2016, you will need to install an extension.
If you have the option you can copy the sdf file to a different machine which you are allowed to pollute with additional software.
Update: comment from Nick Westgate in nice formatting
您可以直接从 Visual Studio 2012 打开 SQL Compact 4.0 数据库，方法是转到“
并按照其中的说明进行操作。
如果您同意将它们升级到 4.0，您也可以打开旧版本的 SQL Compact Databases - 如果您只想查看一些表等以进行 Windows Phone 本地数据库开发等内容，这会很方便。
（请注意，我不确定这是否需要 VS2012 的特定 SKU，如果它对我运行 Premium 有帮助）
You can open SQL Compact 4.0 Databases from Visual Studio 2012 directly, by going to
and following the instructions there.
If you're okay with them being upgraded to 4.0, you can open older versions of SQL Compact Databases also - handy if you just want to have a look at some tables, etc for stuff like Windows Phone local database development.
(note I'm not sure if this requires a specific SKU of VS2012, if it helps I'm running Premium)