Is there a way to restore an Sql Server 2005 DB to Sql Server 2000? I'm unable to attach it either. Any tools, ideas etc?
有没有办法将Sql Server 2005 DB还原到Sql Server 2000?我也无法附上它。任何工具,想法等?
4 个解决方案
#1
I found this utility from Microsoft called Microsoft SQL Server Database Publishing Wizard 1.1 http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en. It generates a single script that contains all the schema and the data and can be run on SQL Server 2000. It recreates the database. It worked for me anyway.
我发现Microsoft的这个实用程序称为Microsoft SQL Server数据库发布向导1.1 http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en。它生成一个包含所有模式和数据的脚本,并且可以在SQL Server 2000上运行。它会重新创建数据库。无论如何它对我有用。
#2
Because SQL 2005 has more new features/syntax than SQL 2000. You can not do the restore directly.
因为SQL 2005具有比SQL 2000更多的新功能/语法。您无法直接执行还原。
I'll do it this way. Generate the schema script from SQL 2005 first. Run the script on SQL 2000 to create the db schema. Then import the data from SQL 2005 to SQL 2000 by using SSIS or Import/Export tools.
我会这样做的。首先从SQL 2005生成架构脚本。在SQL 2000上运行脚本以创建数据库模式。然后使用SSIS或导入/导出工具将数据从SQL 2005导入SQL 2000。
#3
www.sqlaccessories.com provide some great tools that enable you to do this (using their stuctural/data diff tools). I've not tried doing it directly from the management studio.
www.sqlaccessories.com提供了一些很棒的工具,可以让你这样做(使用他们的结构/数据差异工具)。我没有尝试直接从管理工作室这样做。
Of course, if the db using sql server 2005 specific features, you'll have to do some manual tweaking.
当然,如果db使用sql server 2005特定的功能,你将不得不做一些手动调整。
From their blurb: "You can even synchronize databases that are on different versions of MS SQL Server, e.g. one on SQL Server 2005, and the other on SQL Server 2008"
从他们的模糊:“你甚至可以同步不同版本的MS SQL Server上的数据库,例如一个在SQL Server 2005上,另一个在SQL Server 2008上”
I can confirm that this works.
我可以确认这是有效的。
#4
The best way to do this is to restore the back up to a SQL Server 2005 instance, then do an export of the data to the SQL 2000 instance. There are several way you can do the export. You can either convert all the data out to flat files, use a package, or script the db to SQL and run the scripts on the SQL 2000 database.
执行此操作的最佳方法是将备份还原到SQL Server 2005实例,然后将数据导出到SQL 2000实例。您可以通过多种方式进行导出。您可以将所有数据转换为平面文件,使用包,或将db编写为SQL脚本并在SQL 2000数据库上运行脚本。
#1
I found this utility from Microsoft called Microsoft SQL Server Database Publishing Wizard 1.1 http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en. It generates a single script that contains all the schema and the data and can be run on SQL Server 2000. It recreates the database. It worked for me anyway.
我发现Microsoft的这个实用程序称为Microsoft SQL Server数据库发布向导1.1 http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en。它生成一个包含所有模式和数据的脚本,并且可以在SQL Server 2000上运行。它会重新创建数据库。无论如何它对我有用。
#2
Because SQL 2005 has more new features/syntax than SQL 2000. You can not do the restore directly.
因为SQL 2005具有比SQL 2000更多的新功能/语法。您无法直接执行还原。
I'll do it this way. Generate the schema script from SQL 2005 first. Run the script on SQL 2000 to create the db schema. Then import the data from SQL 2005 to SQL 2000 by using SSIS or Import/Export tools.
我会这样做的。首先从SQL 2005生成架构脚本。在SQL 2000上运行脚本以创建数据库模式。然后使用SSIS或导入/导出工具将数据从SQL 2005导入SQL 2000。
#3
www.sqlaccessories.com provide some great tools that enable you to do this (using their stuctural/data diff tools). I've not tried doing it directly from the management studio.
www.sqlaccessories.com提供了一些很棒的工具,可以让你这样做(使用他们的结构/数据差异工具)。我没有尝试直接从管理工作室这样做。
Of course, if the db using sql server 2005 specific features, you'll have to do some manual tweaking.
当然,如果db使用sql server 2005特定的功能,你将不得不做一些手动调整。
From their blurb: "You can even synchronize databases that are on different versions of MS SQL Server, e.g. one on SQL Server 2005, and the other on SQL Server 2008"
从他们的模糊:“你甚至可以同步不同版本的MS SQL Server上的数据库,例如一个在SQL Server 2005上,另一个在SQL Server 2008上”
I can confirm that this works.
我可以确认这是有效的。
#4
The best way to do this is to restore the back up to a SQL Server 2005 instance, then do an export of the data to the SQL 2000 instance. There are several way you can do the export. You can either convert all the data out to flat files, use a package, or script the db to SQL and run the scripts on the SQL 2000 database.
执行此操作的最佳方法是将备份还原到SQL Server 2005实例,然后将数据导出到SQL 2000实例。您可以通过多种方式进行导出。您可以将所有数据转换为平面文件,使用包,或将db编写为SQL脚本并在SQL 2000数据库上运行脚本。