ERD Concepts Changelog

What's new in ERD Concepts 8.0.4

Sep 29, 2018
  • Free for non-commercial use license:
  • New free license plan for non-commercial use, meaning: Use the software only during activities which (a) are not undertaken for profit, or (b) is not intended to produce works, services, or data for commercial use, or (c) is neither conducted, nor funded, by a person or entity engaged in the commercial use, application or exploitation of software products;
  • General:
  • Added: Ignore not null constaint option in schema editor. This will disable the not null constraint keyword output during script generation.
  • HTML Report:
  • Changed: Full report html template. Triggers, views and routines are now displayed in 1 column instead of a multi column table.

New in ERD Concepts 8.0.3 (Jun 21, 2018)

  • Fixed: Problem with internal XML Format of the ecm design files

New in ERD Concepts 8.0.2 (Apr 2, 2018)

  • Designer:
  • Fixed: Problem with pages when adding and removing objects
  • Database Scripts:
  • Added: Object comments now available in DDL tab
  • Fixed: Comments not exported during database generation
  • ADO Connections:
  • Added: Differentiation between x84 and x64 bit connection strings
  • Oracle:
  • Changed: Length symantics no longer processed during reverse engineering

New in ERD Concepts 8.0.0 (Nov 2, 2017)

  • General:
  • Added: Both 32-bit and 64-bit versions of the software are now available
  • Added: Sample files are copied to the user/model folder during setup
  • Fixed: Selects with shortlist: Recursive refresh of shortlist after mask select
  • Designer:
  • Added: Filter validation output on error, warning and/or hint
  • Added: Last used folder during "open/save as" operations is now saved
  • Added: Satellite mode is now cancelled on right mouse button click
  • Added: Satellite mode will now register the last clicked object in the object browser search box
  • Added: Show Index/Key Columns to <model><table display> menu
  • Added: Removed hinting when copying scripted objects in the same designer
  • Added: Support for PNG image files for loading in image objects
  • Fixed: Potential dead-lock situation during hierarchical autolayout operation
  • Table Editor:
  • Added: Data types are displayed together with the names in the import column dialog
  • Added: Close button for each tab
  • Fixed: Random access violation while deleting 1 or more columns
  • Fixed: Copying a column would not update the PK, NN of AI checkboxes
  • Fixed: Saving existing index storage script as template
  • View Editor:
  • Updated: Optimized column name script extraction
  • Object Browser:
  • Added: Selecting an object in the browser will automatically select/find the object in the diagram
  • Added: Collapsing a node will also collapse all sub-items
  • Removed: The "Find Object" method
  • Execute SQL:
  • Added: Option to clear script history list
  • Syntax Editor
  • Fixed: EOL comment with a single quote would start a quoted string for the next line
  • Todo List:
  • Added: Todo list set to modaless so you can save changes without closing the dialog first
  • Added: Display filter (Todo, completed, All)
  • Added: Completed date attribute
  • Routinegroup Editor:
  • Added: Search filter instead of search highlighting
  • Added: Syntax highlighting and text search in code preview section
  • Query Builder:
  • Fixed: Sort order selection was missing
  • Model options / Shared:
  • Changed: Max. number of rows, default to 0 (unlimited)
  • Changed: Trim name longer than, default to 0 (unlimited)
  • Style editor:
  • Fixed: Creating or renaming a style group would hide the style manager
  • Schema Configuration Editor:
  • Fixed: Generator properties not saved as expected
  • Data Editor:
  • Added: Generate GUID value for selected field
  • Added: Progress indicator while opening datasets
  • Generate database:
  • Added: Total object count added to the individual tabs
  • Added: Database schemas can be created using the "create schema script" section. In order to use this for existing models add the script sections manually or import a default schema definition file using the schema editor.
  • Fixed: Clearing the filter editbox would only reset the object list when focused
  • SQL Lite:
  • Updated: Schema update for the database translation table
  • Supported databases:
  • Added : Support for Interbase XE7
  • Added : Support for Interbase 2017
  • Added : Support for SQL Server 2017
  • Discontinued:
  • Interbase 2007
  • Access 2003
  • SQL Server 2005
  • Oracle 9i

