To ensure best performance of the database, Softrip includes a tool to delete old data. This process deletes Reservation, Product, and Accounting data based on their relevant dates. This process removes old data, ensuring that the main production database only includes data that is relevant to daily operation of the system. All archived records are copied to an “Archive” database before they are deleted from the main production database.

Inputs

The archiving process is a stored procedure named proc_ArchiveAllData. This stored procedure should be run on the main production database.

...