Data dumping from one to another server

Question

Hi All, I need help to dump the data from one table to another table on the different server. Can anyone please suggest me how can we do this? For more clarity please go through attached image

Packiaraj Santhiyagu · Answer

Hi, add a linked server entry, and use select * query . use below link to link the server https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addlinkedserver-transact-sql?view=sql-server-2017 SELECT * INTO targetTable FROM [sourceserver].[sourcedatabase].[dbo].[sourceTable] Second way, Jsut import and export via management studio

Nitin Sontakke · Answer

You can use Import / Export Wizard built in SQL Server Management Studio. This is actually a on the fly created SSIS package. Pretty simple and straightforward.

Kapil Singh Kumawat · Answer

Hello, There are multiple ways to achieve this - 1. Create a linked server check the below link on how to create the linked server https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-2017 2. Generate the script of data and run on different server 3. You can also use the Import/Export wizard

Jignesh Kumar · Answer

Hi, Please follow this article with good exaplanation https://www.c-sharpcorner.com/article/copy-data-from-one-instance-to-another-instance-in-sql-serve/