To continue the Ant theme - I’m working with Oracle and I need to run a lot of scripts to build tables and populate data and after doing this a few times manually I figured there had to be a way to use Ant - it does everything!
After searching around a bit I found a few posts:
- Ant and MSSQL - close but too MS specific
- Using the built in SQL task - worked but wouldn’t run my trigger script
- Incanto - we have a winner!
I downloaded Incanto and added it to my Eclipse Ant runtime (see my previous Ant post)… There are some example .sql files in the download which are a good starting point.
Update 2/11/2007
Move to Wiki: Oracle, SQL*Plus and Ant

You May Also Enjoy Reading: