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.
Does ApexSQL Analyze integrate with SQL Server Management Studio (SSMS) and/or Visual Studio?
Yes, ApexSQL Analyze integrates with SQL Server Management Studio (SSMS) and Visual Studio.
Can I run ApexSQL Analyze unattended via a CLI?
No. ApexSQL Analyze does not have a command-line interface currently.
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?
How many database objects can be shown in the ApexSQL Analyze?
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
What export options do I have in ApexSQL Analyze?
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.
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 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.
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. 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.
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 customize the SQL database dependency diagrams?
Can I print out diagrams?
Yes, printing out diagrams can be done by using the Print option from the Home tab.