Question: how to import data in sql server from one server to another?
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".