so as the title states. I need to restore or move a SQL 14 DB on to SQL 12 server. Its already populated with some data and has complex constraints, keys and functions etc. So its not allowing me to restore on SQL 12 as an error comes up stating its version 14 and needs to be 12 or older.

Google is an acquaintance and says I should script out the entire database and run the script on the older sql server but as many of us know with large complex databases it never runs correctly.

Upgrading or installing the newer 14 version is not an option at this time as this is in a production environment.

Any ideas?