j_heck
asked on
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?
Thanks,
John
Thanks,
John
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER