Red Gate forums :: View topic - Access schema dependencies via sql toolkit
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

Access schema dependencies via sql toolkit

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jeffreydp



Joined: 11 Mar 2008
Posts: 5

PostPosted: Tue Mar 11, 2008 5:24 pm    Post subject: Access schema dependencies via sql toolkit Reply with quote

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.
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 528
Location: Red Gate Software

PostPosted: Wed Mar 12, 2008 12:20 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group