Migrate the domain configuration repository to a different database
Migrate the domain configuration repository to a different database
If the domain configuration repository database type or version is not supported, migrate the repository to a different supported database. Migrate the repository in the Informatica instance before you migrate the domain.
Perform the following tasks to migrate the repository to a different database:
Shut down the domain.
Verify that you 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 i10Pi from the installer with the database user account created to test whether the installation supports the different database. Verify that i10Pi shows the database users as supported for the version to which you are about to migrate. For more information about the i10Pi configuration, see
Run the pre-installation system check tool in console mode.
Restore the domain configuration in the backup file to the specified database schema with the infasetup RestoreDomain command or from Informatica Administrator.
Run the installer to migrate.
When you migrate 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 require a connection to the domain configuration repository to retrieve and update the domain configuration. When you migrate a worker node, clear the
Allow changes to the node host name and port number
option. The installer prompts for a confirmation on whether you want to change the host. Enter the option for No if you don't want to change the host, else enter the option for Yes.
ASK INFAPreview
