Migrating HP SIM Database into new SQL Server

[Server-Support]

Hi All,

I'd like to know if it is possible to migrate the HP SIM SQL Server database instance from one server into another one since my current DB server hardware must be upgraded ?

is there any simple way or i can just turn off all SIM service and then migrate my SQL Server 2008 database manually to the new server and then turn it on again ?

Any idea would be greatly appreciated.

Thanks

[Michael Leu · Accepted solution]

There is a official doc 'How to Move HP SIM SQL 2005 SP3'
http://h20000.www2.hp.com/bc/docs/support/SupportManual/c02047132/c02047132.pdf

Found from http://hp.com/go/sim -> Documentation Library -> How to use

[Server-Support]

wow, many thanks for your reply Michael.

I hope that this guide applies to 2008 as well.

[Tom Keck]

I just completed migrating from SIM 6.0 under Windows 2008 SQL 2008 to SIM 6.2.1 under Windows 2008 R2 using SQL 2008 R2 on a separate SQL Failover Cluster. A newer HP document that helped with this is:
"Data Migration of an Existing Microsoft Windows CMS to a new Insight Software
6.2 System White Paper"
http://h20000.www2.hp.com/bc/docs/support/SupportManual/c02537453/c02537453.pdf
Issues that I had to overcome:
1. SIM 6.0 and 6.2 database tables are different so you can't just use SQL tools.
2. A requirement to use the hp mximport utility is that c:\temp must exist and it doesn't by default on Windows 2008 R2. This isn't in the SIM manual DB migration requirements but it is mentioned in the white paper.
3. If Remote Support is installed on the existing SIM, until it is installed on the new server, all the collections on the new server will appear to be empty.

[Server-Support]

many thanks Tom for sharing your experience here, I really appreciate it.

[Fick]

STOP the HP SIM Service:-


1) go to C:\program files\HP\Systems Insight\Manager\config
2) edit database.admin
3) change hp.Database.hostName=
4) change hp.Database.instance=
5) edit database.props
6) change hp.Database.hostName=
7) change hp.Database.instance=
8) Edit *-ds.xml with new hostname and instance (in\jboss\server\hpsim\deploy)
-and-
there may be another file with a name like "tmpXXXXXpmp-ds.xml" in the folder \jboss\server\hpsim\tmp\deploy\ that you also should update.
10) START the HP SIM Service
11) wait for port 50000 to open
12) test.

[Jason Salgado]

Hello,

I am trying to move our HP SIM 6.2 database from a remote SQL 2005 server to a remote SQL 2008 server.  I'm not a SQL person and that will be handled by our database admins.

After looking at the documentation and what others have said, I would assume have our DBSs just move the database and have me edit the

database.props, database.admin, databaseadminupd.tpl and databaseupdate.tpl files and follow the rest of the documentation for it to work???

[Adao Teixeira]

Hello everyone, this information was very important to me because it allowed me to change the database from one instance to another without any problem.

Thank you.

[Caudette]

I'm aware this post is a bit old however it comes up at the top of Google search.

I'd like to add more detail to those migrating databases for current versions of Insight Control.

This should cover the complete suite.

\Program Files\HP\Systems Insight Manager\Config

database.admin

database.props

databaseadminupd.tpl

databaseupdate.tpl

\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\deploy

hpsim-ds.xml

jtds-sqlserver-ds.xml

\Program Files\HP\Systems Insight Manager\jboss\server\hpsim\tmp\deploy

tmpXXXhpsim-ds.xml

tmpXXXjtds-sqlserver-ds.xml

\Program Files\HP\Insight Control virtual machine management\bin

hpvmmdb.conf

\Program Files\HP\Virtual Server Environment\conf

gwlmdb.properties

PMP_v5_0 database uses an ODBC connection.