Dependencies of views

Automate and integrate using the SQL comparison API

Moderators: Chris Auckland, Chris Auckland

Dependencies of views

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

Hello,
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?
Waldo2k2
 
Posts: 11
Joined: Thu Aug 21, 2008 3:44 pm

Postby Brian Donahue » Sun Sep 07, 2008 8: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: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Waldo2k2 » Mon Sep 08, 2008 12:13 am

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


Return to SQL Comparison SDK Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests