Different versions of SQL

mcrmg
mcrmg used Ask the Experts™
on
Hi,

I have a sample db that was bk with sql 2016. I am trying to restore it to sql 2014 and received version different error. Is there a way to put a new version sql db into an older sql ? thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi mcmrg

Not to my knowlegde. Its not backwards compatible. If the sql2016 is still running or you are able to install one and restore the DB there, then you may able to get it run on 2014 with following:
https://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

regards
Thomas

Author

Commented:
thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial