Is there any tool for migrate from h2 database to PostgreSQL #3412
Unanswered
leichen-eizo
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I am using Dependency Track Version v4.9.1 with docker.
Recently I am trying to migrate from h2 database to PostgreSQL. I successfully dump data into a sql file with H2 tool script.
java -cp h2-2.1.214.jar org.h2.tools.Script -url "jdbc:h2:file:/var/lib/docker/volumes/xxx/_data/.dependency-track/db" -user sa -password ""
But fail to import the sql file into PostgreSQL data base. Which faced many errors like
After some investigation, it seems that a specific migration tool designed for Dependency Track it needed, otherwise the h2 database sql files can not imported into PostgreSQL.
Is there someone tried it?
Beta Was this translation helpful? Give feedback.
All reactions