topic Re: How to move SIM DB to another MS SQL server in Server Management - Systems Insight Manager

How to move SIM DB to another MS SQL server

Alexx_B — Mon, 24 Nov 2008 10:00:11 GMT

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?

Re: How to move SIM DB to another MS SQL server

fred Passeron — Mon, 24 Nov 2008 10:18:20 GMT

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

Re: How to move SIM DB to another MS SQL server

Alexx_B — Mon, 24 Nov 2008 11:13:02 GMT

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

Re: How to move SIM DB to another MS SQL server

David Claypool — Mon, 24 Nov 2008 15:35:40 GMT

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

Re: How to move SIM DB to another MS SQL server

John Lernihan — Wed, 03 Dec 2008 16:24:59 GMT

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?

Re: How to move SIM DB to another MS SQL server

Tusc — Thu, 04 Dec 2008 19:54:51 GMT

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.

Re: How to move SIM DB to another MS SQL server

Adao Teixeira — Fri, 07 Oct 2011 09:13:03 GMT

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.