| General |
|
Added |
Import/Export options for CSV (comma separated
values) files for table columns and table
constraints (beta) |
|
|
|
Model Designer |
|
Added |
Parent and
child tablenames to the relationship object hint |
|
Added |
Option to
display table triggers |
|
Added |
Option to
display table check constraints |
|
Added |
Optional
offset spacing value for auto-layout mode |
|
|
|
Table Editor |
|
Added |
Missing
"generate" state indicator for triggers (Trigger
tab) |
|
Added |
Foreign
key constraints are now generated in the table
editor (DDL tab) |
|
Fixed |
If the
trigger flag "generate" is unchecked the trigger
code is no longer displayed in the DDL tab |
|
Fixed |
Primary
key field sort order when adding and removing fields
with the column list editor |
|
|
|
Sequences |
|
Added |
"Generate"
indicator flag |
|
|
|
Generators |
|
Added |
"Generate"
indicator flag |
|
|
|
Object renaming |
|
Added |
Rename
capabilities for table columns (Rename objects
dialog) |
|
|
|
Print preview |
|
Changed |
Increased
maximum print scale to 20.0 for pdf output. There is
a default setting in the erdconcepts.ini
configuration file if higher scales are required |
|
|
|
PostgreSQL |
|
Fixed |
Display
of varchar data types with array definition (all
versions) |
| General |
|
Added |
Keyboard
shortcuts to several dialog windows |
|
Added |
Name
templates for domains, sequences and generators |
|
Added |
Text
formatting when saving search and validation results
to a file |
|
Added |
Object
schema names for tables, views and routines can now
be selected through a drop down list |
|
|
|
Model Designer |
|
Added |
New design
object: Bezier lines with arrows to indicate
relationships between arbitrary objects |
|
Added |
New design
object: Rectangle shape object with variable border
width and optional rounded corners |
|
Added |
Print
scale factor is now saved per diagram page instead
of per model |
|
Added |
Printer
orientation is now also saved per page |
|
Added |
Option to
display table column descriptions |
|
Added |
Option to
register generators and sequences with table
triggers |
|
Added |
Object
hints are now displayed with object type |
|
Added |
Object
hint threshold option (configuration window) to
determine when to show object hints |
|
Changed |
Print page
preview is now painted above all objects |
|
Fixed |
Style
manager settings were not saved after closing ERD
Concepts |
|
Fixed |
"Postion"
menu items renamed to "Position" |
|
Fixed |
Model
navigator was not updated when the object display
style was changed |
|
|
|
Images |
|
Changed |
Image
objects can be resized. Auto size option added to go
back to the default size based on image width and
height |
|
|
|
Views |
|
Added |
"View"
display settings (Columns / Description) |
|
Added |
Option to
extract view columns from defined script |
|
|
|
Reverse engineering |
|
Added |
Reverse
engineering options are now saved for later use |
|
Added |
Option to
add a script terminator to triggers, views and
routines during reverse engineering. This also
applies to "Compare with Database" |
|
Added |
Option to
extract view columns from script |
|
|
|
Generate database |
|
Fixed |
Defined
columns in table trigger code were not properly
quoted <[column]> |
|
|
|
Notes |
|
Added |
%PAGENAME%
macro to the note object |
|
|
|
Routinegroups |
|
Added |
Search
option to the Routine Group editor |
|
|
|
Table editor |
|
Added |
Indexes
and triggers to table DDL preview |
|
Changed |
ALT+U and
ALT+D for moving columns up and down in the table
editor are changed to CTRL+ALT+U and CTRL+ALT+D |
|
|
|
SQL Query Designer |
|
Added |
Partial
redesign of the sql query designer |
|
Fixed |
<*> symbol
is no longer enclosed in quotes |
|
|
|
Execute SQL |
|
Added |
Query
timeout option (default 30 seconds) |
|
|
|
PostgreSQL 9 |
|
Fixed |
Added
missing script template file |
| General |
|
Added |
Support
for SQLite 3 |
|
Added |
Model
option to auto generate foreign key constraint
indexes when creating a new relationship |
|
Added |
Generate
foreign key constraints within the table create
statement instead of using alter statements
Change of resource script needed (Use SQLite 3
script as an example) |
|
Added |
Saving
model image as PNG (Portable network Graphics) |
|
Fixed |
Error in
window (re)positioning when working on dual monitor
systems. Showing modal windows outside the desktop
boundaries |
|
|
|
Generate Database |
|
Added |
Button for
selecting all objects |
|
|
|
Reverse engineering |
|
Added |
Additional
option: Extract table indexes |
|
Added |
Additional
option: Extract table check constraints |
|
Added |
Additional
option: Extract table triggers |
|
|
|
Trigger editor |
|
Fixed |
Load SQL
button in the trigger dialog pointed to the default
model folder instead of the SQL script folder |
|
|
|
Model designer |
|
Fixed |
Access
violation (List Index out of bounds) while calling
AutoLayout in a sub diagram page |
|
|
|
Routine Groups |
|
Added |
Edit
routines directly from the object browser or search
results without opening the routinegroup editor |
|
Added |
Script
preview section in the Routinegroup editor |
|
Fixed |
Moving
routines between groups would not update the object
browser |
|
|
|
HTML Reports |
|
Added |
Default
HTML output folder. You can now start the report
generator with the following parameters:
- Param 1 -> ERD Concepts model file
- Param 2 -> Default report output folder |
|
Fixed |
Destination folder never used during report
generation |
|
|
|
Interbase |
|
Added |
Support
for Interbase 2007 and 2009 |
|
Added |
Reverse
engineering of table comments |
|
Changed |
Object
naming length set to 67 characters for version 7 and
higher |
|
Fixed |
Comparing
of generators always failed |
|
|
|
Firebird |
|
Fixed |
Comparing
of generators always failed |
| General |
|
Added |
New
AdventureWorks demo model for SQL Server 2005 |
|
Added |
You can
now use "translate" to duplicate an existing model |
|
Moved |
Query
designer menu option under the model menu |
|
Fixed |
Painting
bug in the text editor when adding very large lines
(3000+) |
|
|
|
Model designer |
|
Added |
You can
now resize the design area by moving objects beyond
the left and top page boundaries |
|
Added |
Auto
layout option (horizontal or vertical) as defined in
the configuration editor |
|
Fixed |
Resizing
objects outside the page boundaries |
|
Fixed |
Pressing
the right mouse button while dragging objects will
cancel the drag operation |
|
Fixed |
Copying
objects to a new model through the clipboard would
sometimes raise an access violation |
|
|
|
Domains |
|
Added |
"Generate"
as script option |
|
|
|
Stamp Object |
|
Added |
Property
"Row lines visible" in order to show or hide the row
dividers. Before the border visible property
controlled the visibility of the row dividers |
|
|
|
Query designer |
|
Added |
Identifiers are now quoted when the option "quote
identifiers" is selected in the environment options
dialog (script tab) |
|
|
|
Generate Database |
|
Changed |
All
selected objects are now marked for generation
instead of only the last selected table. When there
is no selection the complete model or active page
will be generated (Table -> Task -> Generate DDL) |
|
|
|
DDL Viewer |
|
Changed |
Scripts
are printed with "courier new" as font |
|
|
|
Execute SQL |
|
Added |
Option to
log errors only instead of listing all executed
commands in a batch |
|
|
|
Database script generation |
|
Changed |
Domains
are always exported even if they are not used. This
way you can use the domain list as a user data type
definition list |
|
|
|
Search Dialog |
|
Added |
You can
now limit the scope to tables, relationships, views
and routine groups |
|
|
|
SQL Server 2005 |
|
Added |
Support
for (PRIMARY) XML indexes |
|
Updated |
Database
translation table |
|
|
|
SQL Server 2008 |
|
Updated |
Database
translation table |
|
Fixed |
Reverse
engineering of primary xml indexes |
|
Generate Database |
|
Added |
Per page,
a "generate" script option for tables,
relationships, views and routine groups |
|
Added |
Script
option to apply the NULL constraint keyword |
|
Changed |
On
database generation the result script is splitted
into a separate create and drop script which can be
saved to individual files |
|
|
|
Environment options |
|
Added |
Button to
restore the .ecm file extension association in
Windows explorer. Options -> Tab Cache -> "Associate
.ecm files with ERD Concepts" |
|
|
|
HTML Report |
|
Added |
Button to
select a different output file |
|
Added |
Model
begin/end scripts to default report |
|
Added |
Object
description fields to the default report |
|
Fixed |
Comment
output |
|
|
|
Compare with database |
|
Added |
Option to
compare view scripts |
|
Added |
Option to
compare routine scripts |
|
Added |
Option to
select or unselect actions through a context menu |
|
Removed |
Checkbox
selection in the compare result list |
|
Fixed |
Routines
are no longer added to a model in separate groups |
|
Fixed |
Access
violation when updating the database (script
generation) |
|
Fixed |
Adding
relationships to a model when a table already exists |
|
|
|
Reverse engineering |
|
Fixed |
Adding
relationships to a model without adding the
constraint tables including missing columns (auto
generated) |
|
|
|
Object selection |
|
Added |
Shortlist
is now integrated into the selection area |
|
|
|
Table |
|
Added |
Added a
model option to auto-arrange table columns based on
primary keys or keep it as-is (user based) |
|
Changed |
Default
primary key indicator changed from "*" to "PK" and
added as a separate display column like the FK and
NN indicators |
|
|
|
Relationship |
|
Added |
Model
option to regenerate the relationship name when a
connected table is renamed |
|
Fixed |
The
primary key was not applied to relationships based
on key order but on table column order which could
result in an invalid foreign key definition |
|
|
|
Groupbox |
|
Fixed |
Transparent style property |
|
|
|
View & routines |
|
Removed |
Auto
generate drop script option because the drop script
is generated to a separate file which always uses
the default drop statement |
|
|
|
Model properties |
|
Added |
Model
begin/end scripts splitted in a create and drop
section |
|
|
|
Object script templates |
|
Fixed |
The way
script templates are loaded and saved internally to
prevent overwriting existing template changes made
in other edit screens |
|
|
|
Print preview |
|
Fixed |
Print
preview window didn't resize properly when trying to
make it smaller |
|
|
|
Execute SQL |
|
Added |
Option to
print a result set |
|
Fixed |
Removed an
obsolete edit area from the value preview section |
|
Fixed |
Using
quote identifiers now applies the correct syntax for
object names |
|
Fixed |
Browsing a
result set sometimes caused an exception while
displaying values |
|
|
|
Query Designer |
|
Added |
Columns
are highlighted when a link is clicked |
|
Changed |
Link
context menu under a right mouse click only. A left
mouse click will highlight the specific columns |
|
Changed |
Table name
is displayed with the table alias name instead of
only showing the table alias |
|
|
|
DB2 UD9 |
|
Added |
Native
reverse engineering script |
|
|
|
Firebird 2.x |
|
Added |
Native
datatype INT64 |
|
Added |
Foreign
key constraint update/delete keyword "RESTRICT" |
|
Removed |
Schema
names are no longer listed during reverse
engineering and database comparison. These schemas
(owner names) are simulated by the latest "official"
Firebird ODBC driver and are not supported natively
by Firebird |
|
|
|
PostgreSQL |
|
Added |
Support
for Beta version 9.x |
|
Fixed |
Version 8
attribute dimension (array) notation order |
|
|
|
SQL Server 2005/2008 |
|
Added |
Datatypes
Varchar(Max), NVarchar(Max), Varbinary(Max) (using
the old "max" property has become obsolete but is
still available) |
|
Designer |
|
Added |
Selected
objects displayed with focus indicators instead of a
different line style |
|
Added |
New
environment option "Show full image while moving
objects" to increase performance while working with
large models |
|
Added |
You can
now mark a page as default startup page through the
page list. The start page is shown first after
loading from disk. This way you can skip the very
often large main page and go directly to a sub model
page.
(Tip: Use right mouse button while in the page list) |
|
Added |
Option to
set the number of columns to display while using the
object selection dialogs like "Add Model Objects"
and "Reverse Engineering"
Options -> Select List -> Horizontal Columns
0 = Single column vertical list
1..4 = Number of horizontal columns to display |
|
Added |
Option to
display a short list during object selection. This
is a list with all selected objects |
|
Added |
Option to
restrict the length of displayed object names |
|
Added |
Print
option for search and validation results |
|
Added |
Option to
clear all bookmarks |
|
Changed |
Opening a
model through windows explorer no longer reloads
the last opened model(s) (desktop files) |
|
Fixed |
Pasting a
relationship while the child table was deleted would
raise an error condition |
|
Fixed |
Minimizing
the application to and from the system tray would
not restore some gui elements
resulting in a forced restart |
|
Fixed |
Problem
while locating objects through the object browser
and search/validation results |
|
Fixed |
reloading
an already opened model from disk would only show
empty objects |
| |
|
Model Options |
|
Added |
Max.
visible rows option also applied to views and routinegroups |
| |
|
Page Properties |
|
Added |
Comment/description field |
| |
|
Page Completion |
|
Added |
Add
Related Tables |
|
Added |
Add
Related Tables Dialog (specific table selection) |
|
Added |
Add
Missing Relationships |
|
Added |
Option to
delete objects from the model while working on submodel pages |
| |
|
Add model objects dialog |
|
Added |
Display
list per object type |
|
Added |
Filter
input saved for later use |
|
Changed |
Existing
objects are no longer listed |
|
Changed |
Relationships are no longer listed and are added
automatically |
| |
|
Routinegroups |
|
Added |
Additional
gradient header style: top to bottom |
|
Added |
Style
property Footer text color |
|
Added |
Style
property Footer fill color |
|
Fixed |
Repositioning routines using the routine editor
would not refresh the routine list properly |
|
Fixed |
Moving
routines through a sub model page would not set the
default source routinegroup properly |
| |
|
ID Stamp Object |
|
Added |
Page name |
|
Added |
Row
spacing |
|
Added |
Row line
color |
|
Changed |
Always
auto sized |
| |
|
Table Object |
|
Added |
Additional
gradient header style: top to bottom |
| |
|
Table Editor |
|
Fixed |
A scenario
in the table editor where column names where not
saved when adding multiple columns at a time |
| |
|
View Object |
|
Added |
Additional
gradient header style: top to bottom |
| |
|
Database script generation |
|
Added |
Execute
SQL button to run a generated script without first
going through several windows. However a database
connection must exist otherwise an error is raised |
| |
|
SQL Server (2008) |
|
Added |
Support
for "XML" indexes |
|
Added |
Support
for non-clustered primary keys |
What's new in version 5.0 |
| |
|
Added |
Page/model
properties to object context menus |
|
Added |
Selection
filter options to the "add model objects" dialog |
|
Added |
Support
for bookmarks to save the current view in the
designer.
The following shortcuts can be used:
CTRL + SHIFT + [1..5] -> Save bookmark / save position
CTRL + [1..5] -> Restore bookmark (go to saved position)
|
|
Added |
Column
reordering buttons in the index/key editor |
|
Added |
Support
for routine groups. Routine groups are used to
display routines in your model and for grouping
related routines together |
|
Added |
GIF as
image export format |
|
Added |
Separate
schema input field for tables, views and routines |
|
Added |
Detail
selection of objects during database generation
including views, routines, sequences and generators |
|
Added |
Database
translation based on datatype level
instead of datatype groups |
|
Added |
Datatype repository to define and configure
datatypes and reuse them
in multiple models |
|
Added |
"Enclose
identifiers in quotes" option added to environment
editor. This setting now also applies when
generating table sql scripts through the table
object context menu |
|
Added |
Redesign
of the Execute SQL module |
|
Added |
Print
scale is now saved within the model file. The actual
print scale is displayed in the print
preview window |
|
Changed |
Moved the
Domain, Sequence and generator lists back to the
model menu instead of tabs on the bottom side of the
design window |
|
Updated |
The
following object macros are modified or added
Tables:
%TABLE_NP% Object name
%TABLE_SP% Schema name
%TABLE_NAME% Oject name + Schema name
Views:
%VIEW_NP% Object name
%VIEW_SP% Schema name
%VIEW_NAME% Object name + Schema name
Triggers:
%TRIGGER_NP% Object name
%TRIGGER_SP% Schema name
%TRIGGER_NAME% Object name + Schema name
Routines:
%ROUTINE_NP% Object name
%ROUTINE_SP% Schema name
%ROUTINE_NAME% Object name + Schema name |
|
Updated |
Objects
used in multiple submodels are no
longer copied with all properties. Each shared object
now points to only one global instance of an object.
This reduces overall file size and loading time |
|
Updated |
Minimizing
the application to the taskbar is now conform
windows |
|
Updated |
"vertical
row spacing" property renamed to vertical font
spacing and also
applies to views and routinegroups. Row spacing can also
be set to a negative value (values range from -10 to
+10) |
|
Updated |
Help file
contents |
