Is Microsoft dropping support for SDF database files in Visual Studio?

database visual-studio sql-server-ce
jAsOn picture jAsOn · Sep 3, 2013 · Viewed 42.2k times · Source

In Visual Studio 2013 there is no longer an option to create .sdf SQL Server Compact databases in WebPages (WebMatrix) websites. I am no longer able to view .sdf database files in Visual Studio either. I downloaded the latest version of WebMatrix to open my .sdf database but WebMatrix crashes when I open my website. When I create a new empty site and add existing files, it crashes.

I searched for days for a way to view and edit my .sdf database and nothing is working. I can no longer get Navicat SQL Server app to open a database. I cannot get LinqPad to open an .sdf database file, I cannot get Compact Viewer to open or edit .sdf databases. I can open .sdf databases with SqlCEToolbox40.exe but it only shows top 200 rows and it won't let me edit the tables.

Now I'm completely stumped. How do I view and edit a .sdf database file?

Answer

giammin picture giammin · Oct 24, 2013

The answer is yes: Microsoft is silently dropping support (as usual IMHO) to Sql Compact Edition.

It started abandoning Sql CE 3.5 in Vs2012 It continued dropping Sql CE in Sql Management Studio 2012 and finally in VS2013

You can use CompactView or install SQL Server Compact Toolbox extension in VS2013 or (my prefered solution) use Sql management Studio 2008

UPDATE thanks to Nicolas' comment

As stated by Microsoft:

SQL Server compact edition is in deprecation mode with no new releases planned near future. Last release SQL CE 4.0SP1 (and earlier releases that are still in the support cycle) will continue to be supported through its lifecycle and Microsoft is committed to fix any major, production blocking issues found in these releases.

Related questions

How do you create a foreign key relationship in a SQL Server CE (Compact Edition) Database?

Visual Studio 2005 doesn't provide an interface for creating relationships between tables in a SQL Server CE database (I'm using version 3.0) and you can't open a Compact Edition DB using Management Studio as far as I know. Any ideas?

Read More
Generating entity relationship diagram in Visual Studio 2015

Can you tell me how I can generate an ER diagram for my database1 (see below) created with VS 2015 Thanks in advance

Read More
C# (Visual studio): Correlation between database, dataset, binding source

I am just learning C# through Visual Studio 2008? I was wondering what exactly is the correlation between dabases, datasets and binding sources? As well, what is the function of the table adapter?

Read More