Home
 Forum Index - Topic Index How to use of Astah (Pro/SysML/GSN/Com)
ERD DB Reverse with MS SQL Server 2008 |
| Threaded | Newest First | Previous Topic | Next Topic | Bottom |
| Poster | Thread |
|---|---|
| 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 |
| 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? 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 |
| 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. Quote: Is there a way to import those attributes?  Best regards, Satomi |
| Threaded | Newest First | Previous Topic | Next Topic | Top |
