How to move an HP SIM SQL 2005 SP3 database from local to remote machine

22
d.
I
f moving to a different SQL server
,
it may use a different po
rt, if this is the case
,
update
the
value after
hp.Database.portNumber
=
to the new port number
.
3.
Create a backup of the hpsim
-
ds.xml file locate
d
in the
<installation
directory>
\
HP
\
Systems Insight Manager
\
jboss
\
server
\
hpsim
\
deploy
directory
,
do not
place
the
back
up file
in
this
directory.
4.
Modify the hpsim
-
ds.xml file locate
d
in the
<installation directory>
\
HP
\
Systems
Insight Manager
\
jboss
\
server
\
hpsim
\
deploy directory
.
a.
Locate the line with the
<connection
-
url>
XML tag, it will look similar the following:
<con
nection
-
url>jdbc:jtds:sqlserver://
dbServerName
:1433/
Insight_v50_0_
###
;
loginTimeout=20;domain=
dbServerName
;instance=
source
-
instance
</connection
-
url>
b.
Change the
dbServerName
text from the old SQL Server host name to match the new SQL
Server host name
c.
I
f mov
ing to a different SQL server it may use a different port, if this is the case update the
port number
that follows the first
dbServerName
: (example
dbServerName
:1433
)
d.
I
f
the target database has a different database instance
, update the
instance name after
the
instance= parameter
.
5.
Start the
S
ystems Insight Manager
service.