how can we get the restore in sql server 2000 of sql server 2005 data
我们怎样才能在sql server 2000中获取sql server 2005数据的恢复
5 个解决方案
#1
You can't restore data from sql 2005 to 2000 only if you generate scripts with sql server 2000 compatibility. If you want create and restore backup can't do.
仅当生成具有sql server 2000兼容性的脚本时,才能将数据从sql 2005还原到2000。如果要创建和还原备份则无法做到。
#2
I recently found myself in a similar position on a client site. I came across an article on the MSDN SQL Server Forum (second response from top) with a detailed walk-through on this issue.
我最近发现自己在客户端网站上处于类似的位置。我在MSDN SQL Server论坛上发现了一篇文章(来自顶部的第二个回复),详细介绍了这个问题。
I ran into a few issues with scripting users & had to hack my way through it a little bit, but it was a great starting point for me.
我遇到了一些脚本用户的问题,并且不得不通过它破解我的方式,但对我来说这是一个很好的起点。
#3
I do not think this is possible. You can't go from 2005 to 2000, what you would have to do is install SQL 2005 Express then restore to that and you should be able to manage the backup from there.
我不认为这是可能的。你不能从2005年到2000年,你需要做的是安装SQL 2005 Express然后恢复到那个,你应该能够从那里管理备份。
If you only need the database structure you can generate scripts for the entire database.
如果只需要数据库结构,则可以为整个数据库生成脚本。
#4
Try this:
In the Properties window of the SQL 2005 Database you can set the compatibility level of that database to SQL 2000. Then perform the backup and then restore to SQL 2000. If you don't want change the compatibilty level of your original database, just do a backup first and restore the database as a dummy in SQL 2005 and set that database's compatibility level.
在SQL 2005数据库的“属性”窗口中,您可以将该数据库的兼容级别设置为SQL 2000.然后执行备份,然后还原到SQL 2000.如果您不想更改原始数据库的兼容级别,只需执行此操作首先备份并在SQL 2005中将数据库还原为虚拟数据并设置该数据库的兼容级别。
alt text http://img411.imageshack.us/img411/8541/clipboard01lro.jpg
替代文字http://img411.imageshack.us/img411/8541/clipboard01lro.jpg
#5
Use RedGate SQL Compare and RedGate SQL Data Compare to push the tables and data from SQL 2005 to SQL 2000.
使用RedGate SQL Compare和RedGate SQL Data Compare将表和数据从SQL 2005推送到SQL 2000。
You may be able to script the whole database from SQL 2000 compatibility mode, but getting the data requires something besides a backup and a restore. You could try bulk saving and bulk loading data, too...
您可以从SQL 2000兼容模式编写整个数据库的脚本,但获取数据除了备份和还原之外还需要其他内容。您也可以尝试批量保存和批量加载数据......
#1
You can't restore data from sql 2005 to 2000 only if you generate scripts with sql server 2000 compatibility. If you want create and restore backup can't do.
仅当生成具有sql server 2000兼容性的脚本时,才能将数据从sql 2005还原到2000。如果要创建和还原备份则无法做到。
#2
I recently found myself in a similar position on a client site. I came across an article on the MSDN SQL Server Forum (second response from top) with a detailed walk-through on this issue.
我最近发现自己在客户端网站上处于类似的位置。我在MSDN SQL Server论坛上发现了一篇文章(来自顶部的第二个回复),详细介绍了这个问题。
I ran into a few issues with scripting users & had to hack my way through it a little bit, but it was a great starting point for me.
我遇到了一些脚本用户的问题,并且不得不通过它破解我的方式,但对我来说这是一个很好的起点。
#3
I do not think this is possible. You can't go from 2005 to 2000, what you would have to do is install SQL 2005 Express then restore to that and you should be able to manage the backup from there.
我不认为这是可能的。你不能从2005年到2000年,你需要做的是安装SQL 2005 Express然后恢复到那个,你应该能够从那里管理备份。
If you only need the database structure you can generate scripts for the entire database.
如果只需要数据库结构,则可以为整个数据库生成脚本。
#4
Try this:
In the Properties window of the SQL 2005 Database you can set the compatibility level of that database to SQL 2000. Then perform the backup and then restore to SQL 2000. If you don't want change the compatibilty level of your original database, just do a backup first and restore the database as a dummy in SQL 2005 and set that database's compatibility level.
在SQL 2005数据库的“属性”窗口中,您可以将该数据库的兼容级别设置为SQL 2000.然后执行备份,然后还原到SQL 2000.如果您不想更改原始数据库的兼容级别,只需执行此操作首先备份并在SQL 2005中将数据库还原为虚拟数据并设置该数据库的兼容级别。
alt text http://img411.imageshack.us/img411/8541/clipboard01lro.jpg
替代文字http://img411.imageshack.us/img411/8541/clipboard01lro.jpg
#5
Use RedGate SQL Compare and RedGate SQL Data Compare to push the tables and data from SQL 2005 to SQL 2000.
使用RedGate SQL Compare和RedGate SQL Data Compare将表和数据从SQL 2005推送到SQL 2000。
You may be able to script the whole database from SQL 2000 compatibility mode, but getting the data requires something besides a backup and a restore. You could try bulk saving and bulk loading data, too...
您可以从SQL 2000兼容模式编写整个数据库的脚本,但获取数据除了备份和还原之外还需要其他内容。您也可以尝试批量保存和批量加载数据......