将SQL 2008 DB R2还原到SQL2008(无r2) [英] restore SQL 2008 DB R2 to SQL2008 (no r2)
问题描述
在我的开发人员PC上安装了SQL 2008 R2
内部服务器上安装了SQL 2008 R2(某些应用程序在此处托管)
外部第3方托管公司使用SQL 2008(无r2).
on my developper pc is installed SQL 2008 R2
on the internal server is installed SQL 2008 R2 (some applications are hosted here)
on the external 3.rd party hosting company uses SQL 2008 (no r2).
因此，当我在开发人员PC上创建数据库时，我需要在外部托管服务器上进行还原，该服务器是SQL 2008(w/o r2)...但是我收到一个生成版本错误...它说SQL2008 r2具有更高的版本内部版本号，这样我就无法在w/o r2服务器上还原.
so when I created DB on my developper pc I need to restore on external hosting server which is SQL 2008 (w/o r2).... but I get an build version error... it says SQL2008 r2 has higher build number so I can't restore on the w/o r2 server.
我以为在W/O R2服务器上创建数据库并在我的本地主机上还原，然后进行更改并还原回W/O R2服务器，但是它说的是相同的错误...内部版本号已更改.
I thought creating the DB on w/o R2 server and restore on my localhost and make changes and restore back to w/o r2 server, but it says the same error... Build number is changed.
我以为可以删除开发人员PC上的r2版本并使用不带r2的SQL 2008，但问题仍然是我无法将数据库从内部服务器还原到开发人员PC ...:(
I thought I can delete r2 version on my developper pc and use SQL 2008 w/o r2, but the issue remains I can't restore the DB from internal server to my developper pc...:(
简而言之:如果要在SQL2008 R2和SQL2008之间还原/备份数据库，该如何处理(我需要数据库的数据吗?要分配给数据库的任何属性还是其他?
so in short: If I want to restore/backup the DB between SQL2008 R2 and SQL2008, how to handle this (I als need the data of database ? Any property to assign to the DB or whatever?
是否有可以将SQL2008 R2 DB用作SQL2008 DB的过程?
Is there a procedure that I can use SQL2008 R2 DB as SQL2008 DB?
我无法触摸服务器上的SQL 2008版本...
I can't touch the SQL 2008 versions on the server...
请咨询?
推荐答案
没有简单的属性可以切换以恢复到较早版本.您可以在Management Studio中尝试这样做:
There is no simple property that you can switch to be able to restore to older versions. You might try this, in Management Studio:
- 选择您的源数据库
- 选择任务>生成脚本.
- 选择脚本整个数据库和所有数据库对象的脚本"，然后按下一步"
- 选择保存到文件"，然后单击高级"按钮
- 选择服务器版本脚本"，然后选择所需的版本:2000/2005/2008
- 选择脚本数据类型"，然后选择架构/数据/两者"
- 单击确定"，然后继续！
- 将生成的文件复制到目标计算机.
- 登录到SQL Management Studio并打开复制的.sql文件...
如果您的数据库较小，则可能会起作用.对于较大的服务器，您会遇到限制.
It's likely to work if you have a small database. For a larger one you will run into limitations.
这篇关于将SQL 2008 DB R2还原到SQL2008(无r2)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
