How to connect to SQL Server CE file using SSMS

2019-03-22 19:21发布

问题:

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)?

回答1:

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

UPDATE: My SQL Server Compact Toolbox now supports SSMS 16 and 17

Reference: Discontinued Management Tools Features in SQL Server 2012