How do I open a SQL CE4 .sdf database file?

sql-server-ce-4
willem picture willem · Apr 8, 2011 · Viewed 27.9k times · Source

I installed Microsoft WebMatrix, which, I believe comes with SQL Server CE4. I've tried opening the SDF file in SQL Management Studio (SQL 2008), but I get the following error message:

-------- Microsoft SQL Server Management Studio: There is no editor available for 'C:\efTest\App_Data\SchoolRepository.sdf'.

Make sure the application for the file type (.sdf) is installed.

How do I view/modify my .sdf database?

I see there is a similar question on StackOverflow (http://stackoverflow.com/questions/4070860/sql-compact-4-0-cant-open-read-sdf-file) but I would really like to use Management Studio if I can, and not another 3rd party tool.

Answer

Christian Resma Helle picture Christian Resma Helle · Apr 8, 2011

Have you tried the SQL Server Compact Toolbox?

or the SQL Compact Query Analyzer?

Related questions

SQL: Return only first occurrence

I seldomly use SQL and I cannot find anything similar in my archive so I'm asking this simple query question: I need a query which one returns personID and only the first seenTime Records: seenID | personID | seenTime 108 3 13:34 109 2 13:56 110 3 14:22 111 3 14:31 112 4 15:04 113 2 15:52 Wanted result: personID | …

Read More
How can I upgrade my Sql Server CE 3.5 sdf database to Sql Server CE 4.0?

I need to update my SqlCE3.5 database to 4.0. I get the following error message when I'm trying to access my 3.5 sdf/database using the new CE4.0 connection provide :- System.Data.EntityException: The underlying provider failed on Open. ---> …

Read More
Unable to load the native components of SQL Server Compact

I've installed SQL Server Compact Edition 4.0 on Win7 x64 and it runs both for Asp.Net and Desktop Applications. This PC also have Visual Studio 2010 SP1 installed. But my Server 2008 R2 produces following error for Asp.Net applications, although it …

Read More