将SQL Server数据库从2005转换为2000

We have a Microsoft SQL Server 2005 database that needs to be converted back to SQL Server 2000. Does anybody have any suggestions on the approach or tools I should use to perform this conversion? We don't utilise any SQL Server 2005 specific features in the database so this should not make the conversion problematic.

我们有一个需要转换回SQL Server 2000的Microsoft SQL Server 2005数据库。是否有人对我应该用于执行此转换的方法或工具有任何建议?我们不使用数据库中的任何SQL Server 2005特定功能,因此这不应使转换成为问题。

I should mention that I have found the Microsoft SQL Server Export facility very buggy in dealing with Auto Generated Keys so suggestions for alternative tools would be appreciated.

我应该提一下,我发现Microsoft SQL Server Export工具在处理自动生成密钥时非常错误,因此建议使用替代工具。

4 个解决方案

#1

Generate a full script for your database in SQL2005, and change the "Script for Server Version" option to SQL Server 2000. You can now recreate your database on the SQL 2000 server. After this is complete, use the export data feature to export from SQL 2005 to SQL 2000.

在SQL2005中为您的数据库生成完整脚本,并将“Script for Server Version”选项更改为SQL Server 2000.您现在可以在SQL 2000服务器上重新创建数据库。完成此操作后,使用导出数据功能从SQL 2005导出到SQL 2000。

#2

Get a trial of RedGate SQL ToolBelt, then use:

试用RedGate SQL ToolBelt,然后使用:

SQL Compare to transfer the database

SQL比较传输数据库

SQL Data Compare to transfer the data

SQL数据比较以传输数据

#3

Script out the entire database

编写整个数据库的脚本

Create a new SQL2000 database

创建一个新的SQL2000数据库

Run the script on the new database

在新数据库上运行脚本

Import the data from the SQL2005 to the SQL2000 database (lots of ways to do this)

将数据从SQL2005导入SQL2000数据库(有很多方法可以执行此操作)

There probably is a tool somewhere that does all this for you, although I don't know how commonly this is done.

可能有一个工具可以为你做这一切,虽然我不知道这是多么普遍。

#4

What you want to do is called downgrading. Google gives lots of results, but here's a good walkthrough on a thread of Microsoft's forums (scroll down near the bottom of the page).

你想做的是降级。谷歌提供了很多结果,但这是微软论坛主题的一个很好的演练(向下滚动到页面底部附近)。

#1

#2