I need a tool suggestion. We are a group of developers. Some of us are skilled and some, guess who, are not so skilled. None of us are DBAs, nor do we want to be. We design and maintain applications that interface with Oracle databases. We use common languages and all program SQL and PL/SQL; usually thru Quest’s Toad IDE.
The applications we maintain hook into the Oracle database “all over the place”. The database, itself, has triggers, stored procedures, alias and just “lots of stuff”. Last week, during a database update, and, because of trigger, we inadvertently changed data in some obscure table. I say obscure, but it turns out it just wasn’t all that obscure after all. Holy hell broke loose about 10 days later when a client discovered this or that didn’t work anymore. Competence? Ok, we blew it. And so this post. As developers we’d like to have a SIMPLE, desktop tool to compare data in database schemas. Ideally it would be a simple menu driven thing with just a few options (Please, no configuration hell unless it’s a one time thing we can drop on our DBA). One menu item might say SNAP; which would record the present state of the database. Another might say COMPARE; and it would compare present data to that recorded earlier. There are a lot of details to fill out here, but get me started. There just HAS to be some kind of GOOD tool out there designed for NON DBAs/application development. Env is Linux, Oracle 10g and 11. Our desktops are … yep XP Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
