Red Gate forums :: View topic - Dependencies of views
Return to www.red-gate.com RSS Feed Available

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

Dependencies of views

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Waldo2k2



Joined: 21 Aug 2008
Posts: 11

PostPosted: Thu Aug 21, 2008 4:43 pm    Post subject: Dependencies of views Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6577

PostPosted: Sun Sep 07, 2008 8:23 pm    Post subject: Reply with quote

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



Joined: 21 Aug 2008
Posts: 11

PostPosted: Mon Sep 08, 2008 12:13 am    Post subject: Reply with quote

Thanks for the update Brian, let me know if they do open up the API.
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