eXERD™ Release Note

The followings are the details of each release of eXERD. Check the ongoing tasks at http://exerd.com.

Version 3.2.1 - 2019.7.19

☆ Fixed bugs
  1. Fixed an issue where the error occurred when the reverse engineer of mysql server did not have '@' delimiter in the Definer column.

Version 3.2.0 - 2019.6.17

☆ Enhanced Contents
  1. The compound word input option using the term dictionary has been subdivided. The compound word input options can be set in the eXERD > Diagram Editor > Auto Edit item in the Preferences.
    • Can set whether to use compound words.
    • Can choose not to use delimiters when creating compound words for words that do not use delimiters.
    • Can use words that are not registered in the term dictionary as they are when you create a compound word.
    • If you have both a perfect match word and compound word, can use the compound word first.
    • A compound word can be applied to an underscore(_) or a whitespace character( ) that is not registered as a delimiter.
  2. Review item for name has been broken down. Review of the name is affected by the Auto Edit option.
    • Can check whether you have violated the term policy separately for logical and physical names.
    • Can check whether a word that is not registered in the term dictionary is used. Words that are not registered in the term dictionary by the Auto Edit option can pass the model check.
☆ Fixed bugs
  1. Fixed an issue where an error occurred when closing the perspective using "Close All Perspectives" menu while eXERD file was opened.
  2. Fixed an issue where reverse engineering could not get Tibero functions, procedures, and triggers correctly.
  3. Fixed an issue where only underscore(_) were reviewed instead of delimiters specified in preferences.
  4. Fixed an issue where compare/merge for reference objects did not work correctly.
  5. Fixed an issue where the files at the top of the workspace could not be compared.

Version 3.1.0 - 2019.2.18

☆ New Features
  1. Supports Tibero 4, 5 and 6 Versions.
  2. If the structure of the eXERD file is the same, the eXERD file created in the higher version can be opened in the lower version.
☆ Enhanced Contents
  1. Can import the check constraint in XScript.
☆ Fixed bugs
  1. Fixed an issue where an error occurred when running a reverse-engineered script of a defined XScript.
  2. Fixed an issue where the term dictionary was not correctly reflected when the prefix / suffix was entered in Korean when entering a column name.
  3. Fixed an issue where PostgreSQL did not correctly generate the comment DDL syntax for indexes.
  4. The "Too long name", "Use reserved words", and "Duplicate name" reviews for non-activated foreign key indexes have been fixed to work.

Version 3.0.0 - 2019.1.1

☆ eXERD 3.0 Released

New databases and more and more advanced features will be added.

* eXERD 3.0.0 includes all features of 2.x version.

Version 2.5.3 - 2018.11.13

☆ Enhanced Contents
  1. Can add connection properties from MySQL Connection Information.

Version 2.5.2 - 2018.10.26

☆ New Features
  1. Supports MySQL 5.8 Version.
☆ Enhanced Contents
  1. The Excel 2007 (.xlsx) format has been added to the import of the term dictionary and domain. If you use the Excel 2007 format, you can get more than 65,536 rows.
  2. Custom attributes that are only supported on tables can be used in other columns, such as columns and indexes.
  3. Can use a Business Area from XScript.
  4. Can specify an index tablespace for table physical attributes in DB2.
☆ Fixed bugs
  1. Fixed an issue where reverse engineering could not be done if the sql_mode setting of the MySQL server was set to ONLY_FULL_GROUP_BY.
  2. Fixed an issue where compare / merge functionality in some files did not work correctly when using JDK 7, 8 version.
  3. Fixed an issue where the value of the property being edited was not reflected when the property was edited by using the property dialog box in macOS and the OK button was selected to reflect the contents.
  4. The name of the domain has been changed so that it can not be created as an empty string.
  5. Fixed a problem where some printers could not get default printer information.
  6. The default value of sorted index physical attribute sorted by Oracle has been changed to true.
  7. Fixed an issue where DDL syntax for table spaces in tables was not generated during DB2 forward engineering.

Version 2.5.1 - 2018.05.15

☆ New Features
  1. Supports DB2 10 and 11 Versions.
☆ Enhanced Contents
  1. In the Model view, the table is displayed as a sub-element of the diagram.
  2. Can create a logical name based on the physical name when collectively reflecting the contents of the term dictionary.

Version 2.5.0 - 2018.02.28

☆ New Features
  1. Supports PostgreSQL 9.0, 10.2 Version.
☆ Fixed bugs
  1. Fixed an issue where some index columns could not be imported when reverse engineering PostgreSQL 9.6 or later.

Version 2.4.9 - 2018.02.05

☆ New Features
  1. Supports SQL Server 2016 and 2017.
☆ Enhanced Contents
  1. Can use the pop-up menus in the model view to sort the business areas, diagrams, tables, views, functions, and procedures individually.
☆ Fixed bugs
  1. The sort function in the model view also sorts views, functions, and procedures.

Version 2.4.8 - 2017.07.11

☆ Fixed bugs
  1. Now term validation uses term delimiter that is configurable at preference.
  2. Term validator will suggest auto-fix using delimiter that is configurable at preference.
  3. Now a property dialog of a table shows index list properly for DB2.
  4. Compatibility issues about term editor with Eclipse Oxygen was fixed.

Version 2.4.7 - 2016.12.27

☆ Enhanced Contents
  1. The default JRE for standalone version is changed from 1.6 to 1.8.
  2. You can more easily see the color of the table in the thumbnail view.
☆ Fixed bugs
  1. The problem of unable to open a file after installation by plugin on eclipse mars.2 or later version is fixed.
  2. Fixed an issue where an unable to set foreign key constraint when a unique index existed in Oracle's Properties dialog box without unique constraints.
  3. Fixed an issue where an unable to initialize the text box for editing numbers in the Properties dialog.
  4. If the account is not an administrator account, the way of getting full schema in reverse engineering in PostgreSQL is changed from using the ownership right to the account accessed

Version 2.4.6 - 2016.05.09

☆ Fixed bugs
  1. Diagram generation failure after reverse engineering was fixed.

Version 2.4.5 - 2016.05.05

☆ Fixed bugs
  1. Fixed the problem that some diagrams were disappearing in version 2.4.4.
  2. Fixed the problem that eXERD could not open the file that contains duplicated diagram.

Version 2.4.4 - 2016.05.03

☆ New Features
  1. Business Area is introduced. Now you can allocate tables by business area even they are belongs to same scheme.
  2. Diagrams are now sub elements of business areas.
  3. Diagram can be closed without deletion. It can be re-opened through Model View
  4. MySQL 5.7 is supported now.
  5. Ctrl+/ allows line commentation in XScript Editor.
  6. Validation and quix fix are available for the case when column's data type overrides it's domain definition.
  7. Validation element for columns without domain was added.
☆ Fixed bugs
  1. Malfunctions of print previwing for negative area.
  2. Sequece's some attributes in Oracle could not be setted properly.
  3. An eXERD file for some specific version of SQL Server was not opened properly.
  4. Comparing that uses UUID now ignores non-related objects.
  5. Table Report from built-in XScript now can be shown in MS Excel with more good looking.

Version 2.4.3 - 2016.04.04

☆ New Features
  1. Support PostgreSQL Physical Properties.
  2. Expand All and Collapse All has been added in the search result view.
  3. You can search using the default value when search the column.
  4. You can specify a range when you search the schema and diagrams.
  5. Display The count of models in the model view.
  6. Support sequence for oracle.
☆ Fixed Contents
  1. Fixed an error that the file can not be opened in the eXERD plug-in Eclipse of European languages.
  2. You can ignore any errors to perform sql statement in the forward engineering.

Version 2.3.9 - 2015.12.28

☆ Fixed Contents
  1. It is fixed that getting only part of the procedures when reverse engineering from SQL Server.

Version 2.3.8 - 2015.12.17

☆ New Features
  1. Support MySQL JDBC Connector 5.1.38

Version 2.3.7 - 2015.11.04

☆ Fixed Contents
  1. The problem that columns which not using expression can’t be collected during reverse engineering for Oracle.
  2. Importing ERWIN now orders columns using physical order.
  3. Wrong index name of Relation Specification Template was fixed.
  4. Hanging on importing domains with specific condition was removed.
  5. Missing “on update” statement during reverse engineering for MySQL was fixed.
  6. SQL Server 2005 2005 RTM(9.00.1399) are supported now.
  7. Minor bugs are fixed.

Version 2.3.6 - 2015.05.19

☆ Fixed Contents
  1. Table name was not printed properly.
  2. Incorrect length of NVARCHAR2 during reverse engineering for Oracle.
  3. Other minor bugs

Version 2.3.5 - 2014.11.26

☆ New Features
  1. SQL Server 2014 is supported.
☆ Fixed Contents
  1. The problem that the length of VARCHAR2(CHAR) is retrieved as byte value during reverse engineering for Oracle.

Version 2.3.3 - 2014.07.25

☆ Enhanced Contents
  1. What if logical name matches term dictionary already, Doesn't modify logical name when new physical name is entered.
  2. Content assistant of logical name doesn't corrupt intention of users when term dictionary is connected. It suggests possible compositions of logical name that matches to physical name when logical name is empty case only. Otherwise, It will suggest all logical names that matches to current input.
  3. When logical name was automatically entered according to entering physical name, No more failure due to duplication of logical name, What if there is a duplication, It will add a number to end part of logical name.
☆ Fixed Contents
  1. WITH statement is not generated anymore when creating a index with no "WITH" option when a file group was setted in SQL Server.

Version 2.3.2 - 2014.05.28

☆ Fixed Contents
  1. The problem that at the time of generating Oracle DDL, ssemicolon is written at the last of a index sentence
  2. The problem as below: If there is no prime key at the time of Oracle forward engineering, DDL of a blank value is operated then the message shows as "SQL is not improper."

Version 2.3.2 - 2014.4.7

☆ New Features
  1. Support Trigger
    - Select model(table,view,database) supporting each DBMS in Model View and add it on the tab, opening the window for properties.
  2. Support Procedure, Function
    - Add it on right-click menu, selecting schema view in Model View.
  3. Added Export Model
    - It exports a model of eXERD to SQLite Database.
☆ Improved Contents
  1. Content assist is possible for table logical name.
☆ Fixed Contents
  1. Minor errors have been fixed.

Version 2.3.1 - 2013.12.19

☆ New Features
  1. Support Oracle 12c
  2. Support View
    - After selecting schema or view on Model View, you could add view on the right-click menu.
☆ Improved Contents
  1. It's advanced to check all functions on the menu.
  2. Style option is added to print setting.
☆ Fixed Contents
  1. After importing ERwin, the problem of the table location has been fixed.
  2. The rest of minor errors have been fixed.

Version 2.3.0 - 2013.09.27

☆ New Features
  1. Support Mysql 5.6
  2. Defined XScript - "Export to CSV" added.
  3. XScript is accessible to Data Dictionary.
☆ Improved Contents
  1. In the diagram table, the logical name has been modified to shows the physical name of the first input to automatically to enter.
  2. Mysql - Empty value have been added to Collation and Character Set.
  3. Data Dictionary of the edit box was fixed.
  4. The default values of the physical name to convert uppercase has been modified to "Disable".
  5. Dialog box of ERwin Import has been improved.
☆ Fixed Contents
  1. In properties of exerd extension file, mysql tabs appearing bug has been fixed.
  2. The Data Dictionary of the ascending and descending has been fixed that sort sequence different problem.
  3. Oracle - Reverse Engineering has been fixed that invalid data length value import.
  4. When edit Oracle connection settings, Port has been fixed that change problem to the default port.
  5. Other minor problem has been fixed.

Version 2.2.0 - 2012.11.30

☆ New Contents
  1. XScript : On this version, XScript Engine, a powerful eXERD script engine, is mounted upon. Based on JavaScript, this engine is also accompanied by the most progressive and supportive editor. (for more details)
  2. While editing a diagram, now you can select plural tables and arrange using the tools from alignment toolbar.
  3. User-defined properties are added to table properties dialog box.
    - User-defined properties are not applied to database, but you utilize by using XScript.
  4. All physical properties of MySQL is supported.
    - MySQL has many unimplemented items in defined specs, so you should have full understanding MySQL Data Definition.
    * Example 1: You can use contexts of CHECK constraints, but they are not applied.
    * Example 2: Contexts of ON UPDATE, ON DELETE of FK is only applied to tables using InnoDB.
