Toad has a setting (I forget where - and it takes a day to find) that will show you all of the queries it is running to do it's dirty work. Once you enable it, you will see exactly what query it runs on the data dictionary to get the definition of your database. Grab that query and save it to a file along with your custom statements. Then use ant's sql task or exec to kick it off.
-----Original Message----- From: John Lindwall [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 3:23 PM To: '[EMAIL PROTECTED]' Subject: Creating database scripts via ant Our company maintains it's database definition via a "master database" which is copied for production and test uses. I prefer to have SQL (DDL) scripts that create and populate my database for development and testing. What I do now is use a GUI tool called TOAD to create SQL files (from the master database) that create the database structure (table structure, functions, sequences, etc). Whenever the master database changes I need to manually run the GUI tool to regenerate the scripts. Then I customize them a little to clean up some items. I'd rather run an ant target that generates these files for me so I can automate the task. Any pointers? Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
