Moving From one Database to another Database
ManageEngine OpManager DE supports two database management systems as
database back-end viz. MySQL and MS SQL. You have the option of using any one
of these two and can later migrate from one system to another. However we
strongly suggest you use MS SQL from the beginning itself as it improves scalability.
1. To Move From MySQL Database to MS SQL Database
Changing the database management system from MySQL to MS SQL is highly
appreciated for heavily loaded systems and this includes a few manual
steps as directed below
a) Open a command prompt and run BackupDB.bat from the location
<OpManagerHome>\bin\backup
to take the backup of the existing MySQL database. A backup file with an extension '.zip' will be created under the folder <OpManagerHome>
\backup
b) Run DBConfiguration.bat
present under
<OpManagerHome>
\bin so that
a window will appear for you to configure the details of the machine on
which MS SQL is running. Select MS SQL radio button and provide the
necessary details and hit OK
c) Run RestoreDB.bat from
<OpManagerHome>
\bin\backup with the fully qualified backup file name passed as an
argument to restore the database completely. It is extremely important that only files with extension '.zip' are to be supplied with RestoreDB.bat for restoration purposes
d) On restarting OpManager the new changes will take effect and
OpManager will be running on MS SQL back-end
2. To Move From MS SQL Database to MySQL Database
a) Open a command prompt and run BackupDB.bat from the location <OpManagerHome>
\bin\backup
to take the backup of the existing MS SQL database. A backup file with an extension '.zip' will be created under the folder <OpManagerHome>
\backup
b) Run DBConfiguration.bat
present under <OpManagerHome>
\bin so that a window will appear for you. Select MySQL radio button and hit OK
c)
Run RestoreDB.bat with the backup
file name passed as an
argument to restore the database completely. It is extremely important
that only files with extension '.zip' are to be supplied with RestoreDB.bat for restoration purposes
d) On restarting OpManager the new changes will take effect and OpManager will be running with MySQL db back-end
Note: If you want to use Probe DB as MS SQL, then Central server DB should also be a MS SQL.
