如何迁移大型数据库(从sql 2008到sql 2005) [英] how to migrate large database (sql 2008 to sql 2005)

问题描述

我的服务器中有Sql 2008，并且我还有一个带有SQL 2005的服务器，我想进行迁移(2008到2005)，所以我生成了脚本，但是脚本的大小为900MB(无法执行)，所以我为每个对象生成脚本(431个脚本)，因为触发器和FOREIGN KEY太多，导致某些脚本执行失败，我不想安装SQL Server 2008，是否有任何方法可以进行迁移?

Sql 2008 in my Server, and I also have a another Server with SQL 2005,I want do the migration (2008 to 2005), so I generate script ,but the script has 900MB size (it cannot be excuted), so I generate script per Object (431 scripts), because there are so many triggers and FOREIGN KEYs some script excuted failed, I dont want to install SQL server 2008 , is there any ways to do the migration?

推荐答案

您知道，从sql server 2008到2005没有向后兼容性.

唯一的选择是(您已经尝试过)对整个数据库编写脚本，并生成插入脚本以将数据迁移到sql server2005.

完成此操作后，您可以使用任何比较工具进行数据比较以进行验证.

As you are aware that there is no backward compatibilty from sql server 2008 to 2005.

The only option is (which you already tried) to script the complete database and generate insert scripts to migrate data to sql server 2005.

Once this is done, you can do the data comparision using any comparison tool to validate.

这篇关于如何迁移大型数据库(从sql 2008到sql 2005)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！