Jeff Moden (1/10/2013)

---

mishka-723908 (1/10/2013)

---

Hello,

Does anyone have any ideas on the copying of the data in my situation?

Thanks

Yes. First, get rid of that partition key you're using and base it on the date, instead.

Then, split one month at a time off the original source table and load it into the final table. I believe you should drop most of your the partitions you made in the target table because there's a trick to loading a whole "split" table in just milliseconds if you have a new empty partition.

I haven't done this in a while so I'd have to do just like I recommend you do. Lookup the method in Books Online.