News Categories
RSS Feed
Posted by Liz Robertson on 31 January 2013 02:44 PM

Until now, Visual Expert could analyze DB Code, but this code had to be stored in files:

  • Either you already had SQL files containing your stored procedures, triggers, etc.
  • Or you had to use a utility - such as DataBaseExtractor (DBE) provided by Visual Expert – to connect to your database and generate SQL files before creating a VE Project and analyzing your DB Code.

Visual Expert 7 now includes a feature that automatically:

  1. connects to the database,
  2. extracts DB objects (Stored Procedure, Triggers, Tables, Views…) on the fly,
  3. analyzes them with the rest of your code (if any).

The VE7 Project Wizard includes a new section to select the DB Code you wish to analyze:

Step 1: Select your type of code

Select Language


Step 2: Select “database” as a location for VE to find your code

Find your code


Step 3: Enter your connection settings and select your database

Connection Settings


Step 4: Select the DB Objects you wish to include in the VE project

Scope of the analysis


Preview DB objects

Whenever you click on “View all”, you get a list of the DB Items found:

DB objects


Advanced Selection Mode

If needed, you can refine your DB Object selection by using filters.
Click on the button “Advanced mode” in the bottom left of this page.

You can then Filter DB Objects by type, DB Owner and Name:

Filter DB Objects


Once your selection is defined, follow the Project Wizard until the code analysis is launched.




Comments (0)
Help Desk by Novalys