Copy data from one server to another server by sql query

Sanjay Gangurde

 

I tryed all steps and connect to remote server but same server instance is connected with this process . don't know where i am wrong.

Linked servers allow submitting a T-SQL statement on a SQL Server instance, which returns data from other SQL Server instances. A linked server allows joining data from several SQL Server instances using a single T-SQL statement when data exists on multiple databases on different SQL instances. By using a linked server to retrieve data from several SQL instances, the only thing that should be done is to connect to one SQL instance.

There are two ways of configuring linked server in SSMS. One way is by using sp_addlinkedserver system stored procedure and another is by using SQL Server Management Studio (SSMS) GUI interface.

 

To see all created linked servers in SSMS, under Object Explorer, chose the Server Objects folder and expand the Linked Servers folder:

 

To create a linked server in SSMS, right click on the Linked Servers folder and from the context menu select the New Linked Server option:

I am trying to connect link server but not done so far.

can any buddy help me or through  team viewer solve my errors.

Hi Tuman,

 

SQL server has concept of linked server. You can try below link where you will get link for create linked server

 

https://stackoverflow.com/questions/603502/copy-table-to-a-different-database-on-a-different-sql-server 

Hi.

Follow this link,

 

https://www.codeproject.com/Tips/664327/Copy-Table-Schema-and-Data-From-One-Database-to-An

 

Thanks. 

You need to link both server for communication first after that you can easily run SQL query from one machine for inserting in another machine or SQL Server database table.

 

Here is a resource for you.

 

https://www.sqlshack.com/how-to-create-and-configure-a-linked-server-in-sql-server-management-studio/