Archive Data

Data archiving is the process of moving data that is no longer actively used to a separate storage area for longer term retention. The Booking, Service Order, and Service Order Detail data are moved from the active database tables to the archive database tables, that is, tblBooking_Archive, tblServiceOrder_Archive, and tblServiceOrderDetail_Archive, respectively. To archive bookings, the booking date must be at least 90 days before the current day’s date.

1. On the EMS menu bar, click System Administration > Tools > Delete Old Data.
   The Delete Old Data dialog opens.

2. Select Bookings On Or Before and enter the date.
   The date entered must be at least 90 days before the current day’s date.

3. Ensure Archive Bookings is selected.

4. Click OK.
   A message appears indicating deleting this data is a permanent action and if it is OK to continue.
   No data is deleted until the archived bookings are deleted.

5. Click Yes.
   A message opens indicating deleting old data is complete.

6. Click OK.

Delete Archived Data

1. On the EMS menu bar, click System Administration > Tools > Delete Old Data.
   The Delete Old Data dialog opens.

2. Select Archived Bookings On Or Before and enter the date.

3. Click OK.
   A message appears indicating deleting this data is a permanent action and if it is OK to continue.
   When you delete the archived data, this deletes the ancillary data from the booking, and when the bookings under a reservation are deleted, the reservation gets deleted.

4. Click Yes.
   A message opens indicating deleting old data is complete.

5. Click OK.