如何确定表的SQL Server Compact版本? [英] How can I determine what version SQL Server Compact a table is?

问题描述

我有一些在Windows CE应用程序中创建的.SDF表(访问表数据从服务器应用程序传递，并将其转换为SQL Server Compact记录/表).

I have some .SDF tables that are created in a Windows CE app (access table data is passed from a server app, and this is converted into SQL Server Compact records/tables).

我想从Visual Studio 2010的台式机中查看它们.但是，尝试在服务器资源管理器中创建新的数据连接时，选择两个"Microsoft SQL Server Compact"数据源(3.5和4.0)之一失败

I want to look inside them from my desktop machine in Visual Studio 2010. But attempting to create a new Data Connection in the Server Explorer, selecting either of the two "Microsoft SQL Server Compact" Data sources (3.5 and 4.0) fails.

当我选择3.5，然后选择测试连接"时，它告诉我:

When I choose 3.5 and then "Test Connection," it tells me:

这不是有效的SQL Server Compact数据库文件，或者当前的SQL Server Compact Engine不支持此文件版本.

This is not a valid SQL Server Compact Database file or this file version is not supported by current SQL Server Compact Engine.

当我选择4.0，然后选择测试连接"时，它告诉我:

When I choose 4.0 and then "Test Connection," it tells me:

不兼容的数据库版本.如果这是兼容文件，请运行修复.对于其他情况，请参考文档. [Db版本= 0，请求的版本= 0，文件名= MyRecalcitrantTable.SDF

Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 0, Requested version = 0,File name = MyRecalcitrantTable.SDF

是否可以建立与这些表的连接，以便我可以查询它们以查看其中包含什么?如何确定使用哪个版本创建它们(显然是在3.5之前)，以便可以使用VS的早期版本来查看它们(或其他一些工具)?

Is there a way to make a connection to these tables so I can query them to see what they contain? How can I determine which version they were created with (apparently prior to 3.5) so that I can possibly use an earlier version of VS to view them (or some other tool?)

推荐答案

您可以使用我的SQL Server Compact Toolbox VS扩展，它具有检测文件"版本功能，但它们可能是2.0版文件，并且只能在以下位置打开Windows ce设备(或仿真器)

You can use my SQL Server Compact Toolbox VS extension, it has a Detect file version feature, but they are probably version 2.0 files, and can only be opened on a Windows ce device (or emulator)

这篇关于如何确定表的SQL Server Compact版本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！