How to connect to SQL Server CE file using SSMS

sql-server-ce ssms ssms-2012
zimdanen picture zimdanen · Apr 26, 2013 · Viewed 26.2k times · Source

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

Answer

ErikEJ picture ErikEJ · Apr 27, 2013

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

Related questions

How can I manage SQL CE databases in SQL Server Management Studio?

I created a SDF (SQL CE) database with Visual Studio 2008 (Add / New Item / Local Database). Is it possible to edit this database with SQL Server Management Studio? I tried to attach it but it only offered .mdf and attaching a .…

Read More
Microsoft SQL Compact Edition rename column

I am having problems renaming a column in SQL Server Compact Edition. I know that you can rename a table using sp_rename, but this doesn't work with columns. I've searched for an alternative, but haven't found one. Can I …

Read More
How do you open an SDF file (SQL Server Compact Edition)?

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 …

Read More