CODEWITHSUNDEEP
javajpanetbeansderbyjavadb
achliopa
achliopa

Reputation: 29

data migration from an embedded javaDB

I am currently working on swign based javaSE application utlizing an embedded JavaDB for storing the data. My data model (and DB ) is fully java based utilizing JPA entities and JavaEE Persistence mechanism. No SQL scripts are used in the creation and management of the DB as everything is done by JPA.

As this application is going to be distributed to clients and clients usually require new features my question is if there is an effective way of getting the DB data and reinserting them after the updated application (with new tables, columns) has been delivered to the client.

Upvotes: 0

Views: 111

Answers (1)

Matt Handy
Matt Handy

Reputation: 30025

You could use dblook (command line tool that comes with JavaDB) for an SQL dump of your JavaDB content and structure (example here).

However, many structural db changes can be done with a non-empty database as well, e.g. adding columns or adding tables.

Upvotes: 1

Related Questions