Hi RichardScannell-0642,
Welcome to Microsoft Q&A.
We can export the schema and the data of a database to a BACPAC file, and then import it into another SQL Server database. We can right-click the database name->Tasks->Export Data-tier Application... in SSMS using the wizard to export BACPAC file for database. Then go to another SQL Server, right-click on Databases -> Import Data-tier Application to launch the wizard to import BACPAC file.
Please refer to Data-tier Applications and this article which might help.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.