Database downgrade. How to make a backport?

W

WSGlebKavash2021-12-18 00:32:38

SQL Server

WSGlebKavash, 2021-12-18 00:32:38

There is a database created in Microsoft SQL Server 2019. There are ".mdf" and ".ldf" files, as well as a backup in .bak format.
How to downgrade a database and import into Microsoft SQL Server 2012? There are no complex structures in the database, there are only nvarchar and int data.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

Konstantin Tsvetkov, 2021-12-18
@WSGlebKavash

No way. MS SQL is not backward compatible. Only unloading (exporting) data, creating a new database and importing data there.
Yes, and up is incomplete .