Is it possible to change db server for a running UIM instance ?

[anmol kumar]

Hi All ,

 

I have a dev environment where SQL DB server is decommissioned due to some issues , now i have a new DB server of same configuration but the challenge is how do i map this new Database with running UIM.

I tried the upgrade but it didn't work as installer is first trying to connect the database and failing to do so.

Is there any way other re-installing the Central server ?

 

UIM: 9.0.2

DB : SQL

 

Thanks

Anmol

[Gene Howard]

Please see the below KB articles:

How can I move the UIM database from one location/ - CA Knowledge 

UIM database migration - CA Knowledge 

[anmol kumar]

Hi gene ,

 

thanks for prompt response but the problem i am

facing here is my db server is decommissioned already, so i cannot copy files from previous db server.

 

thanks

anmol

[Gene Howard]

Hi,

 

Does your DBA not have a good backup of your database he can restore to the new server and then

you can just change the data_engine to point to the new location?

 

if not I would suggest you do the following

1) have your DBA create a new database for you

2) run the following scripts in the order provided from the following location Nimsoft\nis\sql\<DBTYPE>:

Schema/db create scripts - run order:
<db>_nis_base_create.sql 
<db>_slm_create.sql 
<db>_dataengine_create.sql 
<db>_nis_installer_create.sql 
<db>_nis_account_create.sql 
<db>_discovery_server_create.sql 
<db>_nis_server_create.sql 
<db>_ace_create.sql 
<db>_webservice_create.sql

Then edit your data_engine connection tring to point to the new server

and restart the primary robot service then the UMP robot service.

you may need to go into WASP.cfg and set the connection = to blank and restart if the wasp will not start.