Home Forums Data Warehousing Integration Services Need help in transfering 400 million from SQL Server to SQL Server RE: Need help in transfering 400 million from SQL Server to SQL Server

  • I'd probably not use any of those methods especially if it's a one off task. I'd most likely do a native BCP out on the source and a native BCP in on th destination.

    No matter what you do, make sure that it does it in batches and that you have transaction log backups running at pretty close intervals to keep the log file from blowing up if you're in the full recovery mode.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)