One would think that a product like HP SIM would be quite comprehensive and well documented when you want to move its database to another server. However, it had been quite a frustrating affair trying to search for solutions on the Internet, from the help manual of HP SIM and from the HP forum itself. I, however, managed to find a related help document that details changes the HP SIM name and guessed from there what needs to be changed to move the HP SIM database to another server.
Okay, this happened because our DBA has migrated all SQL Server 2000 databases to the 2005 version. I thought that it would be a simple change of the 2 ODBC system DSN: Insight_v50_0 and PMP_V3_0 (I only used these 2 database, you could have more than that). So I quickly launch ODBC and made the changes to the system DSN, restarted HP SIM and trying logging on. Logon was successful and everything looks okay, until I checked with my DBA who told me that I am still hitting the old SQL server.
Searches in the HP forum found a possible solution in the thread: Move HP SIM Database to new SQL Server
One of the links pointed to files you need to modify to change system name. Took a quick look and decided to search the HP program files folder for text containing my old server name. Made the changes and finally got it move to the new SQL server.
Here is what I did… you need to change the database instance values in the following files in C:\Program Files\HP\Systems Insight Manager\config:
As with all changes, make a BACKUP copy before amending the files.