Question

How to send data from one database to another?

Answer 1

1.Open SQL Server Management Studio.
2.Right-click on the database name, then select "Tasks" > "Export data..." from the object explorer.
3.The SQL Server Import/Export wizard opens; click on "Next".
4.Provide authentication and select the source from which you want to copy the data; click "Next".