且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在 SQL Server 2008 中恢复 SQL Server 2014 备份

更新时间:2022-03-04 06:26:54

据我所知不是很清楚,但您可以尝试以下几件事.

Not really as far as I know but here are couple things you can try.

第三方工具:在 2008 实例上创建空数据库并使用第三方工具,例如 ApexSQL DiffData Diff 以同步架构和表.

Third party tools: Create empty database on 2008 instance and use third party tools such as ApexSQL Diff and Data Diff to synchronize schema and tables.

只需在试用模式下使用这些(或市场上的任何其他产品,例如 Red Gate、Idera、Dev Art,有很多类似的)即可完成工作.

Just use these (or any other on the market such as Red Gate, Idera, Dev Art, there are many similar) in trial mode to get the job done.

生成脚本:转到任务 -> 生成脚本,选择选项来编写数据脚本并在 2008 实例上执行.工作正常,但请注意脚本顺序是您必须小心的事情.默认情况下,脚本不会被排序以考虑依赖项.

Generate scripts: Go to Tasks -> Generate Scripts, select option to script the data too and execute it on 2008 instance. Works just fine but note that script order is something you must be careful about. By default scripts are not ordered to take dependencies into account.