topic Re: move db to another server in Server Management - Systems Insight Manager

move db to another server

Koen_7 — Wed, 13 Apr 2005 07:40:17 GMT

help,
my dba (nice guy with strange idea's) want to move my HP SIM db to another server.
The db was created on a 'development' server and now he want to move it to a shared production environment. I know that in the good-old cim 7 it was possible to change the db parameters (server, user-account). But I don't find this in HP SIM 4.2 . Were can I modify the db parameters ?

Re: move db to another server

Joel Rubenstein — Wed, 13 Apr 2005 09:51:25 GMT

I have attached a soon to be released white paper "Moving HP Systems Insight Manager 4.2 To A New System" It describes the process in great detail

Re: move db to another server

Koen_7 — Thu, 14 Apr 2005 03:47:15 GMT

Nice document, thank you,
it has different migration scenarios, but mine isn't mentioned.
I have a CMS (w2k3) with a remote mssql db.
The CMS server should stay the same, but the remote db should be migrated to another system.
Should it be ok if I'm doing the following:
1. stop services
2. let dba migrate the db (with his proper tools)
3. adapt server field in start -> settings-control panel -> administrative tools -> data sources -> system DSN