Can I exclude hidden objects from dependency list export?

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Can I exclude hidden objects from dependency list export?

Postby isme » Tue Nov 13, 2012 4:33 pm

My dependency tracker version is 2.7.4.1.

How do I export a dependency list for only the visible objects in the project?

The dependency export feature seems only to export a dependency list for all the objects in the project, visible or hidden.

The exported document contains a message like this:

This report include visible dependencies for all objects in the project.
Objects and dependencies that are not visible are not included.


Based on the behavior of the export function, it would appear 'visible' in this context means 'added to the project' rather than 'not hidden from view'.

Is this the intended behavior?

How to reproduce

Create an example database on your development instance using the following script:

Code: Select all
CREATE DATABASE DependencyTracker_isme_20121113;
GO

USE DependencyTracker_isme_20121113;
GO

CREATE TABLE a (
  b INT PRIMARY KEY,
  c INT
);

CREATE TABLE d (
  e INT PRIMARY KEY FOREIGN KEY REFERENCES a(b),
  f INT
);

CREATE TABLE g (
  h INT PRIMARY KEY FOREIGN KEY REFERENCES d(e),
  i INT
);
GO


Create a new project in SQL Dependency tracker. Add all the tables from database DependencyTracker_isme_20121113 but nothing else.

The main view of SQL Dependency Tracker looks like this:

Image

Export a PDF dependency list.

The PDF should look like this:

Image

The export contains all the same information as the Dependency Tracker main view. So far, so good.

Hide table g.

The main view looks like this:

Image

Export the PDF dependency list again.

The dependency list looks exactly the same:

Image

The table g is not visible in the Dependency Tracker main view, so I would expect to see no reference to it in the exported dependency list.
isme
 
Posts: 81
Joined: Tue Jun 12, 2012 1:49 pm
Location: Edinburgh

Postby Manfred.Castro » Wed Nov 14, 2012 6:59 pm

Sorry you are experiencing this.
This appears to be a known issue under the internal reference number of DT-514
Unfortunaltely I do not have an ETA for a fix.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests