Main Menu
Login
SSL SecureMode
Username:
Password:  
Lost Password?
Register now!
ChangeVision Members Map
Search
Forum Index   -   Topic Index
   Bug information about Astah
     [Fixed in 6.9] Generating SQL scripts fails in some cases

Threaded | Newest First Previous Topic | Next Topic | Bottom
Poster Thread
webmaster
Posted on: 2014/4/11 11:34
Webmaster
Joined: 2006/4/27
From:
Posts: 287
[Fixed in 6.9] Generating SQL scripts fails in some cases
1. Product Version
Astah Professional 6.7 and 6.8

2. Description
Generating SQL scripts fails if the ER Diagram contains a Subtype relationship and one end has a Primary key like the figure below.


























3. Solution
Change one of the options on [Export SQL] dialog.
(1) Go to [Tool] - [ER Diagram] and open [Export SQL] dialog and click [Option] button













(2) Remove the check from [Export Create Table statement with constraints (OFF : Alter Table)] and click OK

















Now SQL scripts would be generated without errors.

4. Status
This bug will be fixed in the next release.

5. Bug ID
5138/5313

PS: Thank you for your report, Marcelo.
Threaded | Newest First Previous Topic | Next Topic | Top