Upgrading from Version 10.1.1 (10.5)

10.5
- 10.5.1
- 10.4.1
- 10.4.0

Back Next

Migrating to a Different Database

If the domain configuration repository database type or version is no longer supported, you must migrate the repository to a different database. Migrate the repository in the previous Informatica instance before you upgrade the domain.

If you do not change the node configuration, you can run the Informatica Upgrade Advisor before you upgrade. If you run Informatica Upgrade Advisor before you migrate to a node with a different configuration, you might notice some database or node configuration failures that you can ignore.

If you want to migrate to a different database, run i10Pi available from the Informatica installer to test the installation support of the new database type or version. For more information about the i10Pi configuration, see the

Informatica Installation Guide

Suppose you have the domain configuration repository on a Microsoft SQL Server database but wish to upgrade to the newly support PostgreSQL database. Run the i10Pi available from the Informatica installer to verify the supported upgrade validation for a different database before you can migrate the repository to the PostgreSQL database.

For more information about product requirements and supported platforms, see the Product Availability Matrix on Informatica Network: https://network.informatica.com/community/informatica-network/product-availability-matrices

Shut down the domain.

Verify that you have backed up the domain configuration database tables to a file with the infasetup BackupDomain command.

Create a database schema and a user account in a supported database.

Run the i10Pi available from the Informatica installer with the database user account created to test the installation supported for a different database. Ensure that i10pi shows the database users as supported for the version in which you are about to upgrade.

Restore the domain configuration in the backup file to the specified database schema with the infasetup RestoreDomain command.

Run the upgrade installer.

When you upgrade a gateway node, select the

Allow changes to the node host name and port number

option. When you select this option, you can configure the gateway node to connect to the new domain configuration repository database. All gateway nodes must have a connection to the domain configuration repository to retrieve and update domain configuration. When you upgrade a worker node, clear the

Allow changes to the node host name and port number

option.

Upgrade the Domain with Changes to Node Configuration

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal