The default database used by OpUtils is PostGres database. Earlier versions of OpUtils were using FireBired database. This document will provide you the steps to move the OpUtils database to PostGres or MS SQL. The steps and the supported databases vary in accordance to the OS where OpUtils is installed. While both PostGres and MS SQL are supported for Windows, only PostGres is supported for Linix. Choose the Operating System to proceed:
Follow the steps below to migrate the data from FireBird or MS SQL database
Stop OpUtils
Download Postgres DB from the following URL and unzip it under OpUtils directory
Open a command prompt and change directory to OpUtils\bin
Execute the command: OpUtilsDBMigration.bat postgres
Start Oputils
Follow the steps below to migrate from FireBired or PostGres database:
Stop OpUtils
Edit the mssql_dbm_params.conf available in under OpUtils/conf directory
Specify the SQL Server name and authentication details and save
Open a command prompt and change directory to OpUtils\bin
Execute the command : OpUtilsDBMigration.bat mssql
Start OpUtils.
Follow the steps below to migrate the data from FireBird database
Stop OpUtils
Download Postgres DB from the following URL and unzip it under OpUtils directory
Open a command prompt and change directory to OpUtils\bin
Execute the command: OpUtilsDBMigration.sh postgres
Start OpUtils