Pinned topic Reverse engeneering MS SQL 2005 database -column and tables descr.
I use Data Architect 8.1 and have a problem with documentation with following:
1. When I try to reverse a data model from MS SQL 2005 DDL script all comments (for tables and columns) was lost
2. When I try to generate a DDL for MS SQL 2005 - the same - nothing from documentation fields not included in DDL script.
Do you have any ideas - this feature not supported by Data Architect or the tool needs some special configuration.
Thank you in advance.
null 0600011FWD59 Posts
RogerR 060000WPD018 PostsACCEPTED ANSWER
Re: Reverse engeneering MS SQL 2005 database -column and tables descr.2014-03-24T17:34:41Z in response to marcoway
IDA now supports SQLServer extended properties which is the mechanism SQLServer uses to associate user defined information with database objects. The extended property names are free form but by convention I believe that the extended property MS_Description is used to associate user documentation (comments) with the database objects.
So you can associate a comment with an object by defining the MS_Description (if I remembered that correctly) extended property on the object.