Visualizes SQL Server object dependencies.


Postby dhathewa » Tue Oct 05, 2010 5:31 pm

Can I access an API for SQL Dependency Tracker? Here's why I ask:

We have a number of databases with a large number of objects and a full diagram would be unwieldy. I'd like to set up a project with a subset of objects and that's possible, but the process seems unwieldy for large numbers of objects.

Ideally, I'd like to write a bit of custom program to create a project, set options (to objects used by), populate the project from a list and then save out the resulting diagram. Then we'd reopen the new project in interactive mode.
Posts: 6
Joined: Mon Dec 07, 2009 6:44 pm
Location: Woodbury, MN

Postby chriskelly » Thu Oct 07, 2010 11:48 am

Strictly speaking you wouldn't be able to do this with SQL Dependency Tracker as there is not an API.

However, SQL Dependency Tracker utilises the SQL Compare library to generate the underlying data that it uses. Therefore you may be able to get the results that you are after by using the SQL Comparison SDK. The SDK allows you to harness SQL Compares library in your own code (e.g. C#).

I admit that I have never used the SDK in this way, so I could be wrong. However, if you do hit any problems then email Support and we will see what we can do to help.
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests