NOTE: Offloading forms from a SQL Server or Oracle database to a different database or archive file after a retention period is not handled by TraCS and is considered a responsibility of the DBA for each database due to differing policies, practices and data retention and archiving laws.

OBSOLETE

For Access databases, archived forms are moved to separate databases named <Year>Archive.mdb and<Year><Sequence Number>.asm, which are located in the Archive folder under the TraCS application data root folder. This is done only because of the database size limitations inherent to Microsoft Access. The year of the PrdDate field in the Prd_Header for the form determines which database the form will be archived in. If a form is archived and has a year that there are not already archive databases for, TraCS will automatically create databases for that year.

When TraCS automatically creates a set of new databases for a year, a copy of the Archive.new file in the Archive folder under the TraCS application data root folder is made and renamed to <Year>Archive.mdb. Also, a copy of the DataRest.mdb file in the DBData folder is made and renamed to<Year><SequenceNumber>.asm. The DataRest.mdb file is an empty replica of the Data.mdb file. If an .asm file for a particular year reaches 500MB in size, a new one is created with the next sequential number. The <Year>Archive.mdb contains a PRD_Header table that has one record for each form archived. Each record has a StorageDB column that lists the name of the .asm file the other records for the form are located in.