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
- Stop the TIBCO MDM 9.3.1 server.
- 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)
- Run one of the following utilities:
(TIBCO FC 4.1.0 to TIBCO PSC 5.1.0)/PostgresMig_410_to510.sh
(TIBCO PSC 5.0.0 to TIBCO PSC 5.1.0)/PostgresMig_500_to510.sh
- 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. -
Copy
RulebaseCustomFunction.class
from$AC_HOME/common/standard/rulebase
to the respective enterprise$MQ_COMMON_DIR/<enterprise name>/rulebase
. -
To migrate the metadata provided in the
./PostgresMig_410_to510.sh
or./PostgresMig_500_to510.sh
utility, log in to the migrated enterprise. -
From the System Operations menu, click Import Metadata. The Import Metadata page opens.
-
Click the Choose File button and import the file from the
$AC_HOME/samples/ProductAndServiceCatalog_Metadata.zip
location. -
Restart the TIBCO PSC server.