To upgrade to the new
data model, perform the following steps:
-
Make a new IT data mart.
Use the
Adapter Setup wizard to create a
new IT data mart for the same adapter, or set of adapters, that were
located in the migrated IT data mart. This new IT data mart will contain
your upgraded data after this upgrading process has successfully completed.
Note: The CSV and RRD adapters
are available only with SAS IT Resource Management 3.3. These adapters
are free-form adapters and do not use the SAS IT Resource Management
supplied data model tables.
-
Generate a comparison
report of the two IT data marts.
The supplied SAS macro,
%RMUPGRDM, can be run from an interactive session of SAS, or by creating
a SAS program and running it in batch mode. This macro is used both
to create the comparison report and to perform the IT data mart upgrade.
To generate the comparison report without performing an update, set
the
DOPREPORT parameter to
YES and
the
DOUPGRADE parameter to
NO.
Based on the comparison
report, you might determine that you would lose some data that you
want to keep. In that case, you can use SAS IT Resource Management
to edit the new IT data mart. You can add columns, edit existing columns,
and delete unwanted columns. You can also create new tables, modify
existing tables, and delete unwanted tables.
Note: If you change or delete any
columns or tables, some of the supplied reports might not work.
After making changes,
rerun the upgrade program with the
DOREPORT parameter
set to
YES. You can use the report
to see how your changes could affect the upgrade. Once you determine
that all the data will be carried forward to your satisfaction, continue
to the next step.
-
Upgrade the IT data
mart.
In order to upgrade
the IT data mart, you need to use the same macro that you used to
create the comparison report: %RMUPGRDM. You should change two parameters
in order to upgrade the data. Change the value of the
DOREPORT parameter
to
NO and the value of the
DOUPGRADE parameter
to
YES.
The Upgrade program
copies the physical data tables from the migrated IT data mart to
the new IT data mart and makes the necessary changes to the columns.
This program does not
delete your migrated data. The data is still available in the migrated
IT data mart's location. Once you are confident that the upgrade was
successful, you can delete the data manually or by using the
Erase
Data Mart action in SAS IT Resource Management.