H2 database migration

H2 database migration

Since of 2403 Figaf Tool H2 database version was upgraded from `1.4.200` to `2.1.214` and database path was changed from <user_home_dir>/FigafIRT/irt-db to <user_home_dir>/FigafTool/db. If you have the on-premise standalone instance on H2 database and want to continue working with the data on it (we recommend to use H2 only for temporary evaluation and testing, PostgreSQL is more preferable), it's required to migrate database files from 1.* to 2.*. Otherwise, skip that step if you want to start from scratch.

Steps to migrate H2 database:
  1. Download drivers for https://repo1.maven.org/maven2/com/h2database/h2/1.4.200/h2-1.4.200.jar and https://repo1.maven.org/maven2/com/h2database/h2/2.1.214/h2-2.1.214.jar
  2. Backup database to SQL script: java -cp h2-1.4.200.jar org.h2.tools.Script -url jdbc:h2:<user_home_dir>/FigafIRT/irt-db -user sa -script <script-name>.sql
  3. Create new database: java -cp h2-2.1.214.jar org.h2.tools.Shell -url jdbc:h2:<user_home_dir>/FigafTool/db -user sa
  4. Restore data: java -cp h2-2.1.214.jar org.h2.tools.RunScript -url jdbc:h2:<user_home_dir>/FigafTool/db -user sa -script <script-name>.sql -options FROM_1X


    • Related Articles

    • What data is sent to Figaf

      Data saved in Figaf All Data on your SAP Integration is saved in the database used by Figaf in your account. This enables you to keep the data private. Only people that you have given the Figaf roles in BTP will be able to access the tool in your ...

    • Start here to install the Figaf Tool

      If you are looking to run Figaf there is a number of ways. Where The Figaf Tool is a standalone Java application that makes it easy to run in several different locations. We support Java 8. You can use Oracle 8 if you have a corporate license; we ...

    • Setting up SAP BTP Account to deploy Figaf in Cloud Foundry

      BTP administration can be a bit complicated and contain difffrent setups. We have created a small guide for you to check before you install Figaf in BTP. It is likely that things will change there. We currently have a problem with running Figaf in ...

    • Script content for error handling

      We have created a script collection where we will be adding some of the scripts that we maintain. If you have a PI to Cloud Integration migration you will need to add this script to handle error handling. It will be added into the flows for handling ...

    • Installing Figaf DevOps Suite on your PC

      Installing Figaf DevOps Suite on your PC In this section tutorial, we show how to install Figaf DevOps Suite on your PC for a PoC. Mac would be much the same except the script should be a little different command to start the tool with.  Requirements ...