KeepTool Enterprise goes beyond the features of KeepTool Professional by adding three specialized Oracle tools designed to simplify complex tasks and streamline your workflow:
ER Diagrammer – Quickly generate clear, graphical representations of table relationships. Perfect for understanding new projects and enhancing your documentation.
PL/SQL Debugger – Diagnose and resolve issues in your PL/SQL code with precision. Step through execution to pinpoint errors and improve reliability.
DB Compare – Ensure consistency between test and production environments. Compare database structures, highlight differences, and automatically generate DDL scripts to synchronize them.
These tools address advanced requirements that Oracle professionals often face, whether in development, troubleshooting, or database maintenance.
For example, you can visualize schema designs at a glance, trace tricky errors in PL/SQL code, or guarantee alignment across environments before deploying changes.
KeepTool Enterprise is also an excellent choice for independent consultants, who often need to gain quick insight into a client’s Oracle database and provide efficient, reliable solutions.
The DB Compare tool in KeepTool Enterprise makes it easy to identify and reconcile differences between two Oracle database schemas.
After logging in to both databases, DB Compare analyzes the schemas and categorizes the results:
Added – objects that exist only in the second schema
Removed – objects that exist only in the first schema
Changed – objects found in both schemas but with different structures
For changed objects, DB Compare displays the DDL side by side, allowing you to quickly spot the differences.
Beyond highlighting schema differences, DB Compare generates a draft synchronization script containing the necessary DROP and CREATE statements to help you align both databases.
If a database is not directly accessible through your company’s network, use Reverse DB to script the remote schema. You can then run DB Compare against the local copy to identify differences.
Quickly visualize and understand the relationships between tables in your database schema. ER Diagrammer scans table definitions and foreign key constraints directly from the data dictionary, presenting them in a clear, easy-to-navigate diagram.
Smart Layout: Independent tables appear on the left, with dependencies flowing to the right for a natural, intuitive overview.
Interactive Navigation: Use the zoom slider to focus on any section of a large, complex schema.
Subset Diagrams: Generate and save focused diagrams centered on a chosen table and its related neighbors.
Easily export your diagrams as shareable files for your project team. If your database evolves, simply re-open the file and rescan—the documentation updates instantly, keeping your schema diagrams always current.
When testing doesn’t yield the expected results, even the most experienced developer may struggle to spot the problem. Conditions that appear correct might not be evaluated as intended, and variables may not hold the values you anticipate.
A powerful debugging tool should make it easy to trace logic paths, inspect variables at any point in time, and follow the execution flow—without requiring complex setup.
KeepTool’s PL/SQL Debugger simplifies the process:
Instant Setup: Generate a ready-to-use skeleton call block that only needs parameter values.
Step-by-Step or Breakpoints: Walk through your code line by line or jump directly to predefined breakpoints.
Automatic Restart: If you miss something, restart seamlessly at the top and watch additional variables or stop at new points in the flow.
Flexible Testing: Trigger routines that don’t normally run, or test exception handlers by altering variable values—without changing your source code.
With KeepTool’s PL/SQL Debugger, you gain full visibility into your code execution, making it easier to identify issues, validate logic, and ensure reliable results.
