Access schema dependencies via sql toolkit

Forum for users of SQL Toolkit 3,4,and 5

Access schema dependencies via sql toolkit

Postby jeffreydp » Tue Mar 11, 2008 5:24 pm

Hi,

Is there a way to derive the dependencies from selected differences that is accessible via the toolkit?

I've skimmed the docs but I fail to turn up anything.
jeffreydp
 
Posts: 5
Joined: Tue Mar 11, 2008 5:21 pm

Postby Michelle Taylor » Wed Mar 12, 2008 12:20 pm

The Toolkit doesn't document or make visible the mechanism for doing this, because it's currently unreliable - in most cases it will get the same answer as the SQL Compare UI, but there are certain cases where SQL Compare will get it right and just the Toolkit alone will get it wrong.

The mechanism for playing with dependancies is as follows:

There is a method of the Work class called Work.SetImplicitlySelectedDifferences which takes a Differences object and sets the dependancy flags appropriately.

In each Difference object within that Differences object, there is a boolean field called 'SelectedImplicitly' which is meant to tell you if an object has been selected as a dependancy.

However, these have both been made deliberately invisible so that people don't rely on them, as there are quite a variety of cases where they will give out misleading information.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software


Return to SQL Toolkit Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests