Copy data to another database
Some options are:

Create a backup and restore as a different name (if on same server):
https://www.nucleustechnologies.com/blog/restore-sql-database-with-a-different-name/

Script a database by using the Generate Scripts option using Types of data to script set to Schema and Data;

Use the Import and Export Data with the SQL Server Import and Export Wizard.