Microsoft是否在Visual Studio中删除对SDF数据库文件的支持？ [英] Is Microsoft dropping support for SDF database files in Visual Studio?

问题描述

在Visual Studio 2013中，不再有一个选项可以在WebPages（WebMatrix）网站中创建 .sdf SQL Server Compact数据库。我不能再在Visual Studio中查看 .sdf 数据库文件。我下载最新版本的WebMatrix打开我的 .sdf 数据库，但WebMatrix崩溃时，我打开我的网站。当我创建一个新的空网站并添加现有文件时，它会崩溃。

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.

我搜索了一天查看和编辑我的 .sdf 数据库，没有什么工作。我无法再获得Navicat SQL Server应用程序来打开数据库。我无法让LinqPad打开一个 .sdf 数据库文件，我无法获得Compact Viewer打开或编辑 .sdf 数据库。 c c c c c 但它只显示前200行和，它不会让我编辑表。

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.

现在我完全被困了。如何查看和编辑 .sdf 数据库文件？

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

推荐答案

答案是肯定的：Microsoft正在静默地将支持（像通常的IMHO）放到Sql Compact Edition中。

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

它开始放弃VS2012中的Sql CE 3.5
它继续在Sql Management Studio 2012
中删除Sql CE，最后在VS2013中

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

您可以使用 CompactView 或安装SQL Server Compact Toolbox 扩展在VS2013或（我的首选解决方案）使用 Sql management Studio 2008

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

UPDATE感谢 Nicolas的评论

由Microsoft提及的 ：

As stated by Microsoft:

SQL Server精简版是以弃用模式运行的，没有新的版本
计划在不久的将来。最后一个版本SQL CE 4.0SP1（和早期版本
仍处于支持周期）将在其生命周期中继续支持
，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.

这篇关于Microsoft是否在Visual Studio中删除对SDF数据库文件的支持？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！