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 ?
DB : SQL
Please see the below KB articles:
How can I move the UIM database from one location/ - CA Knowledge
UIM database migration - CA Knowledge
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.
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.