Copy data to another database I would like to know how to copy all the data from a database X1 into a database X2 on SQL Server please.
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.