The must have solution for the maintenance of your SQL Server, Oracle and PowerBuilder code
Generate a CRUD matrix, showing which objects access your data, and how.
For instance, which Procedures Create/Read/Update/Delete which Tables.
Visualize objects and dependencies. Diagrams and source code are synchronized. Select objects to generate a diagram. Save, export and share your diagrams.
Find the slowest procedures, functions, triggers. Break down the execution time of a large object into sub-queries or instructions. Decompose the performance of a chain of calls.
Display callers and callees for procedures, tables, triggers... Explore all possible execution paths. Click on referenced items to see their definitions. Evaluate the effects of modifications.
Don't break your application after a change!
Discover what should be modified
• If I add a parameter to a function, what else is affected?
• If a table or column is changed, which code should I update...
Schedule and automatically create HTML reference manuals.
Document the references in your code and navigate between these using hyperlinks. Share knowledge with teammates.
A unique approach: application-wide comparisons based on the code structure.
Visualize the difference in a container hierarchy and drill down in the code.
Cleanup the code. Streamline maintenance efforts. Avoid unexpected behavior.
Identify unused objects, empty methods, duplicates. oversized scripts, etc. Produce code metrics.
Avoid Regressions when evolving your application
Master large and complex applications
Automatically generate a complete documentation of your application
Explore your code in ways you've never done before
Enable team members to collaborate during your projects.
When analyzing small volumes of code ortrying Visual Expert, you can run it locally on a developer PC.
The Developer run all Visual Expert components on his PC.
For large volumes of code, and for sharing analyses between team members, Visual Expert will run on a server.
The Server automatically analyses the code on a scheduled basis.
Developers run a Visual Expert client, query the Server and leverage up-to-date code analyses.
Using VE's features allows a much quicker turnaround, reduces expenses and frees up resources for more productive work.
(The) More you work with Visual Expert - more you understand how convenient it is. (...) I cannot remember so powerful a tool that allows a user to become familiar with a new application in literally a few hours