Post reply

Passing data between 2 tables

  • August 14, 2003 at 12:56 pm

    #106321

    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

    #470033

    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

    #470051

    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

    #470131

    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