Backup from mssql 2016 to 2012?

Question

SQL Server

There is a database created on mssql 2012 then, mssql 2016 was transferred through backup. So the question is how to transfer the database from 2016 to 2012. In the database parameters I set

spoiler

Compatibility level 2012, I make a backup of the database, I try to restore the backup in 2012, it says that the database was created in 2016 and cannot be restored in 2012.

spoiler

How to migrate database from 2016 to 2012?

Answer 1

what editions do you have? it's just that the tool (below) doesn't work with Express* editions out of principle, although if I'm not mistaken, even LocalDB agrees to serve
the actual tool - https://www.devart.com/dbforge/sql/studio/
for non-commercial use - for free, has the feature of direct database cloning (modestly called copying), including between different versions
, however, if the database from a later version has already used a feature that is not compatible with the earlier version, there will be a warning and the clone script editor,
try
ps * - well, that is, it works and with expresses.. the "database copying" feature, according to the developer's policy, requires both sides to be NOT expresses

Answer 2

You don't have to want it.
I am sure that no one in Microsoft has ever tested such a perversion. In any case, do not test regularly. Even if it works, there is no guarantee against incomprehensible problems that will appear a little later and be solved in an obvious way - bringing the versions in order.

Answer 3

It is possible without a backup: transfer the database to the offline state, copy the database files to 2012 and attach it there (Attach). Of course, the appropriate compatibility level must be set. After copying, you can raise the database back to online in 2016.

Answer 4

All answers are given in SSMS messages. MS SQL is not backwards compatible (at all).
Script the database using SSMS. So you can move back all the objects.
Transfer the data using the "Import and Export SQL Server Data" program from the distribution package.