Merging data between two SQL servers

[tiggat]

I've got a dilemma, one SQL server has all information I need, but is too slow to create intermediary tables, another is fast enough to create the intermediary tables, but is missing the data needed for the final step, all tables are too big for me to put on my local machine, and the connection between rstudio/SAS to SQL servers is out of maintenance at my company, anyone ever had a problem like this they have resolved before?

 

[MrMarkyMark]

Couldn't you use a database link, to move the data where you created the intermediary tables?

It won't perform very well though.

 

[BrilloPad]

Sounds link you need linked databases and proper indexes. Or Sybase....

 

[quackhandle]

Many ways to skin a cat: Bulk insert (set recovery model to BULK LOGGED), bcp, SSIS package (might be too slow). backup, copy, restore.

qh