New in ERD Concepts 7.4.0 (Sep 3, 2017)

  • Designer
  • Added : The following model property tags can be used during script DDL generation
  • %MODEL_TITLE%
  • %MODEL_AUTHOR%
  • %MODEL_DBMS%
  • %MODEL_COPYRIGHT%
  • %MODEL_VERSION%
  • %MODEL_DATECREATED%
  • %MODEL_DATEMODIFIED%
  • Added : User defined SQL syntax editor colors
  • Table Editor
  • Added : Edit the default data type parameters (length, decimals and array defs) directly in the column editor
  • Added : Delete column prompt replaced by column list with multi select options
  • Data type conversion
  • Added : Wildcard search option
  • Fixed : After conversion the list with properties was filled with default values. The old properties are now copied
  • Style Manager
  • Changed : Applied some small UI layout changes
  • SQL Server
  • Added : Support for SQL Server 2016
  • Fixed : Binary length parameter which was displayed as required (v2014)
  • Firebird
  • Added : Support for Firebird 3.x

New in ERD Concepts 7.1.0 (Feb 6, 2015)

  • Designer:
  • Added : Auto layout type "Hierarchical" (Top-Down)
  • Added : Auto layout dialog for easier selection of the auto layout type
  • Object Browser:
  • Added : Auto Increment flag (-AI) for table columns
  • Stamp object:
  • Added : Output display filter
  • Rename Objects:
  • Fixed : Case sensitive search option
  • HTML Report:
  • Fixed : Data type output without additional options
  • Fixed : Foreign key table name output generated as error
  • Script Templates:
  • Added : Improved template explorer for easier browsing and editing
  • Added : Default script template: "macro: %TERM%"
  • Reverse Engineering:
  • Added : Added "ignore column collation name" option
  • Fixed : Reverse engineering of routines
  • CSV Export
  • Added : Page selection box. You can now export tables and foreign keys per page
  • Fixed : Data type output without additional options
  • Schema Editor:
  • Added : Import option to load a template into an existing model file (refresh)
  • Changed : Schema ID replaced with script template (tpl) filename
  • Oracle (all versions):
  • Removed : Foreign key delete rule "NO ACTION"

New in ERD Concepts 7.0.0 (Nov 14, 2014)

  • General:
  • Added : Improved portability of model files. Each model file now contains the complete schema configuration. This way you can publish your model file to others without the need to add any local customized schema (.ini) definition files.
  • Local schema configuration (.ini) files are now local templates used when starting a new model. You can create, your own, fully customized schemata files. There is no longer a hard-coded link between a schema template, the target database and an existing model.
  • This also means that changing a schema template will no longer alter the model file in any way.
  • Due to this new feature we decided to drop the support for the "data type repository" which heavily depended on fixed schema definition files. Now each model can contain its own data types so maintaining a global data type repository is no longer possible.
  • Added : Improved performance while working with large model files
  • Added : %TERM% macro for all script parts to support automatic translation of the script terminator sequences (GO, ;, / etc)
  • Added : A data table editor for direct editing of database tables. The used ADO driver must support schema extraction to retrieve the available tables from the database
  • Added : Mandatory flag to the designer hint for relationships
  • Fixed : XML encoding error (ecm files) which resulted in a non standard XML format
  • Version Control:
  • Added : Custom archive filenames. After selecting "version control" you are prompted for a archive filename
  • Shape object:
  • Added : Additional shapes Diamond and Arrows left\rigtht\up\down
  • Connection Editor:
  • Added : Database connection string field in the database connection editor is now set through an edit box for easier configuration and copying the connection string to the Windows clipboard
  • Fixed : Cancelling the "Open UDL" dialog in the database connection editor would apply an invalid/empty connection string setting
  • Object Browser:
  • Added : Do not generate indicator for database objects
  • Schema Conversion Tool:
  • Added : Support for assigning new schema names
  • Added : Support for removing existing schema names
  • Execute SQL:
  • Changed : (Blob) field display
  • Added : NULL indicator for empty fields
  • Added : Export to CSV option
  • Changed : Run key F9 remapped to F5
  • Added : SQL Format options: To Uppercase and To Lowercase
  • Table editor:
  • Fixed : Renaming a column used in a trigger autoincrement definition would remove the referenced old column
  • Routine Groups:
  • Changed : Move routines task replaced by a move routine flag in the import routines dialog
  • HTML Report:
  • Added : Multiple sub reports for individual parts of a model
  • Changed : Generate reports from unsaved models
  • Schema Editor:
  • Added : Renaming a data type will also change all references in the same schema file
  • Added : Reserved words are now included in the schema files
  • Added : Comma separated strings are now made available in a text listbox
  • Changed : Data type mappings are now included in each schema template file
  • Changed : The schema ID field is now a reference to a local script template file only. It's a free text input field in order to support custom database schemata
  • Fixed : Problem while renaming data types in a long list and trying to select a new data type afterwards. The new selection would result in an unexpected data type due to scrolling issues
  • SQL Server:
  • Added : Support for SQL Server 2014
  • Changed : The length parameter for the Binary data type is now optional. It was required and default set to 0 which is invalid because the value should be none, 1 or higher.
  • Oracle:
  • Added : Support for Oracle 12c
  • Microsoft Access:
  • Added : Support for MsAccess 2013
  • Interbase:
  • Added : Support for Interbase XE3
  • PostgreSQL:
  • Added : Support for PostgreSQL 9.3 / 9.4
  • MySQL:
  • Changed : Renamed enum/set property "Items" to "Elements"

