Red Gate forums :: View topic - Add Extended properties Directly From SqlDoc
Return to www.red-gate.com RSS Feed Available

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

Add Extended properties Directly From SqlDoc

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
HLEBOEUF



Joined: 10 Feb 2006
Posts: 11

PostPosted: Thu Dec 13, 2007 4:35 pm    Post subject: Add Extended properties Directly From SqlDoc Reply with quote

Is there a way on entering Directly Extende Propertires from SqlDoc, if not that would be usefull.
I've seen some questions on the forum that asked for specifying parameters on functions and procedures. Yoy can add extended properties directly from SqlMgtStudio. SqlDoc displays them nicelly.
But wouldn't it be great that we could add them directly ....
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Thu Dec 13, 2007 5:53 pm    Post subject: Reply with quote

Yes, you can do this. Add extended properties by clicking on the appropriate "pen and paper" icon in the Preview pane. This brings up a text box in which you can type your comment.

Let me know if you have trouble finding this.

Regards,

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



Joined: 10 Feb 2006
Posts: 11

PostPosted: Fri Dec 14, 2007 7:24 am    Post subject: Reply with quote

As fas ar i see i can only edit one Extended property MS_Description.
In this case, for functions and procedures it would be usefull if we could add or own. Param1 till Paramx for example.
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Fri Dec 14, 2007 12:22 pm    Post subject: Reply with quote

Yes, we only do the one. I will put in a feature request for custom extended properties to be added. The more user requests we get, the more likely it is to be considered.

Thanks!

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



Joined: 20 Jun 2008
Posts: 5

PostPosted: Fri Jun 20, 2008 2:57 pm    Post subject: Request ability to add custom extended properties Reply with quote

I alsorequest support for custom extended properties.

The ability to add additional named extended properties can be very valuable, not only in defining structured documentation, but also as tools for change management to control what gets deployed to various environments.

And for a tie-in to another great RedGate tool, SQLCompare Pro could even be enhanced to use extended properties for automatically filtering what gets scripted -- i.e., include only objects where "Include_In_Build" = "True" or exclude objects where "Exclude_From_Build" = "False".
Back to top
View user's profile Send private message
David Atkinson



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

PostPosted: Fri Jun 20, 2008 3:04 pm    Post subject: Reply with quote

Thanks for the feedback.

Regarding your idea to use extended properties as a flag to exclude objects from a SQL Compare synch script, I'm not so sure this would be the right place. It's more likely that we'll extend the SQL Compare project concept to allow objects to be more easily excluded from a comparison. Is this something that would work for you too?

Currently you can uncheck certain objects in SQL Compare after the comparison. These selections should be saved with the project, meaning they won't be scripted when the project is run again, although they still appear in the comparison results screen.

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