Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
6 replies Latest Post - ‏2014-04-01T14:45:36Z by marcoway
SystemAdmin
SystemAdmin
374 Posts
ACCEPTED ANSWER

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
    59 Posts
    ACCEPTED ANSWER

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

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

    Thanks,
    -April
    • SystemAdmin
      SystemAdmin
      374 Posts
      ACCEPTED ANSWER

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

      ‏2012-12-18T17:57:11Z  in response to null
      Thank you for your reply .
    • marcoway
      marcoway
      3 Posts
      ACCEPTED ANSWER

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

      ‏2014-03-24T10:52:43Z  in response to null

      Hi,

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

      Thanks
      Marco

      • RogerR
        RogerR
        18 Posts
        ACCEPTED ANSWER

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

        ‏2014-03-24T17:34:41Z  in response to marcoway

        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
          ACCEPTED ANSWER

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

          ‏2014-04-01T14:44:36Z  in response to RogerR

          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
          ACCEPTED ANSWER

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

          ‏2014-04-01T14:45:36Z  in response to RogerR

          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