Analytics Software

Hello BI Gurus!

We are currently working on a project to move the DB server from one machine to another, which will have a different hostname. The logins/passwords/ports will all be the same, just a new db server hostname. We are on MSSQLServer and the DB server has the OLAP db and also all INFA and DAC dbs. Here is the plan that I have tested out and appears to work, but I would like a sanity check or second opinion on this procedure:

PREP WORK:
(1) on Informatica server, we will back up the domain configuration using the infasetup backupdomain command:

infasetup backupdomain -da SERVER_A:1433 -du INFADMIN -dp INFADMIN -dt MSSQLServer -ds INFA_DOMAIN -dn Domain -bf
bacup.xml


DB BACKUP EXECUTION PLAN:

(1) Stop all informatica/DAC/BI services
(2) back up DAC, DAC_DOMAIN, INFA, INFA_DOMAIN and OLAP databases from SERVER_A and restore to SERVER_B


REPOINT DAC TO NEW DB:

(1) start the DAC client, and then go to "Configure" from the login splash page, "Modify Connection" and the change "Database Host" to point to SERVER_B
(2) One DAC client is started, go to "Tools" > DAC Server Management > DAC Server Setup and change the "Database Host" to point to SERVER_B
(3) Go to "Setup" > "Physical Data Sources" and correct entry for DataWarehouse
(4) start DAC server


REPOINT INFORMATICA TO NEW DB:

(1) restore domain configuration using new server name in infasetup command:

infasetup restoredomain -da SERVER_B:1433 -du INFADMIN -dp INFADMIN -dt MSSQLServer -ds INFA_DOMAIN -dn Domain -bf
bacup.xml -f

(2) start informatica services

(3) login into PowerCenter Admin console

(4) go to repository service > Properties and set the new database properties

(5) start repository service/integration service from PC admin console

(5) start PowerCenter workflow manager and connect to the repository

(6) From workflow manager, go to Connections > Relational and modify the DW setting to point to new SERVER_B




I did not find any detailed description of how to do this from informatica or Oracle, so I came up with this by some trial and error. This procedure works in my test environment, but just as a sanity check...

Did I miss any other places where we might need to make changes?
Does anyone have another procedure other than this one?


Thanks very much in advance.