且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何将SQL Server 2008数据库附加到MSDE 2000

更新时间:2023-01-21 17:35:37

您不能将数据库文件的较新版本放在较低版本的服务器上.我上周刚尝试过同样的事情.您可以做的一件事是导出架构,然后还选择导出所有数据.将它们导出为可以在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.