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