ApexSQL Analyze FAQs
General
Please see the following article: Minimum permissions required to install and use ApexSQL products
Yes. All settings and options that are set up in the project can be saved in a
project file by clicking the Save button from the main
ribbon bar. A project file can be consumed via the CLI for unattended execution
in future releases.
Yes, ApexSQL Analyze integrates with SQL Server Management Studio (SSMS) and Visual Studio.
No. ApexSQL Analyze does not have a command-line interface currently.
Dependency Analysis
Yes. To filter out specific objects use the Object browser panel or the Display options from the main ribbon bar.
Yes. To hide unreferenced objects, click the Hide unreferenced
option from the main ribbon bar. To revert that action and show these objects
again, click the Show hidden option.
Yes. ApexSQL Analyze can show column level dependencies for selected objects in the Dependencies panel.
Yes, dependencies of all object types that are listed in the Object browser can be viewed in ApexSQL Analyze.
Yes. The option to set the depth level of dependencies that will be shown in the Dependencies panel can be found in the General tab of the Options window. For example, when the dependency depth is set to 2, dependencies for all selected objects will be shown and additionally the dependencies for referenced and referencing objects will be also visible.
Yes, this can be done using the External database feature. More information
about how to add objects from other databases can be found in the Viewing
cross-database SQL dependencies article.
Somewhere up to 1000 database objects is optimal for the work, over that slows down the work in the application, and the graphical dependencies on the main window are harder to read.
Graphical dependencies
Dependency diagrams can be exported to a variety of formats such as .JPG, .BMP, .PNG. Selected parts of dependency diagrams can also be exported using the Export part option from the main ribbon bar.
Yes. To customize the appearance of dependency diagrams, use the Display options like layout mode, show/hide columns, labels and more.
Available layout styles are Shapes and colors and Icons. These can be found in the Style tab in the Options window. Available layout modes are Organic, Circular, and Orthogonal and these options can be found in the main ribbon bar.
Yes. Any selected object can be removed from the diagram by clicking the Remove option from the right-click context menu. Additionally, selected objects can be removed by pressing the Delete keyboard button. Removing the specified database objects is visual, the objects are not deleted from the database. A removed database object can be restored using the Refresh button from the Home tab.
Information that is shown for each dependency is a list of selected objects, referencing objects and objects that are referenced by the selected object. Additionally, dependency types can be displayed on diagrams when clicking the Show labels toggle button from the main ribbon bar.
Details include:
- the number of objects that are referenced by the selected object,
- the number of referencing objects,
- and the schema and object type, e.g. table
Additionally, object columns can be displayed on diagrams when clicking the "Show columns" toggle button from the main ribbon bar.
Yes, more information about can be found in the How to customize SQL database dependency diagrams article.
Yes, printing out diagrams can be done by using the Print option from the Home tab.