如何使用SSMS连接到SQL Server CE文件 [英] How to connect to SQL Server CE file using SSMS

问题描述

我正在使用SSMS 2012并尝试连接到由Orchard创建的SDF.根据此答案，我应该可以选择 SQL Server Compact Edition 作为服务器类型，但这不是一个选择.我需要安装什么东西吗?我最初是否错过了部分安装(设置SSMS时)?

I am using SSMS 2012 and trying to connect to the SDF created by Orchard. According to this answer, I should be able to select SQL Server Compact Edition as the Server type when connecting my object browser, but that isn't an option. Is there something I need to install? Did I miss part of the install originally (when setting up SSMS)?

推荐答案

SSMS 2012不再支持SQL Server Compact，我在这里列出了Microsoft和其他公司提供的可用工具:

SQL Server Compact is no longer supported in SSMS 2012, I have a list of available tools from Microsoft and others here: http://erikej.blogspot.dk/2009/04/sql-compact-3rd-party-tools.html

更新:我的SQL Server Compact工具箱现在支持SSMS 16和17

参考: SQL中已停用的管理工具功能Server 2012

这篇关于如何使用SSMS连接到SQL Server CE文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！