Hi, Consider Derby in embeded mode. When database is to be created in embeded mode, is their any support in Derby to run .sql file which has Database Creation scripts?
You can use ij to execute SQL scripts (although you may tweak the syntax e.g. for statement delimiters if you are porting from another database).
You can also use the <sql> Ant task to execute scripts during a build.
In both cases you would not start your application but use the embedded driver from ij/ant to create it directly; once created, you can run the application normally.
The resulting database is portable between servers (and encryptable) so you may not need to run scripts in a target environment.
-- Jeremy
