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.

--
Jeremy

Mime
View raw message