how to transfer data from one database to another in sql server?
['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".']