Hi, I am working through a Liquibase university course and have got to diff & diff-changelog commands for which I need two databases. I thought it would be good to carry on with the h2 database supplied in the Liquibase examples folder, however, I can’t work out how to create a second database in the same browser console or even a second browser window.
So as well as “jdbc:h2:tcp://localhost:9090/mem:dev” I’d also have “jdbc:h2:tcp://localhost:9090/mem:test”
It would be great if the start-h2.bat files automatically initiated 2 databases, but for now, is it possible?
Many thanks,
David
OK - I know about snapshots now, so I can use that to practice diff & diff-changelog commands.
I’ve sent the course owner a message suggesting the Diff and Snapshot sections are swapped around, or the snapshot is covered earlier in the course.
I still wonder if it is possible to have two H2 databases; preferably provided out of the box in the Liquibase example folder from running start-H2.bat… 
Try the command again, but this time, when you launch the second instance, do it like this:
liquibase init startH2 --db-port 9095 --web-port 8085
This should bring up a 2nd console in your browser, connected to another instance of H2, running on port 9095.
Many thanks, this indeed worked directly from two separate cmd boxes.
I’ll forget about using the given “start-h2.bat” file.