使用 Visual Studio 2012 和 SQL Server Management Studio 2012 运行 SQL Server CE 4 查询 [英] Running SQL Server CE 4 Queries with Visual Studio 2012 and SQL Server Management Studio 2012

问题描述

我最近升级到 Visual Studio 2012 和 SQL Server Management Studio 2012，但是我似乎看不到如何在 SQL Server CE 4.0 数据库上执行 SQL 脚本(由实体框架创建).使用 VS2010 + SSMS 2008，Transact-SQL 编辑器会要求连接，您可以浏览到对象，但是此选项在 SSMS 2012 中不可用.

I have recently upgraded to Visual Studio 2012 and SQL Server Management Studio 2012, however I cannot seem to see how to execute SQL scripts (created by Entity framework) on a SQL Server CE 4.0 database. With VS2010 + SSMS 2008 the Transact-SQL editor would ask for a connection and you could browse to the object, however this option is not available in SSMS 2012.

我尝试通过服务器资源管理器 -> 新查询窗口执行脚本，但出现解析错误.有什么线索吗?

I have tried to execute the script via the Server Explorer -> New Query window, but I get parse errors. Any clues?

推荐答案

Microsoft 获得了 摆脱了 SSMS 2012 的，并建议改用 WebMatrix 中的集成工具(从内存中，找不到链接，抱歉).

Microsoft got rid of that for SSMS 2012, and suggested to use the integrated tools in WebMatrix instead (from memory, can't find a link for that sorry).

正如 Microsoft Answers 帖子，但是，您可以使用 SQL Server Compact Toolbox，它非常有效.

As suggested in that Microsoft Answers post, however, you could use the SQL Server Compact Toolbox, it's pretty effective.

这篇关于使用 Visual Studio 2012 和 SQL Server Management Studio 2012 运行 SQL Server CE 4 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！