SAS IT Resource Management
3.2 data models are designed to be consistent across adapters and
to perform efficiently as input to the reports supplied by the solution.
The Data Model Upgrade
program is part of the SAS IT Resource Management migration. It copies
the physical data in the IT data mart that has been migrated to SAS
9.2 to an IT data mart with a SAS IT Resource Management 3.2 data
model. At the same time, for those adapters that are supported by
the solution, it upgrades the physical data to the SAS IT Resource
Management 3.2 data model. Upgrading the data model enables you to
use your existing data with the new reports that are provided with
SAS IT Resource Management 3.2.
The program compares
the metadata for the tables in your new SAS IT Resource Management
3.2 IT data mart (that was created using the
Adapter Setup wizard) with the metadata for the tables in the old SAS IT Resource
Management 3.1.1 IT data mart or SAS IT Resource Management 2.7 PDB.
It then produces a report that shows all the changes between the two
IT data marts. Based on the information in the report, you can modify
the new IT data mart as needed. For example, if there are columns
in your old IT data mart that you want to be copied to your new IT
data mart, you can add those columns to the tables. After you are
satisfied with the changes that are indicated on the report, you can
run the program again. This time, you can set the
DOREPORT and
DOUPGRADE parameters so that
the program copies and upgrades the aggregation data from your old
IT data mart to your new IT data mart.