Red Gate forums :: View topic - cross-database dependencies
Return to www.red-gate.com RSS Feed Available

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

cross-database dependencies

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
RobSchripsema



Joined: 11 Feb 2010
Posts: 3
Location: USA, Washington state

PostPosted: Mon Oct 25, 2010 10:35 pm    Post subject: cross-database dependencies Reply with quote

I'm not a customer yet -- just working with my 14-day trial.

Question: the release notes (for 1.3) and the product sheet state that SQL Doc "Includes all cross-database dependencies". What exactly is this referring to? Is this something that can be created/documented within the SQLDoc tool, or is it something that is set up in the database(s) and SQLDoc documents it? If the latter, how does one set up such dependencies?
_________________
Rob Schripsema
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Wed Oct 27, 2010 2:14 pm    Post subject: Reply with quote

Hi Rob,

Thanks for your post.

Can I confirm whereabouts you are looking for this information? The release notes for 1.3 ar ein the below link:

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Doc&c=SQL_Doc/articles/version_1xx_SQLDoc.htm

Either way, the tool will pull in external dependencies, i.e. where a sproc is retrieving data from a table in a different DB. This is something that the tool will document, but it will not implement it for you. Further information on setting up linked servers is available from the below link:

http://msdn.microsoft.com/en-us/library/aa213778%28SQL.80%29.aspx

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
RobSchripsema



Joined: 11 Feb 2010
Posts: 3
Location: USA, Washington state

PostPosted: Wed Oct 27, 2010 11:09 pm    Post subject: Reply with quote

Pete,

I found the information at the bottom of the following page (Version 1.3 release notes, I think):
http://www.red-gate.com/messageboard/viewtopic.php?p=26487#26487.

My question is not with linked servers or stored procs, but the ability to note that, for example, a key/code field in a table in one database is actually a foreign key to a lookup table that is in a different database. I don't believe there is a way to denote this in the SQL schema itself; I was hoping (when I saw the 1.3 release notes) that there could be a way for me to note this in the documentation.

I suppose I could just put it into the extended_property Description field as part of the field documentation, but I was hoping for something a little more sophisticated.
_________________
Rob Schripsema
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Nov 05, 2010 6:16 pm    Post subject: Reply with quote

Hi Rob,

You could note this by altering the extended properties on objects within the DB if you wanted, and this would be classed as a schema update as you would be altering the MS_Description of an object.

Would that suit your needs?

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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