Thursday, October 29, 2009

Using Derby aka JavaDB

  • The database package is included with j2ee package or download.
  • To start the server: go to bin folder and fire-off the startNetworkServer.bat or the like on other OS's.
  • To create a database: connect to the server with the following JDBC URL: jdbc:derby://localhost:1527/fiber1;create=true. Replace fiber1 with the name of the DB you want to be created upon connect.
  • There is a tool called DdlUtils freely available from Apache that allows migration from one DB vendor to another. That means migration of the schema and the data. Can be used via Ant or from a Java program.

No comments: