Dependencies of views

Automate and integrate using the SQL comparison API

Dependencies of views

Postby Waldo2k2 » Thu Aug 21, 2008 3:43 pm

I've been evaluating the SDK version 7 and came across an interesting scenario.
When syncing database schema, it came across a view whose select statement referenced a table that did not exist.
In my syncing process I would like to remove objects with unmet dependencies such as this from the differences collection.
Is there any supported method of doing this?
Posts: 11
Joined: Thu Aug 21, 2008 2:44 pm

Postby Brian Donahue » Sun Sep 07, 2008 7:23 pm

Hi Waldo,

Thanks for pointing this out. There isn't a public API for getting the dependency tree from the SQL Compare Engine, even though we both know the information is there somewhere in a private object. I hadn't looked into it in awhile, but back in v3, analyzing a dependency chain was a complicated matter of popping pointers off a stack and casting them as objects.

What I had suggested to the product manager for the SDK on Friday was to open up some of Dependency Tracker as a public API, which probably wraps up some of the complicated internal stuff from SQL Compare and presents it in a more usable form.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Postby Waldo2k2 » Sun Sep 07, 2008 11:13 pm

Thanks for the update Brian, let me know if they do open up the API.
Posts: 11
Joined: Thu Aug 21, 2008 2:44 pm

Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests