Post reply

BCP Table to table help

  • December 22, 2011 at 3:27 pm

    #248713

    I am planning to load approx 3 million as fast I can into our production tables from staging tables and I am considering the following things. Please let me know if anything else to consider or if I am wrong.

    -List out all the tables which involved in referential integrity and prepare to load them in an order

    -Script out all indexes

    -Drop all indexes.

    -Change it bulk –logged recovery mode from full

    -Load data from staging tables to production tables(table to table) using bcp ?

    -Recreate indexes.

  • December 23, 2011 at 3:11 am

    #1425071

    Sonds good.

    You can also disable any constraints, business rues, checks etc before BCP and once BCP is done enable it. Also if possible you can use TABLOCK hint.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • December 30, 2011 at 8:09 am

    #1426973

    thank you

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply