Main Menu
Login
SSL SecureMode
Username:
Password:  
Lost Password?
Register now!
ChangeVision Members Map
Search
Forum Index   -   Topic Index
   How to use of Astah (Pro/SysML/GSN/Com)
     ERD DB Reverse with MS SQL Server 2008

Threaded | Oldest First Previous Topic | Next Topic | Bottom
Poster Thread
Joba
Posted on: 2010/10/7 10:21
Developer
Joined: 2006/6/6
From:
Posts: 969
Re: ERD DB Reverse with MS SQL Server 2008
Hello again Vladel,

According the MSDN Library, it says as follows about varchar Data.
Quote:
The char or varchar data can be a single character, or a string with a maximum of 8,000 characters for char data, and up to 2^31 characters for varchar data. The varchar data types can take two forms. varchar data can be of a specified maximum length of characters, for example, varchar(6) indicates that this data type can store a maximum of six characters; or it can be of the form varchar(max), which increases the maximum number of characters that can be stored by this data type to 2^31.
So the result of import of MS SQL Server DB 2008 through astah* Database Reversing tool is the current specification.
Quote:
Is there a way to import those attributes?
Still no unfortunately.

Best regards,
Satomi
Joba
Posted on: 2010/9/28 2:59
Developer
Joined: 2006/6/6
From:
Posts: 969
Re: ERD DB Reverse with MS SQL Server 2008
Hello Vladel,

Quote:
Is there a way to import those attributes?
We've confirmed the issue you reported and are afraid that there is no way to import these attributes correctly. We have another issue regarding the Database reversing tool, so we shall take a look at both of them.

Thank you very much for your clear report. We'll post here if there are any updates. And if you have any other problems, please let us know. Thank you.

Best regards,
Satomi
Vladel
Posted on: 2010/9/23 23:29
Just popping in
Joined: 2010/9/23
From:
Posts: 1
ERD DB Reverse with MS SQL Server 2008
Hello,

I try to reverse engineer a MS SQL Server DB. The DB contains tables with VARCHAR(max) attributes. The import runs fine, but the result isn't correct. The VARCHAR(max) attributes result in VARCHAR(2147483447), which isn't a correct VARCHAR length. The allowed length is only <= 8000 or even max. The older attribute TEXT and IMAGE are proccesed fine.

Is there a way to import those attributes?

Best regards

Vladel
Threaded | Oldest First Previous Topic | Next Topic | Top