New in ERD Concepts 6.3.0 (Mar 14, 2014)

  • Designer:
  • Added : Default database schema option
  • Added : Schema switch tool to quickly change a targeted schema
  • Fixed : Error in cardinality notation
  • Fixed : Incorrect validation error message was displayed when checking for duplicate object names
  • Fixed : Model change and creation dates always set to the current system date
  • Updated : Help documentation
  • Compare with database:
  • Added : Compare with model file
  • Execute SQL:
  • Fixed : Settings written to an old ERD Concepts folder
  • HTML Reporting:
  • Fixed : Generators were reported as sequence
  • CSV Import / Export:
  • Fixed : Error in the loading code of CSV files
  • Oracle:
  • Added : Added reverse engineering of the length_sematics parameter (BYTE/CHAR)
  • MySQL 5:
  • Fixed : Added missing index option "Using"
  • Firebird2:
  • Added : Table/column comment ddl statements
  • Interbase 2009/XE:
  • Added : Table/column comment ddl statements
  • Added : Missing routine comment script
  • SQL Server 2012:
  • Added : Table comment ddl statement (TESTEN!)
  • MsAccess 2010:
  • Removed : obsolete data types DECIMAL / HYPERLINK
  • Added : extra data types GUID / LONGTEXT / VARBINARY / SHORT / LONG
  • Updated : with compression specifiers

New in ERD Concepts 6.2.0 (Nov 18, 2013)

  • Designer:
  • Added : Option to capture the model view to the Windows clipboard (SHIFT + F3)
  • Added : A validation warning for missing schema names
  • Fixed : Loading a model with added data type properties would not merge the added properties correctly
  • Fixed : Validation of primary key constraints. Invalid or missing primary keys are now detected with a hint flag
  • Diagram Navigator:
  • Fixed : Accidental painting of satelite mode
  • Compare with database:
  • Added : Option to disable script tags used during database/diagram comparison. Use the schema editor to customize the used macro tags. The following tags are currently defined -
  • table_column.collate
  • table_column.length_semantics (Oracle)
  • create_primarykey.storage
  • create_uniqueconstraint.storage
  • create_index.storage
  • Changed : Renamed the terms ‘Source’ and ‘Target’ as they were ambiguous to Model -> Database
  • Added : Grouped object detail view and object code in one display section. Double clicking a detail item will now automatically switch to code review
  • Added : The Display Filter is also be applied to the object detail list (show differences only)
  • Added : Visible option (check box) to select or deselect all flagged changes
  • Added : Objects without a schema name are also included in the compare results
  • Added : List is now sorted based on object type + name
  • Added : Display filter based on object type
  • Added : By default results are compared case-insensitive. An option is added to use case sensitive comparison
  • Fixed : Dropping a primary key constraint from the database would use the constraint name defined in the model instead of using the constraint name from the database
  • Fixed : Updating foreignkeys would reset/redraw all relationship lines
  • Reverse Engineering:
  • Added : Database schema search box
  • Added : A new option "Ignore foreign key NO ACTION integrity flag". NO ACTION will be read as undefined (default empty)
  • Schema Editor:
  • Fixed : Deleting an inputfield would not refresh the list properly
  • IBM DB2:
  • Added : Schema support for version 10.x
  • SQL Server 2012:
  • Fixed : Added missing drop routine DDL statement to schema definition
  • Oracle:
  • Changed : Renamed property Symantec to Length_symantics (Char and Varchar2 data types)
  • Added : CASCADE keyword when dropping primary or unique constraints
  • Help Documentation:
  • Added : Missing description of the auto increment (AI) column in the table editor

