RSS Feed
News
Jan
31
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