December 12, 2024 at 7:00 pm
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
December 13, 2024 at 10:18 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy