Insert data from one server to another server

Question

1. how to insert one table data from one server to another server database table in sql server using command prompt 2. how to insert one table data from one server to another server database table in sql server using sql Query

Salman Beg · Answer

You can use like this,     INSERT INTO [destination database].[dbo].[destination table] SELECT * FROM [source database].[dbo].[source table]   thanks.

John · Answer

2. how to insert one table data from one server to another server database table in sql server using sql Query   Generate script and then change connection and execute the query