[Note] [Informatica] Informatica database migration steps

I. domain database migration

1. database data migration

2. Backup related configuration files. If an error occurs during migration, you can restore them.

1) server/config/nodemeta. xml

2) server/tomcat/CONF/server. xml

3) use the infasetup. Bat backupdomain command to back up domain configuration information

3. Stop the ICA Service

4. Use the infasetup. Bat updategatewaynode command to update the node-domain database information

5. If an error occurs during the update process, follow these steps to restore

1) restore the server/config/nodemeta. xml file

2) restore the server/tomcat/CONF/server. xml file

3) use the infasetup. Bat resotredomain command to restore the domain configuration information.

Ii. powercenter database migration

1. database data migration

2. log on to the infa pc console and stop services on the node.

3. Click the database service node and edit the database attributes for updates.

4. Restart the Database Service and related services

5. If an error occurs during the update process, edit the attribute and restore it to the original setting.

[Note] [Informatica] Informatica database migration steps