Moving a SQL database?

[David Orwig]

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.

[Joel Rubenstein · Accepted solution]

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.

[David Vekemans]

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.