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
Last activity: Oct 12, 2022, 02:25 PM