New in ERD Concepts 6.1.0 (Aug 2, 2013)

  • Table Indexes:
  • Added : Index properties added to the index dialog. Properties can be defined with the schema editor. The property editor is hidden when no properties are defined
  • Reverse Engineering:
  • Fixed : Auto delete of foreign keys when the option indexes and unique constraints" was switched off
  • Sequence / Generator:
  • Fixed : Generator properties not loaded in editor
  • Fixed : Sequence and Generator names not saved without previewing DDL
  • Fixed : Tab order in sequence editor
  • Table Triggers:
  • Fixed : Auto Increment name part truncated during script generation
  • Compare with database:
  • Changed : Partially redesigned due to received requests to improve usability
  • SQL Server 2012:
  • Added : Support for filtered indexes

New in ERD Concepts 6.0.0 (Apr 20, 2013)

  • Added : A schema editor to edit or create custom database definition files including data types and auto-increments like generators and sequences
  • Added : Cut/Copy/Paste/Delete mouse menu in text/code editors
  • Added : Version control with compare function to generate alter scripts
  • Changed : ERD Concepts is now UAC compliant
  • Changed : Windows manifest is now embedded within the executable with invoker rights only
  • Added : Object inspector now indicates mandatory properties with a special color
  • Added : Support for translation of auto-increment columns: Serial/Identity/Trigger
  • Added : Support for translation of generators to sequences when unsupported by the target DB and vice versa
  • Changed : Default datatypes are now defined per schema definition instead of per user
  • Added : Creation of Ms Access 2010 ACCDB database (Tools menu) If you don't have Acccess 2007 or 2010 on your machine, you need to download the Microsoft Access Database Engine 2010 Redistributable
  • Added : Shortcut for page options CTRL-F3
  • Fixed : Coloring bug in the SQL syntax editor using quoted 'strings'
  • Added : Satellite mode. When clicking on a table in the designer, highlight the table and all it's immediately connected relations and tables
  • Added : Having selected a table and it's "Satellites", copy to selected tables and relationships to a new diagram
  • Added : DDL previews for domains, sequences, views and routines
  • Relationships:
  • Added : IDEF1X diagram notation
  • Changed : Cardinality and integrity notation are now displayed as a symbol. You can display the roles at the same time (separate option)
  • Crowsfeet
  • IDEF1X
  • Cardinality
  • Ref. Integrity
  • None (hide symbols)
  • Groupbox:
  • Added : Optional rounded border painting (default)
  • Rectangle:
  • Changed : Renamed to Shape with shape style setting
  • Added : Ellipse shape style
  • Bezier:
  • Changed : A bezier is created as straight arrow by default
  • Added : Direction indicator when creating a new bezier. This makes it easier and quicker to place arrows between objects
  • Table Triggers:
  • Added : Option to create or edit a sequence/generator within the trigger editor
  • Sequences:
  • Added : Optional schema name edit field
  • Added : Schema names are available in other object editors
  • Added : Show the table triggers linked with a sequence from the sequence list (Sequence usage)
  • Added : Duplicate name check with generators (Firebird 2.x)
  • Generators:
  • Added : Show the table triggers linked with a generator from the generator list (Generator usage)
  • Added : Duplicate name check with sequences (Firebird 2.x)
  • Generate Database/Scripting:
  • Added : Option to include foreign key constraints in the table create statement
  • Object Browser:
  • Added : Shortcut buttons for collapse/expand/edit/search
  • Reverse Engineering:
  • Added : Select/Deselect all schemata option to the reverse engineering wizard
  • Execute SQL:
  • Added : Table columns are now sorted on their ordinal position (DB depended) in the object browser
  • Updated : Browser icons
  • Fixed : Sorting the result grid with fields including spaces generated an error message
  • Table Editor:
  • Added : Datatype indicator for domains above the data type property editor
  • Removed : Primary key divider option which depended on another table option "Sort primary key columns"(Obsolete)
  • Fixed : Domain datatype properties not always saved when exiting with the OK button
  • Index Editor:
  • Changed : When a database schema doesn't support ordering of individual index columns (index level only) all keys are automatically set to the same sort order when changed
  • HTML Report:
  • Added : Visual indication that a report is being generated
  • Updated : New program icon
  • Changed : The startup parameter list changed for HTMLReport.exe. This is now a
  • configuration file with the following report startup settings:
  • SOURCE= Source file (.ecm)
  • OUTPUT= Default report output folder (optional)
  • TEMPLATES= Default report template folder (optional)
  • -- HTMLReport.exe startup parameter --
  • CONFIG = Filename with the above report start parameters
  • The selected template and preview setting are saved in this new configuration start file after generating the report.
  • Compare with database:
  • Added : Uses the reverse engineering feature to select the objects from the database which offers more flexibility
  • SQL Server 2012:
  • Added : COLUMNSTORE, FULLTEXT and SPATIAL index types
  • MYSQL:
  • Added : Using BTREE/HASH index type definition
  • Oracle:
  • Removed : Support for Oracle 8 Only the last three major versions are supported
  • Added : Length symantecs (BYTE/CHAR) for varchar data types
  • Interbase:
  • Added : Support for Interbase XE
  • Removed : Support for older versions 5, 6 and 7. Only the last three major versions are supported
  • SQL Server:
  • Removed : Support for SQL Server 2000 Only the last three major versions are supported
  • Ms Access:
  • Added : Support for Access 2010
  • SQLite:
  • Added : Support for autoincrement columns
  • Added : Index sorting on column level

