VS2008 Cannot Read SQL Server Compact 3.1 SDFs?

Category: sql server ce

Question

Mimosa Arts on Mon, 29 Apr 2013 19:08:28


So I've got converted VS2005 smart device app in VS2008 but still point to SSCE 3.1 as the CE database and this works fine with the 3.1 SDF database.  On my new box I have SQL Server 2008 r2 installed.  But I cannot view the SDF in SQL Server 2008.  Do I have to install SQL Server 2005 just to open and edit these SDFs?

Replies

ErikEJ on Tue, 30 Apr 2013 06:43:34


A few of the tools on my list here support SSCE 3.1: http://erikej.blogspot.dk/2009/04/sql-compact-3rd-party-tools.html - or you can use SSMS 2005 Express SP2 http://www.microsoft.com/en-us/download/details.aspx?id=15366

Please mark as answer, if this was it. Visit my SQL Server Compact blog Windows 8 Apps Showcase