| Author |
Message |
masi
Joined: 28 Nov 2005
Posts: 8
|
 Posted: Tue Sep 07, 2010 2:52 pm Post subject: Need a possibility to change Extended Properties ... |
 |
|
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 |
|
 |
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Tue Sep 07, 2010 4:04 pm Post subject: |
|
|
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 |
|
|
masi
Joined: 28 Nov 2005
Posts: 8
|
| Posted: Tue Sep 07, 2010 6:02 pm Post subject: |
|
|
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 |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Tue Sep 07, 2010 8:47 pm Post subject: |
|
|
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 |
|
|
masi
Joined: 28 Nov 2005
Posts: 8
|
| Posted: Tue Sep 07, 2010 9:37 pm Post subject: |
|
|
| They will only have SQL doc. No intention to roll out SSMS. |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Tue Sep 07, 2010 9:38 pm Post subject: |
|
|
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 |
|
|
masi
Joined: 28 Nov 2005
Posts: 8
|
| Posted: Wed Sep 08, 2010 11:15 am Post subject: |
|
|
The current interface is absolutely adequate.
Thanks ! |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Wed Sep 08, 2010 11:57 am Post subject: |
|
|
Would you need to add new extended properties from SQL Doc, or do you only need to edit exsiting ones?
David |
|
| Back to top |
|
|
masi
Joined: 28 Nov 2005
Posts: 8
|
| Posted: Wed Sep 08, 2010 4:27 pm Post subject: |
|
|
| We need to add new extended properties as well as maintanence of already entered Extended Props. |
|
| Back to top |
|
|
masi
Joined: 28 Nov 2005
Posts: 8
|
| Posted: Thu Oct 21, 2010 1:10 pm Post subject: |
|
|
Just checking if there is any progress on this case ...
Best regards
Matti Sirén |
|
| Back to top |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Thu Oct 21, 2010 2:18 pm Post subject: |
|
|
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 |
|
|
joshturley
Joined: 04 Nov 2010
Posts: 2
Location: Phoenix, AZ
|
| Posted: Mon Nov 22, 2010 6:41 pm Post subject: You can add my name to this request |
|
|
| 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 |
|
|
David Atkinson
Joined: 05 Dec 2005
Posts: 1080
|
| Posted: Mon Nov 22, 2010 6:44 pm Post subject: |
|
|
| How would you want these to be accommodated in the documentation? (in terms of layout) |
|
| Back to top |
|
|
fargs
Joined: 28 Feb 2013
Posts: 1
|
| Posted: Thu Feb 28, 2013 8:40 pm Post subject: |
|
|
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 |
|
|
|