New in ERD Concepts 5.6.7 (Nov 13, 2012)

  • Added: Support for Ingres v10
  • Added: Support for SQL Server 2012
  • Fixed: Error when generating an update script during compare with database
  • Fixed: Some windows theming issues in Classic mode
  • Fixed: Query Designer: SQL not updated when moving to a different cell
  • Fixed: Query Designer: SQL definition error when a field alias was defined
  • Fixed: Database translation editor: typing/selecting the same type as in the key column the editor would disable the edit field

New in ERD Concepts 5.6.2 (Sep 1, 2012)

  • Added : "Save as Image" now includes a copy to clipboard option
  • Added Shortcut menu to the table variable list
  • Added Option to hide the SQL preview pane in the Query designer
  • Added Option to align the column output vertically in the Query designer
  • Added History support viewer for 10 items in the Execute SQL window
  • Updated Product manual
  • Changed Adding a new column in the table editor will now insert the new column instead of adding it at the end of the list
  • Changed Adding a new column in the view editor will now insert the new column instead of adding it at the end of the list
  • Changed Removed "AS" keyword for table aliases in the query designer. For some database servers it was marked as an invalid keyword and generated a syntax error
  • Changed The option "show full image" is removed due to perfomance and updating issues while working with large models
  • Fixed Paint bug while dragging objects and scrolling/zooming at the same time. Thanks goes to Ronald Falder for reporting this issue

