Migrating PostgreSQL to TIBCO PSC 5.1.0

To migrate from TIBCO FC 4.1.0 to TIBCO PSC 5.1.0 or TIBCO PSC 5.0.0 to TIBCO PSC 5.1.0 version, perform the following steps:

    Procedure
  1. Stop the TIBCO MDM 9.3.1 server.
  2. Access one of the following directories:
    • <AC_HOME>/db/postgreSQL/migration/Migrate4.1.0_5.1.0/ (TIBCO FC 4.1.0 to TIBCO PSC 5.1.0)
    • <AC_HOME>/db/postgreSQL/migration/Migrate5.0.0_5.1.0/ (TIBCO PSC 5.0.0 to TIBCO PSC 5.1.0)
  3. Run one of the following utilities:
    • /PostgresMig_410_to510.sh (TIBCO FC 4.1.0 to TIBCO PSC 5.1.0)
    • /PostgresMig_500_to510.sh (TIBCO PSC 5.0.0 to TIBCO PSC 5.1.0)
  4. You are prompted for the following details:
    • Database instance
    • Database user name

    • Database password

    • Database host (IP address)

    • Database port

      You would be prompted for the following detail for sample enterprise creation:

      Provide y or n for Sample enterprise creation (PSC510)

      Choose y if the sample user is not present for the PSC sample enterprise.

      The DB Migration log is generated at $AC_HOME/db/postgreSQL/migration/Migrate4.1.0_5.1.0/Migration500_510_log.log or $AC_HOME/db/postgreSQL/migration/Migrate5.0.0_5.1.0/Migration500_510_log.log path. Check the console and the logs to verify whether the utility has run without any errors. If you find errors, fix them and run the utility again.

  5. Copy RulebaseCustomFunction.class from $AC_HOME/common/standard/rulebase to the respective enterprise $MQ_COMMON_DIR/<enterprise name>/rulebase.

  6. To migrate the metadata provided in the ./PostgresMig_410_to510.sh or ./PostgresMig_500_to510.sh utility, log in to the migrated enterprise.

  7. From the System Operations menu, click Import Metadata. The Import Metadata page opens.

  8. Click the Choose File button and import the file from the $AC_HOME/samples/ProductAndServiceCatalog_Metadata.zip location.

  9. Restart the TIBCO PSC server.