将SQL Server Express 2008与SQL Server 2005数据库一起使用-如何检查兼容性 [英] Using SQL Server Express 2008 with SQL Server 2005 database -how to check for compatibility

问题描述

我使用的是SQL Server 2008 Express Edition，但我希望在2005年使数据库保持静止。如何设置它以仅显示2005数据库可以使用的功能？

I am using SQL Server 2008 express edition but I want to make my databases still in 2005. How can I set it up to only show features that a 2005 database can use?

例如，我不记得有日期类型。我只记得 dateTime。

Like for instance I don't remember there being a "date" type. I only remember "dateTime".

我不想使用2005年不支持的功能，后来我将数据库上传到托管站点，仍使用2005，发现我使用的是它不支持的功能。

I don't want to be using features that 2005 can't support and I later on upload my db to the my hosting site that uses 2005 still and find out I am using things not supported by it.

推荐答案

您将无法上传数据库，只是其中的一个脚本。即使在90兼容模式下，数据库的物理结构也将是2008的数据库，并且托管站点将无法加载它。

You won't be able to upload the database, just a script of it. Even when in 90 compatibility mode, the physical structure of the database will be the 2008 one and the hosting site won't be able to load it.

请注意，兼容性级别不一定意味着SQL 2008的新功能不可用，而是意味着2005年存在的（某些）功能在2008年将以相同的方式工作。兼容模式更改的完整列表在 MSDN 上。特别是，没有什么可以阻止在兼容级别90设置的数据库中使用datetime2，日期，时间或任何新时间的。实际上，仅仅因为兼容级别可以在之后创建一个表。

Note that the compatibility level does not necessarily mean that the new features of SQL 2008 are not available, but instead it simply means that (some) features that existed in 2005 will work the same way in 2008. The complete list of compatibility mode changes is on MSDN. In particular there is nothing to prevent the usage of a datetime2, date, time or any new time in a database set at compatibility level 90. In fact such would be impossible simply because the the compatibility level can be changed after a table is created.

您将针对SQL 2k5实例进行开发，或者阅读产品手册并了解哪些版本提供了哪些功能。

You are going to either develop against a SQL 2k5 instance, or read the product manual and learn what features are available in what version.

这篇关于将SQL Server Express 2008与SQL Server 2005数据库一起使用-如何检查兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！