Implementing CA Datacom/AD with ReportCenter › How to Migrate an Existing Database

How to Migrate an Existing Database

If you are upgrading either CA Datacom/AD or ReportCenter, or both, you can use the following process to migrate your existing CA Datacom database:

1. Stop ReportCenter, the CA Datacom/AD MUF, and the CA Datacom Server.
2. Run the CA Datacom DBUTLTY EXTRACT utility to offload the data.
3. Re-initialize the CA Datacom database that ReportCenter uses.
4. Upgrade the product components using the instructions that came with the components.
5. Reload the database.
6. Restart the CA Datacom Server, the CA Datacom/AD MUF, and ReportCenter.

If constraints prevent you from carrying out the extract-reload process, you can use the following alternative method. This method is to confirm the ReportCenter tables in the existing database.

1. Stop ReportCenter, the CA Datacom/AD MUF, and the CA Datacom Server.
2. Upgrade the product components using the instructions that came with the components.
3. Run the CA Datacom DBUTLTY CONFIRM utility on the database to confirm the following table names:

   AREA NAME REFERENCE CHART             
   //* -------------------------         
   //* N01 = ATTRIBUTE TABLE          ATT
   //* N02 = ENUMERATEDFACT TABLE     ENU
   //* N03 = KEYRANGE TABLE           KEY
   //* N04 = NUMERICFACT TABLE        NUM
   //* N05 = PERFORMANCEAGENT TABLE   PER
   //* N06 = PERIOD TABLE             B22
   //* N07 = RESOURCE TABLE           RES
   //* N08 = TIMEFRAME TABLE          TIM
   

4. Restart the CA Datacom Server, CA Datacom/AD MUF, and ReportCenter.

Note: Stopping the CA Datacom Server is not always necessary. If you cannot stop the CA Datacom Server readily, contact Technical Support to see whether it is necessary in your situation.

Note: For information about the CA Datacom DBUTLTY utilities, see the CA Datacom DBUTLTY Reference Guide.

More information:

Migration Considerations