How to transfer a database created on sql server 2008, but deployed on version 2012, back to sql server 2008?

Question

SQL Server

There was a database backup created on sql server 2008. It was deployed on sql server 2012, the compatibility level of the deployed database was "SQL Server 2008 (100)". After making changes, you need to transfer the database to sql server 2008.
When you try to open a backup, an error appears: "Specified cast is not valid. (SqlManagerUI)".
RESTORE HEADERONLY does nothing but: *** INCOMPLETE ***. When called on version 2012, the data is read, i.e. the backup is not broken.
I tried to change the compatibility level to 2005, and make a backup - it did not help.
Is there any way to migrate from version 2012 to version 2008?

Answer 1

SQL Server Import and Export
Wizard This wizard helps you create simple packages that
import and export data to and from many popular
File Formats, including databases,
spreadsheets, and text files. The wizard can also create
the target database and tables into which data is inserted.
If you need to move or copy databases or
their objects from one server instance to another, you must
close this wizard and start the Copy Database Wizard
. The Copy Database Wizard is available in SQL
Server Management Studio.

Answer 2

You can try to imagine the database as a structure and a set of inserts
www.sqlscriptgenerator.com