About Archiving Data

To archive data in your production database, you can use the Archive Assistant provided in PASS.

Archiving data can be useful if your production database is getting large. Large databases can lead to disk space issues and, with SQL Server, poorer performance.

You can use the Archive Assistant to copy data for a selected date range from a production database to an archive database. You can also use the Assistant to delete data from the production database.

You can use the Archive Assistant with Oracle or SQL databases.

About Creating an Archive Database

Before you can archive data using the Archive Assistant, you must create an archive database that is identical to the source database. To do this, the following steps must be performed:

  1. Create an archive database description file (*.dbd) based on the source database.
  2. Create an empty database for the archive and an ODBC connection to this database. (An ODBC connection is also needed to the database being archived.)
  3. Ensure that the archive database is identical to the production database.