MS SQL 2008 Bulk Copy Records between two tables in same database
I have a Current table and an Archive table. I want to move records from the Current (has an identity field) table to the Archive table for all records that are greater than 30 days old. I know I can do this with SQL scripting which will probably work ok for all archiving after the initial archiving routine. To start I have 300+ million records in the Current table and will be moving all but about 25 million of those records to the Archive table. Is there any fast way to do this?