Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »

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.

Process

Inputs

  • @Server: The database server that hosts the archive database (e.g. MSSQL-ARCHIVE). Archived/deleted records will be copied to this database before they are deleted from the main production database.

  • @DBName: The database name for the archive database (e.g. SoftripNetArchive). Archived/deleted records will be copied to this database before they are deleted from the main production database.

  • @ResCutoffDate: The last departure date for which to keep reservation data. Reservations departing before this date will be deleted.

  • @ProdCutoffDate: The last product date for which to keep Product data. Products that end before this date will be deleted.

  • @AccCutoffDate: The last date for which to keep Accounting data. Accounting data for dates before this date will be deleted.

Step by Step

Input Validation

  1. Make sure there's no outstanding contingent liability in the period we last closed, for bookings in the archived period.

    1. Process stops here if we have outstanding contingent liability.

Reservation Data

  1. Copy Credit Card information (ResCCards) for reservations that departed before the @ResCutoffDate to the archive database

  2. Copy reservation documents (ResDocs) for reservations that departed before the @ResCutoffDate to the archive database

  3. Copy reservation history (ResHhistory) for reservations that departed before the @ResCutoffDate to the archive database

  4. Copy reservation services/itinerary (ResItinerary) for reservations that departed before the @ResCutoffDate to the archive database

  5. Copy reservation memos (ResMemos) for reservations that departed before the @ResCutoffDate to the archive database

  6. Copy reservation queue records (ResQueues) for reservations that departed before the @ResCutoffDate to the archive database

  7. Copy reservation vouchers (ResVouchers) for reservations that departed before the @ResCutoffDate to the archive database

  8. Copy reservation services/itinerary (ResItinerary) for reservations that departed before the @ResCutoffDate to the archive database

Product Data

  1. [TBD]

  • No labels