I have a sql server 2008 db, I want to restore its backup to a 2005 version. Is there any way for this work?
我有一个sql server 2008 db，我想将它的备份恢复到一个2005版本。有办法做这项工作吗?
Note: I can't make a script from my db and run it.
注意:我不能从我的db创建一个脚本并运行它。
2 个解决方案
#1
1
Unfortunately, SQL Server has never supported this - and still doesn't :-(
不幸的是，SQL Server从来没有支持过这个——现在也没有:-(
There is no way you can create a backup in a newer version and restore it in a previous version - and this goes from SQL Server 4.2 all the way through 2008 R2.
您不可能在更新的版本中创建备份并在以前的版本中恢复它——这是从SQL Server 4.2一直到2008 R2。
All you can do is either create scripts and run them on the target server, or use tools like SQL Compare and SQL Data Compare to compare the two databases and update the target database from the source (basically, what these tools do is create and execute the necessary scripts in the background, so you won't have to fiddle and create those scripts yourself)
你所能做的就是创建脚本和在目标服务器上运行它们,或者使用工具如SQL比较比较比较两个数据库和SQL数据和更新目标数据库从源(基本上,这些工具所做的就是在后台创建和执行必要的脚本,所以你不用小提琴和自己创建这些脚本)
#2
3
No. It is not possible to restore a database from a backup of a newer version.
不。从更新版本的备份中恢复数据库是不可能的。
The only solution I have come accross is generating a script, but it seems that you do not want to use this
我遇到的唯一解决方案是生成一个脚本，但似乎您不希望使用它
#1
1
Unfortunately, SQL Server has never supported this - and still doesn't :-(
不幸的是，SQL Server从来没有支持过这个——现在也没有:-(
There is no way you can create a backup in a newer version and restore it in a previous version - and this goes from SQL Server 4.2 all the way through 2008 R2.
您不可能在更新的版本中创建备份并在以前的版本中恢复它——这是从SQL Server 4.2一直到2008 R2。
All you can do is either create scripts and run them on the target server, or use tools like SQL Compare and SQL Data Compare to compare the two databases and update the target database from the source (basically, what these tools do is create and execute the necessary scripts in the background, so you won't have to fiddle and create those scripts yourself)
你所能做的就是创建脚本和在目标服务器上运行它们,或者使用工具如SQL比较比较比较两个数据库和SQL数据和更新目标数据库从源(基本上,这些工具所做的就是在后台创建和执行必要的脚本,所以你不用小提琴和自己创建这些脚本)
#2
3
No. It is not possible to restore a database from a backup of a newer version.
不。从更新版本的备份中恢复数据库是不可能的。
The only solution I have come accross is generating a script, but it seems that you do not want to use this
我遇到的唯一解决方案是生成一个脚本，但似乎您不希望使用它