"K Burke" <kdburke@sympatico.ca> wrote in message
news:c72dabb3.0402260751.18088e02@posting.google.c om...
> Has anyone attempted to create an xml build file to use ANT to make a
> master SQL script that can build an entire database from a repository?
> I am thinking VSS specifically. We would like to use ANT to define
> the dependencies between database objects and pull the source code
> from VSS. Then we could build a master script capable of rebuilding
> the entire database.
>
> We already run JBuilder 8 for our Java devlopment, and it would be
> convenient for the developers to just run another target from within
> this IDE to build the database schema (for use in deploying and
> building a database from scratch on a local Sybase ASE server).
>
> Just wondering if anyone has attempted this yet?
>
> Thanks for any replies,
>
> Kevin

Initially I am not sure what the repository has to do with anything? You
wish to create the db schema from the project not the repository, correct?

Have a look at the apache project for OJB .... I am not sure where it is at
but one of the things it was aiming to do was to generate a db schema from
the XML file that is used to define the class->table dependencies. OJB is
an O/R Mapping tool. It is open source so you may get ideas from it or may
decide that it is just the solution you need. http://db.apache.org/ojb/

Otherwise I think what you are wishing to do would greatly be influenced by
how you are accessing the the database from your application. E.g. are you
using a Data Mapper pattern as described in Pattern of Enterprise
Application Architecture (Martin Fowler)?

HTH
Shane


--
"Yes you could implement an OO model in C or assembler, even in pure binary
if you wanted to. And you could also paint your house with a toothbrush. I
just hope that you have better and more enjoyable things to do with your
time." - Rod Davison