Try the BETA

Try Visual Expert for SQL Server Beta

Register


Key Features

Visual Expert is a must-have solution for the maintenance of your SQL Server Code.

Using Visual Expert, developers easily discover and start working on any existing applications.
Understand the code - Identify the modification - Validate the effect of the change - Generate CRUD Matrix - Documentation - and more!

CRUD Matrix

CRUD Matrix show which processes/programs access your data.
For instance, which T-SQL procedures Create/Read/Update/Delete Tables.

Call Trees

Display callers and callees for procedures, tables, triggers... Navigate through your code.
Understand complex chains of calls. Explore all possible execution paths.
Drill down in the code, click on referenced methods or variables to see their definitions.

Call trees help evaluate the effects of modifications to your code.

Identify the Consequences of a Change

"If I change this, what is the effect?"

Estimate what you should modify to accomplish a change.
Don't break your application after a change!

  • If I change this variable, what is the effect on my code?
  • If I add a parameter to a function, what else is affected?
  • If a table or column is changed, which code should I update?
  • Etc.

Code Documentation

Generate documentation from the source code and create reference manuals in HTML.
Automatically generate the documents on a regular basis (scheduled job).
Document the references in your code. Easily navigate between these using hyperlinks.
Keep your documentation always up-to-date. Share knowledge with teammates.

Understand Complex Code

When maintaining complex applications, you may need to learn more about the code.
In such cases, Visual Expert is the perfect companion for your development tool.

Explore the application structure. Understand its inner working.
Navigate in your code via hyperlinks: each reference comes with a link to the referenced item. Tooltips provide useful information about objects, methods and variables.
Lots of advanced features will screen your code under various angles.

Code Comparison

Try a new approach for code comparison:

  • Run application-wide comparisons, not only for a file or an object.
  • Comparisons are based on the code structure, more powerful than text comparisons
  • Browse differences in a container hierarchy. Drill down to find relevant changes.
  • Find differences for a given object, or object category: Procedures, Tables, Triggers...
  • Save "snapshots" of your code on a regular basis, and compare them anytime.

Advanced String Search

String searches often return lots of results. They are usually tedious and unproductive.

Visual Expert Global Search addresses such shortcomings:

  • Use multiple criteria to reduce the search result
  • Restrict search to one or several object types
  • Search for exact words, or words starting/ending with, matching regular expressions…
  • Review results in a container hierarchy. The strings found are highlighted in the code
  • Filter relevant result items. Share the outcome with colleagues.

Teamwork – Collaborative Features

Team members can work together on the same applications:

  • Schedule the Code Analysis on a Server.
  • Team member explore the code on their PC with a client application.
  • Team members can explore the same code at the same time.
  • They can share their results (impact analysis for instance) with other members.
  • They can export and send results to others, as Excel or HTML files.
    Learn More

Review and Improve your Code

Clean up the code. Avoid unexpected behavior. Improve performances

  • Identify unused objects, indexes or tables, and remove some dead code.
  • Find empty methods, temporarily commented or emptied from any source code.
  • Identify missing indexes, degrading query execution time.
  • Produce code metrics. How many lines of code, objects, methods, variables…

How it works

  1. Code Parsers analyze your code, and store the Analysis in a Repository.
  2. You can then query this repository to learn more about your code
  3. Standalone configurations (Professional Edition) run all components on a single PC.
  4. Recommended for small/medium volumes of code.
  5. In Client/Server configurations (Team System), Code Analyzers and Repository reside on a server. Developers run a VE client on their PC and access the shared Repository.
  6. Code Analysis and Documentation are automatically generated with Scheduled Jobs.

Visual Expert Versions

Visual Expert offers two levels of versions to suit all types and sizes of projects.

Professional

As low as $990
  • All Visual Expert Key Features

    Running on a standalone seat.
    Suitable for small and medium
    volumes of code.

Try it for Free

Team System

  • Professional Features

    + Collaborative Features

    + Server automating code analysis and documentation.

    Recommended for several developers working on the same project, or when the volume of code is important.

Try it for Free

The Perfect Companion for your development tool

Visual Expert provides a set of innovative features, that complement your preferred development tool.

Basically, your create the application with your development tool, then Visual Expert analyzes your code to help maintain and optimize it.

Feedback from our clients