Introduction

Excursion: Why use dbmigrate and who can use it?

You can use the dbmigrate tool to manage the creation and evolution of one or more databases. It supports postgres and oracle explicitly, but should run with any JDBC database. With this tool, you can set up a project with scripts (e.g. SQL) to create the database and put upgrade scripts into another directory to upgrade to a newer schema version.

Normally you write a configuration to setup the database from scratch and another configuration to upgrade to higher versions. In upgrade-mode, the tool executes all upgrade scripts that are required.

Look into the example to get an impression quickly or to use the example as a starting project for your own database.

Look into the detailed documentation to learn the configuration and other features.

Reference dbmigrate in maven pom.xml

  <dependency>
    <groupId>de.viaboxx</groupId>
    <artifactId>dbmigrate</artifactId>
    <version>2.5.1</version>
  </dependency>

Documentation

• JavaDoc

AutoMigrationTool

• Example-Project
• configuration and features

Other Tools (code generation, transformation) contained in dbmigrate.jar

• InvokerTool
• DDLParserTool
• DbUnitDumpTool
• DbUnitSetupTool
• HistoryGeneratorTool
• CatalogGeneratorTool
• ScriptTransformatorTool