2
People would like to know if there is a program (or script) that compares schematics and updates in database, we work with a software that uses the Oracle database and every time an update implies changes in the bank schematics, we also need to update the bank’s schemes in production at the customer, we are currently doing this manually, and this is taking us a huge time, we wanted something simpler and faster. We currently use PL/SQL with ORACLE.
compare and apply banks What do you mean?
– igventurelli
please be clearer
– Rovann Linhalis
We have tables in the bank and we have to compare them to know what changed from one update to another and then we have to apply if you have any changes (Always have).
– Pedro Brandt
I don’t use this comparison, I only record in my system which updates I have to perform in the database, in the client’s system, record which was the last update executed (e.g. Cod 21), via webservice, the system in the client requests all updates that occurred after 21, and runs all.
– Rovann Linhalis
Sql Developer has a "Database Differences" menu item, I think that solves your question. (Assuming different structures)
– Motta
dbforge, is a specialized tool, that link, has several alternatives.
– Sidon