Copy a large table from one table to another

• shivaji

  Valued Member

  Points: 62

  More actions

  December 12, 2024 at 7:00 pm

  #4497357

  Hi,

  I have large table with 75 columns and 1.1 billion rows. Want to know the fastest way to copy from one table(non partitioned) to another(partitioned) table.

  Did anyone tried this. If yes, how long it took to load the data.

  I tried SSIS package with multiple threads, select- insert in batches and OPTION MAXDOP. None of them is helpful.

  So far select- insert in batches so far ok, but it is taking more than 2 days to copy. Any one know a better way to copy under 24 hours.

  Also I have another table with 4billion rows.

  Thanks

  Shivaji

• Ken McKelvey

  SSCoach

  Points: 18856

  More actions

  December 13, 2024 at 10:18 am

  #4497698

  For large volumes of data, I find BCP to binary files works well enough for me

  You could try:

  1. BCP out to binary files using the partition conditions.

  2. BCP in again with a sensible batch size.

   

• December 16, 2024 at 11:17 am

  This was removed by the editor as SPAM