Utility to migrate GeoStore DB from H2 to PostgreSQL

[tdipisa]

Description

A utility is required to allow to migrate existing GeoStore H2 DBs to PostgreSQL. The utility to be developed will export H2 DB as a SQL script to run it on the target PostgreSQL DB.

Acceptance criteria

• The utility will be developed in Java as part of the GeoStore utilities to be maintained across different releases of the backend application
• It will be possible to build that utility as a JAR individually and it will be also possible to include that in the GeoStore build with a dedicated mvn profile
• It will be possible to use that new utility from command line by specifying all mandatory parameters, such as:
  • Connection parameters of the source DB (H2) to be migrated
  • System path where the final SQL script will be available
• A proper documentation to explain on how to use that utility and the output SQL script will be available as part of the MS online documentation: the related doc section will be updated to describe the utility and its parameters with an example

Other useful information

This issue comes from https://github.com/geosolutions-it/support/issues/1323, where a sample of H2 DB to migrate is available.