Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Common for both types of databases, is that the needed database schemas (including migration) are included in the service distribution tar-ball, in the 'sql' directory.


See the following in order to migrate from Derby to PostgreSQL.

Derby

For embedded Derby databases the JDBC driver of "org.apache.derby.jdbc.EmbeddedDriver" is used.

...

The above example is for migrating the AuditTrail services database from version 3 to 4.

Migrate from Derby to PostgreSQL
Anchor
MigrateDerbyToPostgreSQL
MigrateDerbyToPostgreSQL

Rough notes on migrating from Derby to PostgreSQL for most databases in the reference code. Assuming everything runs on Linux.

...