New in ERD Concepts 5.6.0 (May 3, 2012)

  • General:
  • Updated Default install path changed to "Program Files (x86)" for 64 bit OS
  • Added Cursor position indicator to the internal DDL viewer
  • Changed Selection list handling and configuration
  • Added Always show shortlist in object selection dialogs (configuation setting)
  • Added Active filter selection while typing in the object selection dialogs
  • Added Model create and drop scripts are now accesible as main menu item
  • Changed Layout of the model script dialog
  • Added Length control options for generated object names:
  • Code Description:
  • Ln Left, copy n characters from the left
  • Mn,m Mid, start at character n and copy m count characters (n always starts at position 1)
  • Rn Right, copy n characters from the left
  • Example:
  • TABLE_NAME -> %TABLE_NP:L5% -> TABLE
  • TABLE_NAME -> %TABLE_NP:R4% -> NAME
  • TABLE_NAME -> %TABLE_NP:M5,3% -> E_N
  • Moved Bookmark submenu moved to main menu bar (Bookmark menu)
  • Added The default resource folder is now configurable. You can create your own folder with customized database template definitions
  • Changed System folder configuration presented in a grid instead of individual edits
  • Added Improved xml compatibility for .ecm file contents
  • Added Rename objects with an action setting: Replace, Prefix and Append
  • Fixed Wilcard processing in the object selection dialogs. Setting the filter did not work as expected
  • Fixed Default column value not added during CSV table export
  • Fixed Reverse engineering through ADO would sometimes return a column as nullable while part of a primary key
  • Model Designer:
  • Added Auto layout option for copied objects after using page completion
  • Added Page properties to the model menu
  • Fixed Mouse event would stay active in the designer after leaving and returning to the
  • Design area
  • Fixed Relationship label positions where not reset after autolayout
  • Fixed Display error for table captions with a right alignment style. The text was not completly visible on lower zoom levels
  • Table editor:
  • Added Custom script macro editor for table objects. Define your own custom table properties
  • Added Table column naming template with %TABLE_NP% support
  • Fixed Optimized macro handling for column check constraints using the VALUE tag. eg. field name BoolValue would be translated to BoolBoolValue
  • Relationship editor:
  • Fixed Changing the parent key multiple times in the relationship editor would sometimes result in an invalid column defintion
  • Generate database:
  • Added "Unselect all objects" while in the
  • HTML Report:
  • Added We have changed the script object names to improve compatibility with Java script.
  • All variables %NAME% are now prefixed with the object name. eg:
  • table -> %TABLE_NAME%
  • routine -> %ROUTINE_NAME%
  • Added Model variables are allowed in the HTML header and footer sections
  • Added Inline column check constraint to the HTML report definition
  • Added Made the location for report templates configurable
  • Changed The startup parameter list changed for HTMLReport.exe
  • SOURCE= Source file (.ecm)
  • OUTPUT= Default report output folder (optional)
  • TEMPLATES= Default report template folder (optional)
  • Fixed HTML character conversion for ""
  • Routinegroups:
  • Added A routine can now be marked as "global". This means on database creation the routine code is inserted right after the model create script and can therefore be referenced by tables, views and other objects
  • Datatype repository:
  • Added The macro %TABLE_NP% can also be used in the datatype repository
  • PostgreSQL:
  • Added Column comment statement in database script
  • Ms Access:
  • Fixed Ms Access alter table script definition contained an error

New in ERD Concepts 5.5.0 (Aug 1, 2011)

  • 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
  • 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

New in ERD Concepts 5.4.0 (Mar 21, 2011)

  • 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

New in ERD Concepts 5.3.0 (Oct 4, 2010)

  • General:
  • New AdventureWorks demo model for SQL Server 2005 (working version)
  • You can now use "translate" to duplicate an existing model
  • Query designer menu option under the model menu
  • Painting bug in the text editor when adding very large lines (3000+)
  • Model designer:
  • You can now resize the design area by moving objects beyond the left and top page boundaries
  • Auto layout option (horizontal or vertical) as defined in the configuration editor
  • Resizing objects outside the page boundaries
  • Pressing the right mouse button while dragging objects will cancel the drag operation
  • Copying objects to a new model through the clipboard would sometimes raise an access violation
  • Domains:
  • "Generate" as script option
  • Stamp Object:
  • 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:
  • Identifiers are now quoted when the option "quote identifiers" is selected in the environment options dialog (script tab)
  • Generate Database"
  • 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
  • Option to log errors only instead of listing all executed commands in a batch
  • Database script generation:
  • 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:
  • You can now limit the scope to tables, relationships, views and routine groups
  • SQL Server 2005:
  • Support for (PRIMARY) XML indexes
  • Database translation table
  • SQL Server 2008:
  • Database translation table
  • Reverse engineering of primary xml indexes

New in ERD Concepts 5.2.0 (Aug 9, 2010)

  • 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)

New in ERD Concepts 5.1.0 (Apr 30, 2010)

  • 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
  • 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
  • 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

New in ERD Concepts 5.0.0 (Mar 16, 2010)

  • 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 printscale 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