Migrating the Informatica Domain/Repository to Another Database

Migrating the Domain Configuration Repository to Another Database

1. Shut down all application services in the domain. 

2. Shut down the domain.

3. Back up the domain.

Run the infasetup BackupDomain command to back up the domain configuration to a binary file. By default,

infasetup installs in the server directory.

Use the following syntax:

infasetup.sh BackupDomain -da <database_hostname:database_port> -du <database_user_name> -dp <database_password> -dt <database_type> -ds <database_service_name> -bf <backup_file_name> -dn <domain_name>

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

5. Restore the domain configuration backup to the database schema.

Run the infasetup RestoreDomain command to restore the domain configuration in the backup file to the specified database schema.

Use the following syntax:

infasetup.sh RestoreDomain -da <database_hostname:database_port> -du <database_user_name> -dp <database_password> -dt <database_type> -ds <database_service_name> -bf <backup_file_name>

6. Update the database connection information for each gateway node. (If both nodes are setup as gateway, you need to do this step for both nodes.)

Gateway nodes must have a connection to the domain configuration database to retrieve and update domain configuration. Run the infasetup UpdateGatewayNode command on each gateway node to update the database connection information for each gateway node.

Use the following syntax:

infasetup.sh UpdateGatewayNode -da <database_hostname:database_port> -du <database_user_name> –dp <database_password> -dt <database_type> -ds <database_service_name> -dn <domain_name>

7. Start all nodes in the domain. (Start the Informatica Service – infaservice.sh startup)

8. Enable all application services in the domain.

Migrating the PowerCenter Repository to Another Database

1. Back up the repository contents.

select the PowerCenter Repository Service in the Administrator tool, and then select Actions > Repository Contents > Back Up.

2. Disable the service.

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

4. Update the database connection properties for the PowerCenter Repository Service, such as the database type, connect string, database user name, and database password.

5. Enable the service in exclusive mode.

6. Restore the repository backup to the database schema. select the PowerCenter Repository Service in the Administrator tool that manages the content that you want to restore, and then select Actions > Repository Contents > Restore.

7. Change the operating mode of the service to normal and restart the service.

Migrating the Data Analyzer Repository to Another Database

1. Back up the repository contents.

select the Reporting Service in the Administrator tool, and then select Actions > Repository Contents > Back Up.

2. Disable the service.

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

4. Update the database connection properties for the Reporting Service, such as the database type, connect string, database user name, and database password.

5. Restore the repository backup to the database schema.

select the Reporting Service in the Administrator tool that manages the content that you want to restore, and then select Actions > Repository Contents > Restore.

6. Enable the service.