Need a possibility to change Extended Properties ...

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Need a possibility to change Extended Properties ...

Postby masi » Tue Sep 07, 2010 2:52 pm

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 ?
masi
 
Posts: 8
Joined: Mon Nov 28, 2005 11:02 am

Postby David Atkinson » Tue Sep 07, 2010 4:04 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby masi » Tue Sep 07, 2010 6:02 pm

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.
masi
 
Posts: 8
Joined: Mon Nov 28, 2005 11:02 am

Postby David Atkinson » Tue Sep 07, 2010 8:47 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby masi » Tue Sep 07, 2010 9:37 pm

They will only have SQL doc. No intention to roll out SSMS.
masi
 
Posts: 8
Joined: Mon Nov 28, 2005 11:02 am

Postby David Atkinson » Tue Sep 07, 2010 9:38 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby masi » Wed Sep 08, 2010 11:15 am

The current interface is absolutely adequate.

Thanks !
masi
 
Posts: 8
Joined: Mon Nov 28, 2005 11:02 am

Postby David Atkinson » Wed Sep 08, 2010 11:57 am

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

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby masi » Wed Sep 08, 2010 4:27 pm

We need to add new extended properties as well as maintanence of already entered Extended Props.
masi
 
Posts: 8
Joined: Mon Nov 28, 2005 11:02 am

Postby masi » Thu Oct 21, 2010 1:10 pm

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

Best regards
Matti Sirén
masi
 
Posts: 8
Joined: Mon Nov 28, 2005 11:02 am

Postby David Atkinson » Thu Oct 21, 2010 2:18 pm

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
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

You can add my name to this request

Postby joshturley » Mon Nov 22, 2010 6:41 pm

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.
joshturley
 
Posts: 2
Joined: Thu Nov 04, 2010 1:34 am
Location: Phoenix, AZ

Postby David Atkinson » Mon Nov 22, 2010 6:44 pm

How would you want these to be accommodated in the documentation? (in terms of layout)
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby fargs » Thu Feb 28, 2013 8:40 pm

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,
fargs
 
Posts: 1
Joined: Thu Feb 28, 2013 5:13 pm


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 1 guest