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

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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?

Posted 27-Dec-18 19:45pm

Rupachandra Kangabam

Updated 27-Dec-18 22:27pm

Add a Solution

Comments

MadMyche 28-Dec-18 12:42pm

How complex is this? Are we talking a plethora of databases containing dozens of tables or?
While this won't change the simple answer "no", it will give the users here an idea of what is the best route to take you down.
-----------------
Help us help you!

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2018-12-27T20:22:00

Solution 1

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.

Posted 27-Dec-18 20:22pm

OriginalGriff

RickZeeland · Answer 2 · 2018-12-27T22:07:00

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[^]

RickZeeland · Answer 3 · 2018-12-27T22:28:00

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 !

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

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0