Migrating PostgreSQL from Fulfillment Catalog 3.0.2 to Fulfillment Catalog 3.1.0

To migrate PostgreSQL from Fulfillment Catalog 3.0.2 to Fulfillment Catalog 3.1.0, perform the following steps:

Procedure

  1. Start the TIBCO MDM 9.0.1 server.
  2. Set the required environment variables with respect to TIBCO MDM 9.0.1 and start TIBCO MDM 9.0.1 Configurator.
  3. Access the <AC_HOME>/db/postgreSQL/migration/Migrate3.0.2_3.1.0/ directory.
  4. Run ./PostgresMig_302_to310.sh utility.
  5. You will be prompted for the following details:
    • Database Instance name
    • Database User name
    • Database Password name
    • Database Host (IP address)
    • Database port
    • Enterprise name for data migration
    • MDM Host Name
    • MDM NODE ID
    The DB Migration log is generated at $AC_HOME/db/postgreSQL/migration/Migrate3.0.2_3.1.0/Migration302_310_log.log.
    Note: Check the console and the logs to verify whether utility has run without any errors. If you find errors, fix them and run the utility again.
  6. To migrate the metadata provided in the ./PostgresMig_302_to310.sh utility, log in to the migrated enterprise.
  7. Click System Operations > Import Metadata.
    The Import Metadata page opens.
  8. Click the Choose File button and import the file from the $AC_HOME/samples/FulfilmentCatalog_Metadata.zip location.
  9. Restart the FC server.