This project is read-only.

How to Open/Explore SQL CE DB

Feb 6, 2011 at 9: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.


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 9:26 PM

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

Feb 6, 2011 at 10:24 PM

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