db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "niels.voorhoeve" <niels.voorho...@spectraseis.com>
Subject databaseToDdl for platform migration
Date Wed, 07 Mar 2007 21:21:08 GMT
Hi All,

I am porting from Postgres to HSQL and would like some
of the tables in HSQL to be CACHED tables i.e. CREATE
CACHED TABLE instead of the generic CREATE TABLE.  I
don't see a way to do this in the ant tasks.  Is it
doable in the APIs?  

Ideally the task would allow you to specify the
databasetype of the source and databasetype of the
produced sql files separately, thereby allowing you to
produce a platform-specific schema.

Meanwhile, I am dumping the hsql schema using databaseToDdl as
an sql file, doing some sed to make CREATE CACHED TABLE ddl and
rebuilding the database using the ant sql task.


Niels Voorhoeve
Consultant - www.spectraseis.com

View raw message