I created a database in SQL Server 2016, but I need to save it into a lower version and be able to open it in SQL Server 2014. Is it possible?
Asked
Active
Viewed 74 times
1
-
I really appreciated for the help. I am newbie here in sql – SEA Feb 11 '19 at 19:11
-
You can find techniques for migration the data here - https://stackoverflow.com/q/6183139/1080354 – gotqn Feb 11 '19 at 19:17
-
Yes Generate Script with lower version – abdul qayyum Feb 11 '19 at 19:24
-
Thank you for the tips abdul qayyum – SEA Apr 05 '19 at 08:34
2 Answers
3
No, it is not possible. The reverse one is possible - to restore database backup from one edition to latter one.
You can also perform on place upgrade of your SQL Server 2014 to SQL Server 2016.
gotqn
- 42,737
- 46
- 157
- 243
0
Yes it is possible, but it requires some administration. You will have to enable replication, and create a snapshot publication of the database, with your SQL 2014 server as your subscriber.
Greg
- 3,861
- 3
- 23
- 58