Red Gate forums :: View topic - Add Notes - Feature Suggestion
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

Add Notes - Feature Suggestion

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



Joined: 03 Jun 2009
Posts: 7

PostPosted: Wed Jun 03, 2009 4:20 pm    Post subject: Add Notes - Feature Suggestion Reply with quote

When using DT, I often find myself writing some basic info on the diagrams that I have printed out. Many times it is something like what Class each table/SP may belong to in my application, other times, it is just some basic info.

It would be nice to be able to 'attach' a note to an object in DT. If the note is attached, whenever the layout is re-applied, the note object should move with it.


Shawn
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Wed Jun 03, 2009 6:11 pm    Post subject: Reply with quote

That's a great idea. Better still, do you think that the "note" should simply be the MS_Description extended property? There could be an option to display this description in the object itself? Or do you have a requirement to have these notes saved outside the database?

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
soatley



Joined: 03 Jun 2009
Posts: 7

PostPosted: Wed Jun 03, 2009 6:21 pm    Post subject: Reply with quote

Hi David,

That sounds like a decent idea. I am not too familiar with the extended property, but as long as you can enter a decent amount of data (couple of hundred characters) then that would be good.

Do you think it would be possible for that data to be entered in DT? If not, where is it entered in SSMS?

Shawn
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Wed Jun 03, 2009 6:27 pm    Post subject: Reply with quote

Admittedly it's quite hard to find in SSMS. If you right click the object in Object Explorer, select Properties, then select Extended Properties. Type MS_Description as the Name and your text in the Value.

Alternatively if you own SQL Doc, you can use this to easily input descriptions.

MS_Description is the Microsoft standard way of documenting SQL Server objects. We put functionality in SQL Prompt that allows you to view the MS_Description simply by hovering over the object in your SSMS editor window.

David
Back to top
View user's profile Send private message Send e-mail
soatley



Joined: 03 Jun 2009
Posts: 7

PostPosted: Wed Jun 03, 2009 6:39 pm    Post subject: Reply with quote

Thanks again David. I have a trial of Doc on my machine and yeah, that makes it much easier!

I guess in the end, if it can be displayed as part of DT (some balloon attached to an object) then I think that would be great!

Shawn
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Wed Jun 03, 2009 6:43 pm    Post subject: Reply with quote

I've noted that as a request. I think it would be good to have an option to see the MS_Description on the diagram.

If you right click on an object in the diagram and select "Show SQL", the creation SQL for the extended properties are listed as part of the script. Although these aren't directly visible, maybe you'll be able to use this as a way of storing information with each object? And you would be documenting your database at the same time!

David
Back to top
View user's profile Send private message Send e-mail
soatley



Joined: 03 Jun 2009
Posts: 7

PostPosted: Wed Jun 03, 2009 7:18 pm    Post subject: Reply with quote

Thanks for noting it.

The types of things that I write down on my print out are mainly for a quick reference... something I can look down at the printed diagram and refer to quickly - a cheat sheet if you will.

I can see the SQL in the script and the descriptions I tested it with do appear. Hopefully this feature can be implemented in the future so it will show it as part of the object on the screen. (Obivously with the ability to turn it off as I am sure some people don't want to see that on their dependency output)

Shawn
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Wed Jun 03, 2009 7:24 pm    Post subject: Reply with quote

That was exactly how I had envisaged it. Not everyone will want to see this, so it would need to be an option. Also, it is possible that some will want to use one extended property for Descriptions and one for casual Notes, in which case we could provide somewhere to change which extended property is displayed on the object.

Thanks for raising this. I definitely think there's good mileage in this idea.

David
Back to top
View user's profile Send private message Send e-mail
alex.weatherall



Joined: 29 Nov 2005
Posts: 42

PostPosted: Thu Jun 11, 2009 11:14 am    Post subject: Reply with quote

Hi,
Quote:
Also, it is possible that some will want to use one extended property for Descriptions and one for casual Notes


Yes I think this is a good idea as you might want to note different information without changing the DB documentation.

Also thinking about the link back to SQL Doc in the other direction, things like Notes entered in the other Red-Gate products would be a good optional extra to include in the documentation.

But I think I've already raised something along those lines with you in the SQL Doc forum. Smile

Cheers,

Alex
_________________
Alex Weatherall
TeleWare.com
Back to top
View user's profile Send private message
JimF



Joined: 08 Jul 2008
Posts: 20

PostPosted: Mon Oct 26, 2009 7:48 pm    Post subject: Reply with quote

Hello,

I see that this posting is very new, but I too would like to see notes added to the diagrams. In particular, I would like to see notes that have text independent of the database documentation.

Thanks,
Jim
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