Automation for sql query execution
dheerajb84
Posts: 1 New member
Hello,
Thank you.
I would like to know which redgate tool to be used for to run custom database query from Jenkins and we are using Oracle database and queries manually executing from SQL developer. We would like automation it with flyway. Please suggest us which product to be used ?
Thank you.
Tagged:
Answers
Yes Flyway CLI could certainly do that and then spool the output potentially return the response to the Jenkins runner depending on what you needed.
If you didn't need any SQL*plus functionality the free open source version might be sufficient for your needs.
https://documentation.red-gate.com/flyway/getting-started-with-flyway/installers