If you were already
using MYSQL as the OpManager database and wish to move to MSSQL without
losing data, do the
following steps:
1. Stop OpManager server and
make sure the following processes are not
running.
Apache.exe
Java.exe
Mysqld-nt.exe 2. Take a backup of the existing database by
running the
script OpManager\\bin\\backup\\BackupDB.bat
3. This will create a new folder under OpManager Home directory called
"backup" and the back up file will be kept under that folder.
4. The backup file will have the naming convention of
"BackUp_MonthDate_year_time_BuildNumber.Zip" eg.
"BackUp_MAR9_2009_11_20_36_8000.Zip"
5. Select Start -->
Programs --> ManageEngine OpManager --> DB
Manager --> DB Configuration.
6. A DB Configuration window
pops up. Select MSSQL option.
7. Configure the following
information:
DB Host : The name or the IP address of the machine where MSSQL is
installed.
Port: The port number in which OpManager must connect with the
database. Default is 1433.
User
Name and Password: The user name and password with which OpManager
needs
to connect to the database.It would be better if you could provide the
"sa" user name and password. As OpManager uses metadata, to create the
tables.
These steps will automatically create the database in
the MS-SQL.However the tables will be created only after successful
start of OpManager. So Start OpManager with MS-SQL as the back end and shut it down after the
successful
startup.
8.
Run the script \\OpManager\\bin\\backup\\RestoreDB.bat, Please note
that, this
file takes the file name as argument. So you have to run this command
from
the command prompt like the example below
