August 14, 2003 at 12:56 pm
Is there a quicker way to pass data between 2 identical tables than INSERT INTO... I am thinking maybe BCP OUT to a text file and then BULK INSERT IN to the table. Is there a way to BCP between tables?
August 14, 2003 at 4:30 pm
Unfortunately you can't BCP between tables.
Maybe a future version will have a BULK EXTRACT to complement BULK INSERT, or BULK INSERT from a table?
You can use DTS but I doubt if there's any performance boost.
Cheers,
- Mark
Cheers,
- Mark
August 14, 2003 at 8:49 pm
How many records. Very interesting question.
Suppose you would have read BOL: "Logged and Minimally Logged Bulk Copy Operations"
Maybe compare with BCP alone versus BCP out and BULK INSERT in.
August 15, 2003 at 11:14 am
The number of records could probably reach the 10s of millions. I am going to try BCPing to a text file then Bulk Inserting to the table. I will let you know how it turns out.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply