Step 6. Configure a Historical Database

Historical Database Overview

• A Historical Database requires at least a Standard Edition of Microsoft SQL Server.
• When you use a historical database your project data is stored as follows.

The SQL TADB database:

• Holds the following data during production: Standard attributes, Extended attributes, and TADB data.
• Deletes most items when production is complete.
• The Historical database:
• Receives all the data that passes through the TADB database. There may be an 8 second or more delay before the Historical database receives the data. The exact amount of time depends on your system configuration.

• Retains all the data that passes through the TADB database. When data is entered into this database it is read-only; it can be removed from the Historical TADB based on time constraints or item data based rules.

• Keeps an account of all the changes made within any single record.

Therefore, as long as you keep the Historical Database running, you can reference data for any item, which has not been removed, from the time it started.

Configuration/Maintenance Steps

Steps to create and use the Historical Database are as follows.