Paul, This is indeed possible, but is likely to be dependent on the database server that you are using.
I don't know of any NAnt tasks to do this for any database server, but if the database server provides a command-line interface for exporting a database into a sql script, then you could use the <exec> task to call that interface. For example, Oracle's "exp" tool exports an sql-ish definition of the database and its data, although again I'm not sure for any of the other database vendors. Documentation for exec (NAnt version 0.85RC3): http://nant.sourceforge.net/release/latest/help/tasks/exec.html Hope that helps, -- Troy On 6/1/05, Paul Cowan <[EMAIL PROTECTED]> wrote: > > > > Hi all, > > Is it possible to generate the SQL script for a given db, that is the db > schema and the stored procedures etc. > > > > Thanks > > > > Paul > _____________________________________________________________________ > VirusChecked for the Incepta Group plc > _____________________________________________________________________ > ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ Nant-users mailing list Nant-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nant-users
