Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to connect to SQL Server CE file using SSMS

Tags:

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

like image 634
zimdanen Avatar asked Apr 26 '13 20:04

zimdanen

People also ask

How do I connect to a database in SSMS?

Connect to a SQL Server instance Start SQL Server Management Studio. The first time you run SSMS, the Connect to Server window opens. If it doesn't open, you can open it manually by selecting Object Explorer > Connect > Database Engine. For Server type, select Database Engine (usually the default option).

How do I connect to a SQL Server Management Studio registered server?

To connect to a registered server If the Registered Servers pane is not visible, select View > Registered Servers. In Registered Servers, right-click a server, point to Connect, and then select Object Explorer.

1 Answers

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

like image 196
ErikEJ Avatar answered Oct 07 '22 02:10

ErikEJ
Sign in to Comment

Related questions

Is there a safe alternative to std::equal?
java.lang.ClassNotFoundException: org.hibernate.ejb.HibernatePersistence
How do I put a constraint on SciPy curve fit?
Parallel.ForEach vs AsParallel().ForAll
Build variants in Gradle for a Library Project in Android
Can a foreign key act as a primary key?
create a custom sequential global dispatch queue
Writing tests for a sidekiq worker
8086- why can't we move an immediate data into segment register?
Is there a way to test if a variable is dynamic?
How can I skip JRE code when debugging in Eclipse?
Parsing returned HTML from jQuery AJAX request

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!