Skip to content
  • There are no suggestions because the search field is empty.

How to upgrade the SecurityGateway Firebird database to version 3

SecurityGateway version 7.0 through version 10.5.3 support Firebird version 3. New installations of these versions will automatically build a version 3 database, while upgrades from versions prior to SecurityGateway 7.0 will not be upgraded.

Follow the steps below to covert the Firebird database to version 3.
  1. Stop the SecurityGateway service.
  2. Open a command prompt as administrator.
  3. Use the change directory command to point to the \SecurityGateway\App folder.
    cd <drive_letter>:\<directory_path>\SecurityGateway\App\
  4. Enter the following command; sgdbtool convertfb3
  5. Restart SecurityGateway when the command is finished.
If the database has already been upgraded, the output below will be displayed and the SecurityGateway services can be restored.
  • Database file [<drive_letter>:\<directory_path>\SecurityGateway\App\SecurityGateway.fbd] is already in Firebird 3.x format

This process will save a backup copy of your Firebird 2 database file as "SecurityGateway.fb2". Then it will restore your database using the Firebird 3 runtime and save it as "SECURITYGATEWAY.FBD".

If you are using Archiving then this will also upgrade any archiving database files.