Building master SQL script using ANT (Sybase T-SQL/VSS)

From: K Burke (kdburke_at_sympatico.ca)
Date: 02/26/04 

Date: 26 Feb 2004 07:51:07 -0800

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

Relevant Pages

  • Re: Building master SQL script using ANT (Sybase T-SQL/VSS)
    ... > master SQL script that can build an entire database from a repository? ... We would like to use ANT to define ... the XML file that is used to define the class->table dependencies. ...
    (comp.lang.java.databases)
  • Re: Building master SQL script using ANT (Sybase T-SQL/VSS)
    ... > master SQL script that can build an entire database from a repository? ... We would like to use ANT to define ... the XML file that is used to define the class->table dependencies. ...
    (comp.lang.java.help)
  • Building master SQL script using ANT (Sybase T-SQL/VSS)
    ... 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 ...
    (comp.lang.java.databases)
  • DBD ERROR
    ... # Read file into scalar ... }) attribute to identify table LOB field names) at ... Issuing rollbackfor database handle being DESTROY'd without explicit ... Ant. ...
    (perl.beginners)