how to migrate database...

[richard simpson]

Hi,

Is there a proceedure for pointing SIM 4x at a different SQL backend after it has been installed on MSDE?

Also, what is the SA password SIM uses when it installs MSDE?

TIA
RIch

[richard simpson]

Hi,
I'll answer my own questions...

I have DTS'd the insight DB to a SQL2k box, set up a DBO account on the new database,
hacked the various DB related config files in the \conf dir to point to this,
run the createDSN script in the root intall dir and configured the DNSs to point to the new DB,
and who'd have thought it- it seems to work!

Still not sure what the default SA password it- changed authentication to mixed mode but it wont accept blank.

cheers
RIch

[Frank_148]

Hi Rich.

I need to move the db from one SQL Server to another SQL server.

Could you please specify wich files in wich \conf dir you changed?

Any help is appreciated.

Sincerely,
Frank Aune
ITpro.no, Norway

[richard simpson]

Hi,

the config files should be in
c:\Program Files\HP\Systems Insight Manager\config

and are database.props and database.admin

the createDSN script is in E:\Program Files\HP\Systems Insight Manager

I think you need to ensure the insight service account has sysadmin rights to the new DB (check its rights on the old one)
cheers
RIch

[Matthew Kelner]

If you are just migrating from one remote SQL server to another. After ensuring the same user/password, all you have to do is change the System DSN's in the ODBC Administrator. Point to the new server keeping the database names the same and test connectivity. I just did this yesterday

[Frank_148]

It worked. I stopped the IM-service, detached the database and attached it to the new SQL Server, edited registry and changed the value "Server" to the new servername under the keys:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Insight_v1_0
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Insight_v1_master

Started the HP Systems Insight Manager service and everything worked. "Easy as Dell" ;-)

Thank you very much for the help guys!

Frank Aune
ITpro.no, Norway