Martin,
Unless you are changing the DB Schema often, then you could another method is
to export the SQL by saving a version via the modeler and then using an ant
task to execute the sql (I use this method since I have different structures
defined via my SQL files previously generated from the modeler):
<target name="load-struct" description="load DB struct only - no datafiles,
image">
<sql driver="${jdbc.driver}" url="${jdbc.url}" userid="${dbms.userid}"
password="${dbms.password}" print="yes">
<transaction src="${dataset.struct.dir}/struct.sql"/>
</sql>
</target>
but the cdbgen method is more appropriate if the struct is changing.
Joe
On Aug 14, 2012, at 1:57 AM, Martin Weber wrote:
> 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 looking at.
>
> Cheers,
> Martin
>
> On 14.08.2012 05:38, John Huss wrote:
>> 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 create the db generation script
>>> within an ant task or a shell/batch script.
>>>
>>> Thanks,
>>> Martin
>>>
>>
>
