How to migrate OpUtils to a different database?

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:

WindowsLinux

Windows

Move to PostGres database

Follow the steps below to migrate the data from FireBird or MS SQL database

  1. Stop OpUtils
  2. Download Postgres DB from the following URL and unzip it under OpUtils directory
  3. Open a command prompt and change directory to OpUtils\bin
  4. Execute the command: OpUtilsDBMigration.bat postgres
  5. Start Oputils

Move to MS SQL database

Follow the steps below to migrate from FireBired or PostGres database:

  1. Stop OpUtils
  2. Edit the mssql_dbm_params.conf available in under OpUtils/conf directory
  3. Specify the SQL Server name and authentication details and save
  4. Open a command prompt and change directory to OpUtils\bin
  5. Execute the command : OpUtilsDBMigration.bat mssql
  6. Start OpUtils.