July 2, 2019 at 9:18 pm
Hi
From what I read , it is not possible.
But I have a 2016 Backup I would like to restore to SS2014
If anyone knows if possible, or knows of a tool. Please let me know?
Thanks
July 2, 2019 at 9:33 pm
Not possible. You could try different things which wouldn't cost money such as download an evaluation version of 2016, restore the database there and then script everything out, bcp out the data and then run the scripts on your SQL Server 2014. Other similar types of things would work.
Sue
July 2, 2019 at 9:39 pm
Not possible. You could try different things which wouldn't cost money such as download an evaluation version of 2016, restore the database there and then script everything out, bcp out the data and then run the scripts on your SQL Server 2014. Other similar types of things would work. Sue
Creating a bacpac from the 2016 version and then importing as a 'Data Tier Application' on 2014 should also work and be faster than scripting everything out.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 2, 2019 at 10:09 pm
Sue_H wrote:Not possible. You could try different things which wouldn't cost money such as download an evaluation version of 2016, restore the database there and then script everything out, bcp out the data and then run the scripts on your SQL Server 2014. Other similar types of things would work. Sue
Creating a bacpac from the 2016 version and then importing as a 'Data Tier Application' on 2014 should also work and be faster than scripting everything out.
Maybe and maybe not, no one can say. There could be issues such as the database has a lot of users, the database has signed stored procedures, the database has cross database references, etc which would require "clean up" before a bacpac could be generated.
Sue
July 2, 2019 at 10:16 pm
Valid points.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply