Skip to main content
Skip table of contents

Script to Delete Historical Data

drop_data.rb

To run this script:

  1. Clone the production database to a database for a support/qa/dev environment

  2. Copy drop_data.rb into /srv/www/apps/revenue_accounting on the target environment

  3. Edit the number at the top of the file to indicate how many months of data to keep

  4. Run ruby drop_data.rb and wait for it to complete

  5. Shrink the database to reclaim empty space

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.