Re: Database generation SQL script creation in background

2012-08-13 Thread Martin Weber
Hi John, main purpose is to make a fresh database installation during an automated nightly build. After the build I have scripts which create databases and then load data and run tests. The creation is only possible if I don't need a GUI. But I think the cdbgen ant task could be what I'm look

Re: Database generation SQL script creation in background

2012-08-13 Thread John Huss
For what purpose? What is your broader goal? There are a few different ways of creating the scheme using Cayenne. John On Monday, August 13, 2012, Martin Weber wrote: > Hi, > > Is there a solution to create the database generation SQL script without > starting the GUI modeler ? I would like to

Re: Database generation SQL script creation in background

2012-08-13 Thread Joe Baldwin
Martin, Good question (I usually use the modeler). I could find no ant task that generates a sql script, but I did find http://cayenne.apache.org/doc30/cdbgen.html which provides the capability to generate the actual DBMS-schema. (I don't think this can be used to create a SQL file.)

Database generation SQL script creation in background

2012-08-13 Thread Martin Weber
Hi, Is there a solution to create the database generation SQL script without starting the GUI modeler ? I would like to create the db generation script within an ant task or a shell/batch script. Thanks, Martin