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