Author Topic: SQL Server Reverse on views: truncated definition  (Read 3380 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1374
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
SQL Server Reverse on views: truncated definition
« on: April 20, 2018, 11:19:28 pm »
Hi,

I got the result of an EA reverse engineering run on a SQL Server DB that contains views. When the view definition (query) is longer than 4000 characters, the resulting definition in EA (viewdef tag memo) is truncated at this position.
I found a post on this issue here: http://www.sparxsystems.com/forums/smf/index.php/topic,10962.msg148710/topicseen.html#msg148710

Is there a way to resolve this in SQL Server, ODBC configuration or else?

Thanks
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: SQL Server Reverse on views: truncated definition
« Reply #1 on: April 23, 2018, 08:05:41 am »
Upgrade to EA version 13.5?

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1374
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Re: SQL Server Reverse on views: truncated definition
« Reply #2 on: April 23, 2018, 11:58:13 pm »
Hi,

I can confirm that it works fine with the latest build.

Thanks,
Guillaume
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com