How to move SIM DB to another MS SQL server

[Alexx_B]

Hello

Some times ago I installed SIM 5.2 for test purposes and I use local MS SQL Server 2005 (trial) for this installation

SIM works normal so now we use it continuously, but.. Ooops, I forgot about trial period of MS SQL Server, so I didn't move SIM to our normal SQL Server

Today trial period is over so HP SIM doesn't work.
I want to move SIM DB's to our normal SQL server, how can I do this?

I try to attach Insight_v50_0_102737551 DB to our SQL 2005 server and select it in ODBC instead local server. Then I reboot SIM server, but SIM still doesn't work

I try to run installation process again, but in "select database" page I cannot change SQL server to another, so I cannot repair SIM

SIM service started at domain account, SQL 2005 running as Network Service account, both servers in same domain

So anybody can help me with database moving procedure please?

[fred Passeron · Accepted solution]

Hi

have a look at the following doc, it will drive you through thenecessary steps to migrate the SIM db from one to another server

ftp://ftp.compaq.com/pub/products/servers/management/hpsim/SQL2005_Move_HPSIM52.pdf




hope it helps

fred

[Alexx_B]

Oh, thanks for your quick response!
This PDF is all I need!
So now I know config files that I must change

SIM works normally at this moment

But can you tell me a secret - how do you find this document? :-)
I try to use hp seacrh same as google without any positive result

[David Claypool]

All HP SIM documentation is available from http://www.hp.com/go/hpsim --> Information Library

[John Lernihan]

Hi,

I am looking to do something similar and have found the above document. However, my SIM server has SQL Server 2005 express which came with SIM and not the full version of SQL which the procedure references.

Does anyone know how to do this for SQL Express?

[Tusc]

Here is the process I follow:

1) Stop HPSIM
2) Detach your database
3) copy it to the new server
4) attach the database on the new server


5) check the database.props file, you can find it in:

C:\Program Files\HP\Systems Insight Manager\config\

Look at the following parameters and change them depending on the server/instance name. This file might be slightly different for Oracle, certainly the port number will be different.

hp.Database.databaseName=Insight_v50_0_15629608
hp.Database.dsn=Insight_v50_0
hp.Database.hostName=HPSIM
hp.Database.instance=HPSIM\\
hp.Database.jdbcDriver=net.sourceforge.jtds.jdbc.Driver
hp.Database.jdbcUrlPrefix=jdbc\:jtds\:sqlserver
hp.Database.portNumber=1433


6) Start HPSIM again.

[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.