Converting a Release 1.x Environment and Its Warehouses

Here is one way to convert the metadata repositories in a Warehouse Environment and its Data Warehouses. Some of the steps provide instructions for dealing with relative pathnames, which you might or might not have.

1. Start SAS/Warehouse Administrator Release 2.0.

2. Verify that the current directory shown at the lower right of the SAS window is appropriate for the Warehouse Environment that you want to convert to Release 2.0 format. If it is not, change the current directory as appropriate. For details, see Inspecting the Pathname for the Old Environment.

   For example, suppose that the correct parent directory for a given Warehouse Environment is D:\Dw_projects\ .

3. On the SAS/Warehouse Administrator desktop, position the cursor in an empty area, click the right mouse button, and select Add Item  Data Warehouse Environment

   The Data Warehouse Properties Window displays.

4. In the Path field, use the right arrow to select the directory associated with the metadata repository for the Warehouse Environment that you want to convert to Release 2.0 format.

   For example, suppose that the fully qualified pathname for a particular Warehouse Environment is D:\Dw_projects\Project-1\_env .

5. Click OK.

   The Metadata Conversion wizard displays.

6. Click Next.

   The Metadata Conversion Read Me File tab displays.

7. When you are finished reading the Read Me tab, click Next.

   The Environment Information tab displays.

8. On the Environment Information tab, verify that the Path for the Environment and its Data Warehouses will resolve in the current directory shown at the lower right of the SAS window. For example, if the current directory is D:\Dw_projects\ , the relative paths .\Project-1\_env and .\Project-1\_wh1 will resolve.

9. When finished with the Environment Information tab, click Next.

   The Metadata Destination tab for the new Environment displays.

10. On the Environment Metadata Destination tab, click Browse to select the directory for the new metadata repository (libname _MASTER). This directory must already exist, or you will have to create it now. For details, see Creating a Directory Structure for the New Environment.

    For example, for an Environment, you might select a path such as D:\NewDw_projects\Project-2\_env .

11. When finished with this tab, click Next.

    The Metadata Destination tab for a Data Warehouse within the new Environment displays.

12. On the Warehouse Metadata Destination tab, click Browse to select the directory for the new metadata repository (libname _DWMD). This directory must already exist, or you will have to create it now.

    For example, for a Warehouse, you might select a path such as D:\NewDw_projects\Project-2\_wh1 .

13. When finished with this tab, click Next.

    The Metadata Destination tab for any remaining Data Warehouses within the new Environment displays. Repeat the step above for all Data Warehouses in the current Environment.

14. When finished with the Warehouse Metadata Destination tab, click Next.

    The Begin Metadata Conversion tab displays.

15. Verify that the information on the Conversion tab is correct, and then click Finish.

    The old Environment metadata repository is copied, and new metadata repositories for the Environment and its Data Warehouses are created in the locations that you specified. An icon for the new Environment is added to the SAS/Warehouse Administrator desktop.

    See the SAS log for any errors and for a detailed record of what occurs during the metadata conversion. If the SAS log shows no errors, the new Warehouse Environment is ready to use in SAS/Warehouse Administrator Release 2.0.

Unless you specified otherwise, the new metadata repositories are SAS Version 7 libraries. They contain Environment metadata or Warehouse metadata appropriate for SAS/Warehouse Administrator Release 2.0. 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. Default Process Flows and Jobs will have been created for all data stores that had Process Flows in the original Environment.

Copyright © 2012 by SAS Institute Inc., Cary, NC, USA. All rights reserved.