Migrating PostgreSQL from Fulfillment Catalog 3.0.1 to Fulfillment Catalog 3.1.0
To migrate PostgreSQL from Fulfillment Catalog 3.0.1 to Fulfillment Catalog 3.1.0, perform the following steps:
Procedure
-
Start the TIBCO MDM 9.0.1 server.
-
Set the required environment variables with respect to TIBCO MDM 9.0.1 and start TIBCO MDM 9.0.1 Configurator.
-
Access the
<AC_HOME>/db/postgreSQL/migration/Migrate3.0.1_3.1.0/ directory.
-
Run
./PostgresMig_301_to310.sh utility.
-
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.1_3.1.0/Migration301_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.
-
To migrate the metadata provided in the
./PostgresMig_301_to310.sh utility, log in to the migrated enterprise.
-
Click
.
The
Import Metadata page opens.
-
Click the
Choose File button and import the file from the
$AC_HOME/samples/FulfilmentCatalog_Metadata.zip location.
-
Restart the FC server.
Copyright © TIBCO Software Inc. All rights reserved.