Red Gate forums :: View topic - How To Find Missing Dependencies
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

How To Find Missing Dependencies

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
IanT8



Joined: 30 Apr 2010
Posts: 2

PostPosted: Fri Apr 30, 2010 2:49 am    Post subject: How To Find Missing Dependencies Reply with quote

I've just used SQL Packager to package up a database and then install the package. The database creation process failed when it tried to create a view that depends on a table that dooes not exist.

I checked the original database, and indeed, the required table does not exist.

To my surprise, Dependency Tracker does not show dependencies that cannot be resolved.

Is there any way I can discover these broken dependencies using SQL Dependency Tracker or indeed any other method?

Thanks,
Ian.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Fri Apr 30, 2010 10:43 am    Post subject: Reply with quote

Unfortunately this isn't a feature of SQL Dependency Tracker.

Finding invalid objects is going to be a feature of SQL Prompt 5, which will be out sometime this summer. I can put you on the beta notification list if you like, which means you'll be able to try an early version of the functionality.

In the meantime, you'll have to do what you're doing. If you try to use SQL Compare (or SQL Packager) to deploy your schema to an empty database, it will fail due to these invalid objects. You can then fix them one by one. It's not ideal, but until we've added this feature to SQL Prompt, it's the best I can think of.

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
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