There are 50 ADT tables. They may reside in one or two databases. This document describes how to locate your ADT database or databases and methods for creating backups.
There are three database configurations
How to determine what you have
To determine which configuration you have review your ODBC DataSources used to connect through Mapper and Script Manager.
Use the ODBC Administrator DataSources configuration wizard to find the name of the Microsoft Access file or the database name for Microsoft SQL Server, Sybase SQL Server, or Ingres. For Oracle, use the ODBC Administrator DataSources configuration wizard to find the Oracle "server" name and then locate that name in the TNSnames.ora file.
Backing up the databases
When you want a complete copy of a database including logins, roles, table definition information, and data for the purpose of recreating the database from scratch, then use your database server's utility. If, though, you wish to backup ADT data only, ADT provides utilities to do this.
Database Server method:
Once you know where your ADT tables are, you can use your database server's back-up utility to save the entire database or schema. This kind of backup enables you to do a database server restore to completely recreate the database and all its tables, data, users, etc. If the database is the MDB, the backup will include restore information for ADT as well as for other CA products that own tables in the MDB.
Whether the ADT tables are in one or two databases, the ADT backup method uses two utilities, one for the metadata store and one for the basic IDB. These utilities will save the data that's in the ADT tables, but not database server-specific information, such as database logins.