Link to home
Start Free TrialLog in
Avatar of j_heck
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
SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of j_heck
j_heck

ASKER

Both are great ways to complete the task.  Thanks.