SQL Server 2016 SP2可以还原到SQL Server 2008 R2吗？ [英] Can SQL server 2016 SP2 restore to SQL server 2008 R2?

问题描述

Can SQL Server 2016 SP2   restore to    SQL server  2008 R2? 

我的尝试：

What I have tried:

Can SQL Server 2016 SP2   restore to    SQL server  2008 R2? 

推荐答案

否。

您可以（有时）将早期版本的备份还原到更高版本的SQL Server ，但您无法将更高版本的备份还原到早期版本。

No.
You can (sometimes) restore an earlier version backup to a later version SQL server, but you cannot restore a later version backup to an earlier version.

OriginalGriff是正确的，但是有一些工具可以转换可能能够执行此操作的数据库。大多数这些工具都是付费的，但 Power Architect 的免费版本可能能够实现：https://www.slant.co/topics/10827/viewpoints/7/~relational-database-design-and-modelling-工具~sql-power-architect [ ^ ]

另见： https://www.slant.co/topics/3250/~relational-database-migration-tools [ ^ ]

OriginalGriff is right, however there are tools to convert databases that might be able to do this. Most of these tools are paid, but the free version of Power Architect might be able to do it: https://www.slant.co/topics/10827/viewpoints/7/~relational-database-design-and-modelling-tools~sql-power-architect[^]
Also see: https://www.slant.co/topics/3250/~relational-database-migration-tools[^]

另一种选择是编写自己的转换实用程序，这是一个将SQL Server转换为PostgreSQL的示例。您唯一需要做的就是将PostgreSQL更改为SQL Server 2008 :)

将SQL Server数据库转换为PostgreSQL [ ^ ]

顺便说一句，我们很久以前就把SQL Server放到了PostgreSQL上，而且从不后悔！

Another option would be to write your own conversion utility, here is an example that converts SQL Server to PostgreSQL. Only thing you need to do is change PostgreSQL to SQL Server 2008 :)
Convert SQL Server Database to PostgreSQL[^]
Btw, we dropped SQL Server in favor of PostgreSQL a long time ago, and never regretted it !

这篇关于SQL Server 2016 SP2可以还原到SQL Server 2008 R2吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！