Migrating common metadata

Use these procedures to migrate common metadata assets. You need to export the common metadata assets that are on the source computer, and then import the assets to the target computer to complete the migration.

The metadata repository of InfoSphere® Information Server contains many different types of common metadata assets, including implemented data resources, business intelligence (BI) assets, and logical and physical data model assets. You might want to migrate these common metadata assets, so they are available to use on your new computer.

When you export common metadata, you can include any data connections to the databases, data files, or data file folders that you export. Alternately, you can export the data connections separately by type.

When you are performing a suite-wide migration, you might want to move all data connections for the entire suite. To move all data connections that exist across all products, except for InfoSphere DataStage®, you must issue three separate commands. You issue one command to export all data connections for data file folders, one command to export all data connections for databases, and one command to export all data connections for data files. The first command exports data connections for data file folders:

istool export -dom domain_name:port_number -user user_name -password password -ar path_to_archive_file -cm '/host_name/datafile_folder_path/datafile_folder_name/*.rcn'

For example:

istool export –dom ABC:9443 –u user1 –p pass1  -ar "c:\myarchive.isx" –cm
'/host1/c:\mydatafile_folders/data/*.rcn'

The second command exports data connections for databases:

istool export -dom domain_name:port_number -user user_name -password password -ar path_to_archive_file -cm '/host_name/database_name/*.dcn'

The third command exports data connections for data files:

istool export -dom domain_name:port_number -user user_name -password password -ar path_to_archive_file -cm '/host_name/datafile_path/datafile_name/*.fcn'

InfoSphere DataStage data connections are moved when you use istool commands for InfoSphere DataStage, InfoSphere Information Server Manager, or the InfoSphere DataStage Designer to move InfoSphere DataStage projects.

You export assets by using the version of the istool command-line that corresponds to your source computer. You import assets by using Version 11.7 of the istool command-line.

To migrate common metadata assets, use istool:

Table 1. Procedures for manually migrating common metadata assets
Version	Procedure
Version 11.7	Migrating common metadata assets Exporting common metadata assets by using the command line Importing common metadata assets by using the command line
Version 11.5	Migrating common metadata assets Exporting common metadata assets by using the command line Importing common metadata assets by using the command line
Version 11.3	Migrating common metadata assets Exporting common metadata assets by using the command line Importing common metadata assets by using the command line
Version 9.1	Exporting common metadata assets by using the command line Importing common metadata assets by using the command line
Version 8.7	Exporting common metadata assets by using the command line Importing common metadata assets by using the command line
Version 8.5	Exporting common metadata assets by using the command line Importing common metadata assets by using the command line
Version 8.1.2	Exporting common metadata assets by using the command line Importing common metadata assets by using the command line

For performance considerations when you use istool to transfer very large amounts of common metadata, use the following command, which exports all databases:

istool export -dom domain_name:port_number -user user_name -password password -ar path_to_archive_file -cm '/*/*.db'

The metadata related to each database is exported into a separate XMI file within the ISX archive file. When you import the metadata in the archive file, each XMI file is imported separately.