I work in a company that sells an application based in a Oracle Database.
We have new database versions every trimester, so we have scripts that create and drop objects in the database for each version.
The problem is: for each customer, we have to execute the scripts and check wether the commands were correctly executed.
So, we were thinking about the solutions to have less work on databases upgrades.
One of these solutions is: tools that can help us on controlling the version of the database and the execution of the scripts, and maybe perform a rollback if some command generate an error. But I didn't find a tool like it.
Do you guys know something to help me? Or maybe another solution.