topic Re: Moving a SQL database? in Server Management - Systems Insight Manager

Moving a SQL database?

David Orwig — Mon, 16 Aug 2004 10:34:11 GMT

I've read about the inablity to move a cim7 database:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=372426

Is it possible or recommended (or not) to move my database from the test SQL server to my production SQL server or should I reinstall. ( Installing directly to the production server is frowned upon.

Re: Moving a SQL database?

Joel Rubenstein — Mon, 16 Aug 2004 10:51:44 GMT

It should not be a problem to move the databases. You will need to move the Insight_v1_xxxxxx and PMP_V3_0 databases and then change the ODBC System DSNs to point to the new server.

Re: Moving a SQL database?

David Vekemans — Mon, 06 Feb 2006 04:12:13 GMT

Hello,

just in case that someone still need the info :

To Move "Compaq Insight Manager 7" SQL database, follow the following procedure :
1) Stop the application
2) Backup the database on your existing SQL
3) Restore the database on the new SQL server
4) Create the SQL user used by the application on the new server (keep the same password if possible) and grant it on the DB (dbowner)
5) On you application server, update both ODBC System DSN : INSIGHT_DB_V32 and PPA_DB_V2 (update the SQL server name)
6) Edit the file %CIM7 install path%\config\database.props
7) Update the value "compaq.Database.server"
8) If the password of the user used by the application is different than on the previous SQL, add the line "compaq.database.password=new_password_in_clear_text"
9) Save the file and restart the application.

Don't worry for the password in clear text because the application will encrypt it at the 1st start.

This procedure worked for us.