• That is not a big table, regardless of the 200 million rows. It's size isn't bigger than 5GB. You'd better do the copy in batches of let's say 1 million rows per batch, looping it of course.

    Maintenance of it should not be more than 1 hour on presumably not a powerful server with about 4-8 cores and 16-32GB RAM.

    Igor Micev,My blog: www.igormicev.com