Search

Add full extented property support to SSDT by Mark Freeman

Closed
as Won't Fix Help for as Won't Fix

2
0
Sign in
 to vote
Type: Suggestion
ID: 779313
Opened: 2/15/2013 9:56:22 AM
Access Restriction: Public
0
Workaround(s)
I can go into SSMS 2012, right-click on a table, select Properties, select the Extended Properties page, and then enter names and values. However, if I go into VS 2010 with SSDT (December 2012 version), right-click on a table, select Proprerties, and there is no mention of Extended Properties. I can't view, add, edit, or delete them.

I would like to see full support for extended properties on databases, schemas, tables, table columns, view, and view columns.

Details (expand)

Product Language

English

Category

Developer Tools (SSDT, BIDS, etc.)

Proposed Solution

Add full extented property support to SSDT.

Primary Benefit

Improved Administration

Other Benefits

I have two reasons for this. First is to be able to track database, schema, table, and view version numbers. Second is to be able to someday generate documentation on the tables, table columns, views, and view columns for report designers and others that need to understand the purpose and expected content for these objects.

Because I create and change all database objects in SSDT (using TFS for version control), I want to manage the extended properties for these objects in the same tool.

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Mark Freeman on 2/22/2013 at 6:27 AM
Adam,

>defining extended properties are fully supported in SSDT and DACFx including project build, and deployment

Where can I find the documentation on the existing SSDT support for extended properties? I don't see any obvious way through the SSDT UI to create one on any object type. Or do I have to create them in the database manually or through SSMS and the import them via a database to project Schema Comparison?

Thanks,
Mark
Posted by Microsoft on 2/21/2013 at 6:27 PM
Hey Mark,

Thanks for your feedback around design-time Extended Property support in SSDT. At this time, the team is not pursuing the addition of an extended property designer. One thing to make sure folks understand is that defining extended properties are fully supported in SSDT and DACFx including project build, and deployment.

Thanks and let us know if you have any additional feedback or questions!
Adam Mahood
Program Manager
SQL Server Database Systems
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement