Partition TRANSACTIONS by month (12 active + 84 archive = 96 total, or rolling window with detach) - Write the ALTER TABLE ... DETACH PARTITION statement for monthly archival - Write the validation query (compare row counts before and after detach)