Converting Metadata for Environments and Warehouses

Overview

If you have used SAS/Warehouse Administrator Release 1.1, 1.2, or 1.3 to create Data Warehouse Environments, you must convert the metadata repositories in these old Environments to Release 2.0 format in order to use these Environments in SAS/Warehouse Administrator Release 2.0. A Metadata Conversion wizard is provided that will convert Release 1.x metadata to Release 2.0 metadata.

To invoke the Metadata Conversion wizard, run SAS/Warehouse Administrator Release 2.0, add a new Environment to the desktop. In the Path field for the new Environment, specify the path to a Release 1.x Environment's metadata repository that has not been converted to Release 2.0 format. The Metadata Conversion wizard will display.

The Metadata Conversion wizard

copies the Environment metadata repository (libname _MASTER) for a Release 1.x Warehouse Environment that you specify
copies the Warehouse metadata repositories (libname _DWMD) for each Data Warehouse within the Environment
creates Release 2.0 metadata repositories for the new Environment and for each of its Data Warehouses in the locations and with the options that you specify; by default, the new repositories are SAS Version 7 libraries
creates a default process flow and Job for each data store with its own LOAD step in the original Environment.

The Metadata Conversion wizard operates under the following rules:

The wizard can only be invoked from the SAS/Warehouse Administrator Release 2.0 interface, as previously described.
The destination directories that you specify for the converted metadata repositories must exist on the file system. The wizard will not create them for you.
The destination directories must be different from the ones storing the original metadata.
The destination directories that you specify for the converted metadata repositories must be empty.

Note: The conversion wizard does not alter the old Environment. [cautionend]

The wizard copies the old metadata, converts the copy to Release 2.0 format, and saves the Release 2.0 metadata to the locations that you specify.

Note: The conversion wizard only converts the Environment metadata repository (libname _MASTER) and the Warehouse metadata repositories (libname _DWMD) for each Data Warehouse within the Environment. [cautionend]

The converted Warehouse Environment and its Data Warehouses will point to the data stores, code libraries, and other resources as they are specified in the metadata for the original Environment. For details, see Verifying Local Resources in the Converted Environment.

Note: You cannot use the Release 2.3 SAS/Warehouse Administrator Metadata API to access metadata from previous releases. [cautionend]

If such access is attempted, when the _SET_PRIMARY_REPOSITORY_ method is called, a message will appear indicating that the metadata must first be converted. The only way to convert the metadata is to invoke the Metadata Conversion wizard, as previously described.

Top of Page