☆ Improved Features
  1. You can find indexed columns easily in diagram editor.
  2. Support for Linux has has become more stabilized.
  3. Multi-core CPU is now supported. Using the multi-core CPU, eXERD processes complex tasks such as operation of data dictionary far faster than before.
  4. Data dictionary has been improved
    • In the Data Dictionary editor, logical/physical synonyms are immediately shown, and you can directly enter a comma as a separator. (for more details)
    • In case of connecting data dictionary later, you can batch the term policy easily.(for more details)
    • You can create data dictionary based on logical/physical names in an eXERD file automatically create.(for more details)
  5. You can enter connecting characters of Oracle directly.
    - By entering connecting characters of yourself, you can set necessary properties or connect to the RAC server.
☆ Bug Fixes
  1. When using Barker notation, the problem of erroneous notation has been corrected.
  2. When editing data dictionary on Mac, the problem that the cells are too small has been corrected.
  3. In Windows XP, the problem that some columns are not printed has been corrected.
  4. Has fixed the problem of error in wrong data type import, while importing ERWin 7.3 XML files where a domain has logical types.
  5. Regardless of settings about database character-set of MySQL, the Korean comment is applied correctly.

Version 2.1.2 - 2012.09.05

☆ New Features
  1. You can use Windows Authentication in SQL Server.

Version 2.1.1 - 2012.08.13

☆ New Features
  1. Select tool(Shortcut:1) and panning tool(Shortcut:2) are combined.
    Now, you can pan the screen with clicking mouse wheel in select tool,
    and by clicking mouse wheel, you can jump scroll that point to the middle of the screen.
☆ Fixed Bugs
  1. The problem that some physical properties of FK were not applied to DDL in MySQL and MSSQL has been corrected.
  2. The problem that same named domain could be created has been corrected.

Version 2.1.0 - 2012.07.16

☆ New Features
  1. MySQL is supported.
    - Reverse engineering and forward engineering of MySQL (version 5.1 and 5.5) is now supported.
    - You can select target DBMS while making a new eXERD file or processing reverse engineering.
☆ Fixed Bugs
  1. In Eclipse 3.8, the problem that documents were not opened normally has been corrected.

Version 2.0.6 - 2012.05.17

☆ Fixed Bugs
  1. [SQL Server] While processing forward/reverse engineering, now you can process accounts that has no passwords.
  2. Processing time has reduced while importing an ERwin file.
  3. If importing ERwin is started, the problem that the process could not be canceled has been corrected.
  4. In case of existing items which the logical name is not defined in the data dictionary, during eXERD diagram edit, the problem that some functions were malfunctioned has been corrected.

☆ New Features
  1. XML files for ERwin 7.3.X can be imported.
  2. After setting the column filters of specific tables, you can apply same properties to all same tables of other diagram.

Version 2.0.5 - 2012.05.07

☆ New Features
  1. Now you can make 1:1 relationship.

Version 2.0.4 - 2012.04.18

☆ Fixed Bugs
  1. The problem occurred in comparing working files with database has been corrected.
  2. After finishing cell edit, the problem that error dialog is sometimes displayed has been corrected.
  3. [SQL Server] Identity property of start value and increment value of maximum setting range type has been fixed that limit problem to the range of int data type.
  4. [SQL Server] a clustered attribute do not reflected to the syntax of an index in forward engineering has been fixed.

Version 2.0.0 - 2012.04.16

☆ New Features
  1. IBM DB2 is supported.
    - DB2 UDB Version 9.x support the reverse engineering and the forward engineering.
    - Create a new eXERD file or, if run the reverse engineering, can select the target DBMS.
    cf. Forward / Reverse Engineering is also possible to target the DB2 UDB Version 8.x, but it is not recommended.
  2. SQL Server 2012 is supported.
  3. Now, other eXERD files, the version of the past, compare the eXERD files and DB and, can edit a point of difference.
  4. You can import the ERwin XML export file now.
☆ Improved Features
  1. Can change the naming convention for each project.
☆ Fixed Bugs
  1. [SQL Server] If change the properties of the columns in the properties dialog box, the UI problem of Identity property has been fixed to deactivate.
  2. While zoom in and out, has been fixed that black line or white line is displayed in the background and shadow.
  3. If the user is personalized work environment, has been fixed problem that are not displayed the newly added function until reset the working environment.