db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeremy Boynes <jboy...@apache.org>
Subject Re: Does derby support .sql files?
Date Wed, 16 Feb 2005 06:37:16 GMT
Ruta Kadhe wrote:
> 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.


View raw message