OpUtils Database Migration from Firebird to Postgres

OpUtils Database Migration from Firebird to Postgres

OpUtils can be upgraded till 80000 build with Firebird database , any further upgrade needs either MSSQL or Postgres as database , here are the steps for the Firebird to Postgres DB migration:

1)Stop OpUtils Service
2)Take a complete OpUtils Folder backup and save it on different location .
3)Download Postgres DB from the following URL and unzip it under OpUtils directory
4)Go to OpUtils server command prompt with Run as Administrator > change the directory to  OpUtils/bin 
c)Execute the below command :
   change_datadir_perm.bat ../pgsql/data
d)Once it is done , run the below database migration command:
    OpUtilsDBMigration.bat postgres
e)Once it is migrated , upgrade it to the latest build (80011)

Upgrade Steps:
  1. Shut down OpUtils
  2. Important: Take a manual backup of the OpUtils installation directory (<Install_Dir>/AdventNet/ME/OpUtils directory)
  3. Run the script 'UpdateManager.bat' (UpdateManager.sh for Linux) under the <OpUtils Home>/binfolder. This invokes the Update Manager tool
  4. Click Browse button and select the Upgrade Pack (.ppm file) you have downloaded.
  5. Click Install button to install the Upgrade.
  6. When completed, click "Close".
  7. Click "Exit" to close the Update Manager tool.
  8. Start OpUtils.
 


          • Related Articles

          • OpUtils Database Migration from Firebird to MSSql

            Here are the steps for the Firebird to Mssql DB migration: Stop OpUtils Service Take a complete OpUtils Folder backup and save it on different location . Go to OpUtils\conf dir Open mssql_dbm_params.conf ile and mention SQL server name and ...
          • Restore Firebird database schedule backup

            Please follow the below steps to restore the DB from back up. Start the OpUtils services Go to the directory where you have the OpUtils DB backup (Scheduled backup) EX:c:\Program Files\AdventNet\ME\OpUtils\ScheduleBackup Unzip the desired scheduled ...
          • Repair corrupted firebird database

            If Firebird database is corrupted, please follow these steps to fix it: Stop Firebird server. Don't use corrupted database - it leads to further corruption. Also, do not copy Firebird database when Firebird server is running - it leads to corrupted ...
          • (Firebird DB) 60000 --> 61000 - Problem encountered while performing database backup and restore

            The PPM may fails due to two reasons       1. Access Permission       2. DB Corruption Step 1: "Access Permission".       Access denied to write in hard drive like (c:),             Ask him to follow the steps below Go To OpUtils installed ...
          • PPM Error : Problem encountered while performing database backup and restore

            The PPM may fails due to two reasons       1. Access Permission       2. DB Corruption Step 1: "Access Permission".             Access denied to write in hard drive like (c:),             Ask him to follow the steps below Go To OpUtils installed ...