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


in visual studio 2013 there no longer option create .sdf sql server compact databases in webpages (webmatrix) websites. no longer able view .sdf database files in visual studio either. downloaded latest version of webmatrix open .sdf database webmatrix crashes when open website. when create new empty site , add existing files, crashes.

i searched days way view , edit .sdf database , nothing working. can no longer navicat sql server app open database. cannot linqpad open .sdf database file, cannot compact viewer open or edit .sdf databases. can open .sdf databases sqlcetoolbox40.exe shows top 200 rows and won't let me edit tables.

now i'm stumped. how view and edit .sdf database file?

the answer yes: microsoft silently dropping support (as usual imho) sql compact edition.

it started abandoning sql ce 3.5 in vs2012 continued dropping sql ce in sql management studio 2012 , 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 nicolas' comment

as stated microsoft:

sql server compact edition in deprecation mode no new releases planned near future. last release sql ce 4.0sp1 (and earlier releases still in support cycle) continue supported through lifecycle , microsoft committed fix major, production blocking issues found in these releases.


Comments

Popular posts from this blog

html - How to style widget with post count different than without post count -

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

javascript - storing input from prompt in array and displaying the array -