I have a production database running on MSSQL 2019 on a hosted platform. I am wanting to create a sandbox copy of the db with all of the data in a local MSSQL server running 2014.
Everything I've tried (backup / restore , generating scripts, export data) has error-ed out.
Does anyone have an easy button I am overlooking?
The harsh and direct answer would be no, you cannot downgrade.
You said scripting out and exporting data doesn't work, did you try to set the database compatibility mode to 2014. Then script out the database and create it on 2014 server. Then export the data?
Right answer - generate script. You can set compatible for SQL Server 2014.
Maybe you skipped it's an option?
You can do it via SSMS:
