Additional metadata for entries made in Ext_EntityNameInstancePK.properties

InfoSphere® MDM provides a utility to populate additional metadata for the entries added in Ext_EntityNameInstancePK.properties.

The EntityNameInstancePKMigration script

The entityNameInstancePKMigration utility is a J2SE utility and you can run from the command line. The execution script runMigrationUtility.sh is located in the <MDM_INSTALL_LOCATION>/utils/entityNameInstancePKMigration/scripts directory. You can customize the script to suit your environment.

A Readme.txt file is also provided in the <MDM_INSTALL_LOCATION>/utils/entityNameInstancePKMigration/scripts directory with instructions for this utility.

Executing generated SQL statements in your environment

Running the runMigrationUtility.sh script results in an SQL file generated with the name in the format generated_updateMetaData_XXXXX.sql. This SQL file is in the same directory where you ran the script You must run the SQL commands mentioned in the generated SQL file manually against the database to populate additional metadata.

A sample properties file called Ext_EntityNameInstancePK.properties and a generated SQL file called generated_updateMetaData_1236345780819.sql are available in the <MDM_INSTALL_LOCATION>/utils/entityNameInstancePKMigration/samples directory for your reference.