Move SIM Database

[Christian Beck_1]

I want to move the SIM database(s) from local MSDE to an already running remote SQL 2000 server. Can anyone describe, what steps are necessary?

[Aravindh Rajaram]

Here are few things that I can think of.

1) Backup your setup that you are currently running :)
2) Copy the entire database to your remote server.
3) The DSN's should be edited to point to the remote SQL server.
4) there is a file named database.props in \Systems Insight Manager\config folder. Here the database host name has to be changed.
5) The administrator credentials of the system running HPSIM should match the credentials on the remote SQL server. This is because HPSIM uses Windows Authentication for connecting to database.

This is what I can think of...Is there anyone who can add up to my points?!

[Koen_7]

I had to move the db from one remote sql server to another. Someone send me the following document