Red Gate forums :: View topic - Need a possibility to change Extended Properties ...
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

Need a possibility to change Extended Properties ...

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
masi



Joined: 28 Nov 2005
Posts: 8

PostPosted: Tue Sep 07, 2010 2:52 pm    Post subject: Need a possibility to change Extended Properties ... Reply with quote

If you make use of Extended Properties functionality in SQL Server 2008 you can see the information in SQL Doc 2 but you can not change it.

Need a mechanism to be able to change Extended properties via the tool.

Will that be possible ?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1111

PostPosted: Tue Sep 07, 2010 4:04 pm    Post subject: Reply with quote

Thanks for the suggestion. Is there any reason why this isn't something you can modify in the SSMS properties dialog? Is it something you think is more suited in the SQL Doc UI?

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



Joined: 28 Nov 2005
Posts: 8

PostPosted: Tue Sep 07, 2010 6:02 pm    Post subject: Reply with quote

Right - I can do it by using SSMS BUT SQL Doc will be much more user friendly.

Of course there is also a possibility to use simple SQL-statements but that's not really what we want to do. The maintanace of all Extended Props will be made by end-users responsible for all meta-data for a huge database system.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1111

PostPosted: Tue Sep 07, 2010 8:47 pm    Post subject: Reply with quote

Ah - that's interesting. Do the end users who will be making those changes have SSMS on their desktops or will they only have SQL Doc?

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



Joined: 28 Nov 2005
Posts: 8

PostPosted: Tue Sep 07, 2010 9:37 pm    Post subject: Reply with quote

They will only have SQL doc. No intention to roll out SSMS.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1111

PostPosted: Tue Sep 07, 2010 9:38 pm    Post subject: Reply with quote

Thanks for the additional info.

How would this best work for you in SQL Doc? Is the current interface adequate, or should there be an easier way to input this information?

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



Joined: 28 Nov 2005
Posts: 8

PostPosted: Wed Sep 08, 2010 11:15 am    Post subject: Reply with quote

The current interface is absolutely adequate.

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



Joined: 05 Dec 2005
Posts: 1111

PostPosted: Wed Sep 08, 2010 11:57 am    Post subject: Reply with quote

Would you need to add new extended properties from SQL Doc, or do you only need to edit exsiting ones?

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



Joined: 28 Nov 2005
Posts: 8

PostPosted: Wed Sep 08, 2010 4:27 pm    Post subject: Reply with quote

We need to add new extended properties as well as maintanence of already entered Extended Props.
Back to top
View user's profile Send private message
masi



Joined: 28 Nov 2005
Posts: 8

PostPosted: Thu Oct 21, 2010 1:10 pm    Post subject: Reply with quote

Just checking if there is any progress on this case ...

Best regards
Matti Sirén
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1111

PostPosted: Thu Oct 21, 2010 2:18 pm    Post subject: Reply with quote

We'd really like to accommodate this feature in a future release, but we can't at this stage make any short term promises. At the moment we fully recognize that just supporting the one extended property, MS_Description is restrictive to many.

Kind regards,

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



Joined: 04 Nov 2010
Posts: 2
Location: Phoenix, AZ

PostPosted: Mon Nov 22, 2010 6:41 pm    Post subject: You can add my name to this request Reply with quote

We have about 7 extra properties we'd like to include with our database documentation for each field in out tables. Being able to edit and add these is key.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1111

PostPosted: Mon Nov 22, 2010 6:44 pm    Post subject: Reply with quote

How would you want these to be accommodated in the documentation? (in terms of layout)
Back to top
View user's profile Send private message Send e-mail
fargs



Joined: 28 Feb 2013
Posts: 1

PostPosted: Thu Feb 28, 2013 8:40 pm    Post subject: Reply with quote

It looks like this has been requested and tracked for a very long time (SDOC-775). I am updated to the latest version of SQL Doc and it is still not implemented. Is this going to happen? It would be a very useful feature. It doesn't necessarily have to be in SQL Doc. It could be a plug in to SSMS. I am currently using this for free.

http://datadictionary.codeplex.com/

Thanks,
Back to top
View user's profile Send private message
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