While using the latest version of SQL Server or Using Azure SQL database/Azure SQL Managed Instance, you need to have a backout plan in case you need to go back to a lower version.
During my cloud migrations from on-prem, this is one of the most important lesson and i always ask these question before any planning.
Backup/Restore or detach /attach are not backward compatible which makes the process a bit tidious. This happens becasue the sql server upgrades your database automatically when these methods are used.The buildnumber associated with the file makes it possible to only be restored/attached on same or higher build.
Now the options you have (as mentioned above by Tibor):
- Generate script method : This will be a bit easier if the database in question is a micky mouse .
Generate Scripts method
- Using bacpac file : Export Data-tier Application. This is something i have always used via ssms or sqlpackage
Using bacpac file method
Third party tools (No recommending but you do have options open)
Apexsql : Backward migration