db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin van den Bemt <mll...@mvdb.net>
Subject Re: How do I obtain the ddl to dreate the database.
Date Fri, 20 Jan 2006 15:20:59 GMT
Just from a quick look at the code (I never used the tasks before) :
alterDatbase should be set to false to get the full ddl in the file. doDrops should be set
to true 
or false depending on your needs.
Afaik it will not do anything to your database.

Mvgr,
Martin

Philip Mark Donaghy wrote:
> I am trying to obtain a file that has the create table statements.
> 
> I use ddlToDatabase in the following way,
> 
>     <createDatabase/>
>     <writeSchemaToDatabase/>
>     <writeSchemaSqlToFile outputFile="database.ddl"/>
> 
> I expected the create table statements to be in database.ddl but it
> contains only the table alter statements.
> 
> ALTER TABLE "book"
>     ADD CONSTRAINT "book_FK_author_id_author" FOREIGN KEY
> ("author_id") REFERENCES "author" ("author_id");
> 
> ALTER TABLE "book"
>     DROP CONSTRAINT "book_FK_author_id_author";
> 
> Am I missing something?
> 
> --
> Philip Donaghy
> donaghy.blogspot.com del.icio.us/donaghy/philip
> Skype: philipmarkdonaghy
> Office: +33 5 56 60 88 02
> Mobile: +33 6 20 83 22 62
> 
> 

Mime
View raw message