locked
Data Load for 330 Million rows RRS feed

  • Question

  • The source table has 330 Million rows . I have to transfer 330 Millions rows  into destination table.

    What is the best practical way of achieving this. Please share your experience / thoughts.

    Thanks.
    Tuesday, May 19, 2009 5:08 PM

Answers

  • BCP /bulk insert would be better. Ensure that the database is in SImple recovery and also remove /disable all the indexes available on the table.
    check this link
    http://www.mssqltips.com/tip.asp?tip=1185

    Madhu
    MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/
    Tuesday, May 19, 2009 5:18 PM