如何将SQL Server 2008数据库附加到MSDE 2000 [英] how to attach a sql server 2008 database to MSDE 2000

问题描述

大家好
我有一个应用程序(使用ADO.net 4开发)..当我将此应用程序复制到另一台计算机(安装了MSDE 2000的计算机)上并且运行服务时
...我的问题是如何使msde 2000知道应用程序将使用的数据库.
感谢您的任何帮助.

hi all
I have an application(developed with ADO.net 4).. when i copy this application to another computer (which has the MSDE 2000 installed on it) and when i run the services
...my question is how to make the msde 2000 know the database which the application will uses.
thanks for any help

推荐答案

您不能将数据库文件的较新版本放在较低版本的服务器上.我上周刚尝试过同样的事情.您可以做的一件事是导出架构，然后还选择导出所有数据.将它们导出为可以在MSDE 2000上运行的脚本.请记住，您将无法使用2008可以使用的任何新功能，例如XML，地理空间坐标等.

祝你好运.

You cannot put a newer version of a database file on a lower version server. I just tried the same thing last week. One thing that you could do is to export the schema and then also select to export all of the data as well. Export them as a script that you can then run on MSDE 2000. Keep in mind that you will not be able to use any of the newer features like XML, geospacial coordinates, etc that 2008 could use.

Good Luck.

这篇关于如何将SQL Server 2008数据库附加到MSDE 2000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！