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

21
Figure 25
:
Performing Operation
S
ystems Insight Manager
Installation Directory
1.
Create a backup of
the
database.props, database.admin,
databaseadminupd.tpl
and
databaseupdate.tpl
files lo
cated in
<installation directory>
\
HP
\
Systems
Insight Manager
\
config
.
2.
You must modify s
ome settings for the new database changes in
S
ystems Insight Manager
in
each
of the following property files:
database.props, database.admin,
databaseadminupd.tpl
and
databaseupdate.tpl
f
iles. Update these files with the
following information
,
and
then
save the files.
a.
Change the
value after
hp.Database.hostName
=
source
-
server
-
name
to
target
-
server
-
name
.
b.
Change the
value after
hp.Database.instancename
=
source
-
server
-
name
\
\
source
-
i
nstance
to
target
-
server
-
name
\
\
target
_d
atabase_
instance
.
c.
If the database user account is a local user account c
hange the
value after
hp.Database.username
=
source
-
server
-
name
to
target
-
server
-
name
\
\
username
.