SQL Dependency Tracker - 2.5
Learning SQL Dependency Tracker - 2.5
Analyzing the diagram
When you have added objects to your project, SQL Dependency Tracker displays the dependency diagram in the main view.
Diagram
The Diagram pane shows the dependency diagram for the current project. For example:
Database objects are shown as objects on the diagram. Dependencies between the objects are shown as connections.
When you select a single object on the diagram, if the selected object is used by another object, the connection is shown in red; if the selected object uses another object, the connection is shown in blue. An arrow also indicates the direction of the dependency. Self-references are shown in green.
When you select multiple objects, any direct connections between the selected objects are shown in green.
A stalk indicates that the object has dependencies that are not shown on the diagram, either because they have been hidden, or because they have not been added to the project. You can hover your mouse pointer over the object to see a list of the dependent objects that are not shown.
You can use the navigation tools to change your view of the diagram. For example, you can zoom in to a particular area of interest, or pan the diagram.
SQL Dependency Tracker provides a number of tools for you to customize the diagram to suit your particular needs. For example, you can move objects around, or hide objects so that they are not shown in the diagram. For details of how you can customize the diagram, see Fine tuning the diagram.
Diagram Overview
The Diagram Overview pane provides a bird's-eye view of the diagram.
The Diagram Overview pane always shows the entire diagram; the shaded area indicates the position and size of the current view extent in the Diagram pane.
You use the Diagram Overview pane to change the view in the Diagram pane. For details, see Navigating the diagram.
Objects in Project
The Objects in Project pane lists all the objects in the project. You can use this list to select objects, and to show or hide objects.
The list shows all objects that you have explicitly added to your project, and their dependencies as specified by your diagram options. Objects that you have hidden are included in this list.
Select the 
visibility check box to show the object in the diagram; clear the check box to hide the object.
The Type column indicates the type of object:
|
Tables |
|
Rules |
|
Views |
|
Defaults |
|
Stored Procedures |
|
User Defined Types |
|
Users |
|
Functions |
|
Roles |
|
Full Text Catalogs |
|
Triggers |
|
|
For SQL Server 2005:
|
Assemblies |
|
Queues |
|
|
Asymmetric Keys |
|
Routes |
|
|
Certificates |
|
Schemas |
|
|
Contracts |
|
Services |
|
|
DDL Triggers |
|
Service Bindings |
|
|
Event Notifications |
|
Symmetric Keys |
|
|
Message Types |
|
Synonyms |
|
|
Partition Functions |
|
XML Schema Collections |
|
|
Partition Schemes |
|
|
|
For SQL Server 2008:
|
Stop lists |
By default, the objects are grouped by database, and sorted by object type, then name within type. You can change the way in which the objects are sorted as follows:
- To group the objects by object type and sort by database then name, click the Type column heading.
- To sort the objects by object name with no grouping, click the Name column heading.
- To sort the objects by visibility in addition to the current sort mode, click the column heading.
- To group the objects by database and sort by object type, then name within type (the default), click the DB column heading.
You can filter the list by performing a search on the object names, or by filtering on object type.
Dependencies
The Dependencies pane lists the object dependencies for the selected objects.
Dependencies are listed even if you have hidden them.
The dependencies are grouped:
- Used by: the selected objects are used by the objects listed
- Uses: the selected objects use the objects listed
indicates a Circular reference; a connection to an object that also exists higher up in the hierarchy, or a self-reference.
You can double-click an object in the Dependencies pane to select that object on the diagram and in the Objects in Project pane.
Message Indicator
SQL Dependency Tracker brings any important messages to your attention at the time they occur. However, if further informational messages are available, these are indicated at the bottom-right of the SQL Dependency Tracker window.
For example, when you add an object to the project, if it has a dependent object that belongs to a database that has not been added to the diagram, a message is reported.
You can click the Message Indicator to view the full details of the messages in the Message Report. For details, see Using the Message Report.
See also |
Was this article helpful?
Using SQL Dependency TrackerSetting up the diagram
Working with the diagram
Analyzing the diagramNavigating the diagramSelecting objectsViewing object propertiesFine tuning the diagramResolving external referencesUpdating the projectReportingTips and troubleshootingAcknowledgements
SQL Dependency Tracker
- System.TypeInitializationException on launch (version 2.2)
- Description of the relative importance bar
- Add objects to project option greyed out
- Connections to servers timing out
- SQL Dependency Tracker has encountered an unexpected condition
- SQL Dependency Tracker permissions
- PDF report output running past the bottom of the page
- File or assembly name vjslib not found
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Dependency Tracker
- Activating your products
- Activating your products
- Getting help offline
- SQL Dependency Tracker release notes - version 2.xx
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
