Sample Header Ad - 728x90

ETL table from one SQL Server to another SQL Server

1 vote
1 answer
694 views
I would like to ETL a table from one instance of SQL Server to another instance of SQL Server. I do not want to create an SSIS package. I have tried 1) to extract the data using an External Table on the destination (i.e. I use the External Table to create a local copy e.g. with
INTO #Hello FROM MyExternalTable
). 2) Linked Server with using
* INTO #HELLO FROM MyLinkedServer.MyDB.dbo.MyTable
3) I have also used
. They all run single threaded, which I can see from the execution plans. I have not used
but it seems that I first need to save the table to a file and then read it from the file and load it. So I do not think it is the correct tool for this task. What is the fastest approch to copy a table from one SQL Server instance to another SQL Server instance?
Asked by xhr489 (827 rep)
Oct 12, 2022, 12:50 PM
Last activity: Oct 12, 2022, 02:25 PM