Topic
  • 6 replies
  • Latest Post - ‏2014-04-01T14:45:36Z by marcoway
SystemAdmin
SystemAdmin
374 Posts

Pinned topic Reverse engeneering MS SQL 2005 database -column and tables descr.

‏2012-12-18T12:38:46Z |
Hi,

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.
Updated on 2012-12-18T17:57:11Z at 2012-12-18T17:57:11Z by SystemAdmin
  • null
    null
    60 Posts

    Re: Reverse engeneering MS SQL 2005 database -column and tables descr.

    ‏2012-12-18T17:00:37Z  
    IDA doesn't support SQL Server comments yet. It will be in the future release.

    Thanks,
    -April
  • SystemAdmin
    SystemAdmin
    374 Posts

    Re: Reverse engeneering MS SQL 2005 database -column and tables descr.

    ‏2012-12-18T17:57:11Z  
    • null
    • ‏2012-12-18T17:00:37Z
    IDA doesn't support SQL Server comments yet. It will be in the future release.

    Thanks,
    -April
    Thank you for your reply .
  • marcoway
    marcoway
    3 Posts

    Re: Reverse engeneering MS SQL 2005 database -column and tables descr.

    ‏2014-03-24T10:52:43Z  
    • null
    • ‏2012-12-18T17:00:37Z
    IDA doesn't support SQL Server comments yet. It will be in the future release.

    Thanks,
    -April

    Hi,

    do you know if now IDA supports comments on SQLServer Tables?

    Thanks
    Marco

  • RogerR
    RogerR
    18 Posts

    Re: Reverse engeneering MS SQL 2005 database -column and tables descr.

    ‏2014-03-24T17:34:41Z  
    • marcoway
    • ‏2014-03-24T10:52:43Z

    Hi,

    do you know if now IDA supports comments on SQLServer Tables?

    Thanks
    Marco

    Hi,

    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.

    Regards,

    Roger

  • marcoway
    marcoway
    3 Posts

    Re: Reverse engeneering MS SQL 2005 database -column and tables descr.

    ‏2014-04-01T14:44:36Z  
    • RogerR
    • ‏2014-03-24T17:34:41Z

    Hi,

    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.

    Regards,

    Roger

    Hi Roger,

    thank you for the response.
    Do you have any example on this or you know where to find an example to send to customer?

    Ciao
    Marco

  • marcoway
    marcoway
    3 Posts

    Re: Reverse engeneering MS SQL 2005 database -column and tables descr.

    ‏2014-04-01T14:45:36Z  
    • RogerR
    • ‏2014-03-24T17:34:41Z

    Hi,

    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.

    Regards,

    Roger

    Hi Roger,

    thank you for the response.
    Do you have any example on this or you know where to find an example to send to customer?

    Ciao
    Marco