SAS IT Resource Management
3.2 and SAS IT Resource Management 3.21 use the same data model. Therefore,
porting SAS IT Resource Management 3.2 on SAS 9.2 to SAS 9.3 requires
no changes in the data model. Therefore, the information in this chapter
does not apply to your system.
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.3 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 and later.
The program compares
the metadata for the tables in your new SAS IT Resource Management
3.21 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.