This article has a goal of presenting some of the core features of ApexSQL Analyze.
ApexSQL Analyze allows customization of the SQL databases dependency diagram to improve the visual look and readability of SQL dependencies from the imported database. In this article, it will be explained how to work with ApexSQL Analyze. This tool does not require expert skills and it’s very easy to use.
Importing database can be done by clicking on the New button from the Home tab. The Project options window will appear:
Project options window contains three tabs:
To import a database, from the Source drop-down menu select Database:
From the Server drop-down menu, select a wanted instance to connect to:
There are five types of authentications:
To add a database, from the Database drop-down menu select wanted database:
When the process of loading a database is done, the database with all objects (tables, procedures, views, SQL dependencies, etc.) will be shown on the main diagram as shown below:
The Home tab contains Project, Export, Navigation, Action, and Tools sections:
Project section:
Export:
Navigation:
Action:
Tools:
The View tab contains Display and Show panels section:
Display:
Show panels:
Help, Send logs, Support center, Product page, About, Contact us, Activate, and Get updates can be found in the Resources tab.
Object browser is located on the left side of the application and it contains all database objects:
The search option is used to easily find an object. Type the name of the wanted object and press Enter. The wanted object will be shown, if there are more objects with the same names, objects will be highlighted. Double-clicking on a wanted object will locate an object in the main diagram window:
If for some reason we don’t want to see an object type, e.g. views, in the Object browser, find the View option and uncheck it. Views will be removed from the main diagram window:
Here is how it looks with the View option checked:
And when unchecked:
Graph overview is a smaller version of the main diagram window and can be used to fast relocate positions of the screen, simply click on the wanted positions and locations will be changed:
The Dependencies button from the Show panels section is used to show or hide SQL dependencies in the main diagram window:
The dependencies pane is located on the right side of the screen. By clicking on the wanted object from the main diagram, all SQL dependencies will be shown on the Dependencies pane:
The Column dependencies button from the Show panels section is used to show Column dependencies in the Dependencies pane:
By clicking on the wanted table, column dependencies will be shown in the SQL Dependencies pane:
Object browser, Graph overview, SQL Dependencies, and Column dependencies can be hidden from the main window by deselecting them from the Show panels section:
Different figures of the database on the main diagram can be done by selecting a Layout form from the View tab.
This is an example of the Organic shape:
This is an example of the Circular shape:
This is an example of the Orthogonal shape:
All relationships are shown by default on the main diagram. In the View tab from the Show drop-down menu, All, Foreign key, Schema, Executable can be selected:
Foreign key example:
Schema example:
Executable example:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center