Ant database rebuild script, avoiding interactive prompting

Posted by fras85 on Stack Overflow See other posts from Stack Overflow or by fras85
Published on 2010-05-04T12:05:12Z Indexed on 2010/05/04 12:08 UTC
Read the original article Hit count: 249

Filed under:
|
|

Hi Guys.

I'm writing an ant script to rebuild our database i.e. dropping everything and rebuilding from scratch. The problem our DBA adds a Y/N prompt before executing the rest of the script, and therefore we can't call this from an automated build process.

Does anyone have any suggestions to circumvent the Y/N prompt? Obviously we could create seperate scripts, one for the DBA's and one for the automated build - but this requires maintaning both. We're running on Windows so it's not as easy as using sed to strip out the prompt...but i'm thinking something along those lines.

Not sure if that's clear enough but hope you can help.

Cheers.

© Stack Overflow or respective owner

Related posts about ant

Related posts about sql