How to Open/Explore SQL CE DB

Feb 6, 2011 at 8:02 PM

To Open and/or explore the SQL CE DB do I need to have VS2010?  I thought I could use SQL Server Management Studio 2008 but I am getting the below error:

TITLE: Connect to Server
------------------------------

Cannot connect to C:\inetpub\wwwroot\TheNetheryFamily\App_Data\BlogEngine.sdf.

------------------------------
ADDITIONAL INFORMATION:

Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = \\?\C:\inetpub\wwwroot\TheNetheryFamily\App_Data\BlogEngine.sdf ] (SQL Server Compact ADO.NET Data Provider)


Feb 6, 2011 at 8:26 PM

Microsoft WebMatrix works great for viewing SQL_CE and it is free.

Feb 6, 2011 at 9:24 PM

You can also SQL Management Studio which is installed along with SQL Server.