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.

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.

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.

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.