databaseToDdl for platform migration

["niels.voorhoeve" <ni...@spectraseis.com>]

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.

Thanks,
Niels

------------------------
Niels Voorhoeve
Consultant - www.spectraseis.com

Re: databaseToDdl for platform migration

[Thomas Dudziak <to...@gmail.com>]

On 3/7/07, niels.voorhoeve <ni...@spectraseis.com> wrote:

> 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.

Could you create an issue in JIRA for this ?

Tom