SQL Dependency Tracker - 2.4
Learning SQL Dependency Tracker - 2.4
Using SQL Dependency Tracker
SQL Dependency Tracker™ enables you to track dependencies within and between Microsoft® SQL Server™ databases.
This is useful, for example, in a development environment when changes to a database are planned. Before the changes can be safely made to the database schema, it is important to know which other parts of the schema will be affected by the changes. The removal of a column from a table, for example, will affect any stored procedures that reference that column. In order to maintain the integrity of the database, these dependents will also have to be changed.
With SQL Dependency Tracker, you can select the objects that are going to be changed, and SQL Dependency Tracker will automatically find their dependencies for you. If required, it will also find objects that are dependent on the dependencies, and so on. You can then look at the creation SQL of the dependent objects to determine whether they will be affected by the proposed change.
When you have identified the dependencies, you can save a record of the dependency diagram, for example for archiving or inclusion in a report, by exporting to PDF, image, or XML format.
SQL Dependency Tracker is compatible with SQL Server 2000 and SQL Server 2005.
For information on what's new in this version, see http://www.red-gate.com/support/versions/version2xx_sqldependencytracker.html.
See Also |
Was this article helpful?
Getting startedSQL 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
