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

    • Running a POC of Figaf for migration

      If you are looking for exploring a migration from SAP PI/PO to Integration Suite you will need the following. Where to run Figaf You have two options 1) Run locally Run Figaf locally on a PC with access to the PI system and the Integration Suite. ...

    • 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 21. It's enough to use OpenJDK 21, normally recommend ...

    • 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 ...

    • 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 ...

    • How to use PI/PO systems in SAP BTP

      PI/PO systems are usually located in a private environment so you need to use special SAP services to organize the connection. First of all, configure a cloud connector on the system which has access to PI/PO. See the guide. Create two services from ...