The Metadata Manager Import and Export
Wizards enable you to copy metadata for relational data and DBMSs
to and from external sources. To use this feature, you must license
and install the appropriate SAS Metadata Bridge. For information about
SAS Metadata Bridges, contact your SAS representative.
You can import and export
relational metadata in any format that is accessible with a SAS Metadata
Bridge. Relational metadata includes the metadata for the following
objects: tables, columns, indexes, and keys (including primary keys
and foreign keys). This feature is useful when you have created a
data model using other data warehousing software, and you want to
import it for use with SAS; or when you have created a data model
in SAS, and you want to export it for use with other data warehousing
software.
To export metadata,
expand the
Metadata Manager node in SAS Management
Console, right-click the
Active Server node,
and select
Export Metadata. In the Metadata
Export Wizard, you specify the export format, navigate to the folders
that contain the table objects to be exported, and select the tables.
You then specify the path and filename to which the metadata is to
be exported.
To import metadata,
expand the
Metadata Manager node in SAS Management
Console, right-click the
Active Server node,
and select
Import Metadata. In the Metadata
Export Wizard, you specify the import format, specify the path and
filename that contains the metadata to be imported, and specify the
library to which the metadata is to be imported.
For more information
about using the wizards, see the Help for SAS Management Console.
Error messages generated by the wizards are written to SASMCErrorLog.txt,
which is located in one of the following paths:
-
On Windows Vista, Windows 7, and
Windows Server 2008 systems:
C:\Users\
user\AppData\Roaming\SAS\SASManagementConsole\9.3
-
On other Windows systems:
C:\Documents
and Settings\
user\Application
Data\SAS\SASManagementConsole\9.3
-
On UNIX systems:
user's-home-directory/SAS/SASManagementConsole/9.3
Note: SAS Data Integration Studio
provides enhanced Import and Export wizards to copy metadata for relational
data and DBMSs to and from external sources. These wizards provide
a change analysis capability that enables you to compare the imported
metadata to existing metadata in the repository and selectively apply
changes. For details, see the product Help for SAS Data Integration
Studio.