Question: how to transfer data from one database to another in sql server?
Answer: Open SQL Server Management Studio.
Right-click on the database name, then select "Tasks" > "Export data..." from the object explorer.
The SQL Server Import/Export wizard opens; click on "Next".
Provide authentication and select the source from which you want to copy the data; click "Next".