But how do you copy data from TABLE to TABLE on a remote server
as mentioned in the original post?
BULK INSERT / BCP seem to load OS files only, am I correct?
The problem is that direct table to table copying takes a long time.
Exporting the data to a .txt file, then bulk inserting it on the other server, will be faster that a table to table copy.
You're right that these need to work on external files (not directly from the database), but that's why you do the export step first.
Basically, it's a way to avoid distributed transactions, which slow down large transfers of data between servers.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon