General
What are the minimum permissions required to install and use ApexSQL Analyze?
What are the system requirements for ApexSQL Analyze?
Can I save my projects and options for future reference?
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.
Is ApexSQL Analyze offered as an add-in in SQL Server Management Studio and or Visual Studio?
No. Currently, ApexSQL Analyze is a stand-alone application. Integration into SQL Server Management Studio is planned for ApexSQL Analyze 2018 R2.
Can I run ApexSQL Analyze unattended via a CLI?
No. ApexSQL Analyze does not have a command line interface currently. This feature is planned for ApexSQL Analyze 2018 R2.
Dependency analysis
Can I filter objects from my display diagrams?
Yes. To filter out specific objects use the Object browser panel or the Display options from the main ribbon bar.
Can ApexSQL Analyze identified unreferenced objects in my database? If so, how can I hide these objects?
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.
Can ApexSQL Analyze show which object columns participate in a dependency relationship?
Yes. ApexSQL Analyze can show column level dependencies for selected objects in the Dependencies panel.
Can ApexSQL Analyze identify dependencies that exist in dynamic SQL in objects like stored procedures and functions?
Yes, dependencies of all object types that are listed in the Object browser can be viewed in ApexSQL Analyze.
Can I manage which dependency levels are shown?
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.
Can I add objects from other databases?
No, adding objects from other databases is currently not possible. The External database analysis feature is planned for future releases of ApexSQL Analyze.
Graphical dependencies
What export options do I have in ApexSQL Analyze?
Dependency diagrams can be exported to a variety 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.
Can I change the layout and appearance of objects in ApexSQL Analyze?
Yes. To customize the appearance of dependency diagrams, use the Display options like layout mode, show/hide columns, labels and more.
What layout styles and modes are available?
Available layout styles are Shapes and colors and Icons. These can be found in the Layout tab in the Options window. Available layout modes are Organic, Circular and Orthogonal and these options can be found in the main ribbon bar.
Can I selectively remove objects from a diagram?
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.
What information is shown for each dependency?
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.
What detail is shown for each object?
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.
Can I print out diagrams?
Not currently, but this feature is planned in future versions of ApexSQL Analyze.
