DeZign for Databases Changelog

What's new in DeZign for Databases 14.4.1

Apr 26, 2024

Fixed an issue with an infinite loop when parsing views or procedures with references to column names with keywords in it (such as COMMENT).
Fixed an issue with reverse engineering in-lined table-functions for SQL Server and Azure SQL.
Fixed an issue with loading schema names when reverse engineering Snowflake databases.
A batch separator (GO) after a block of comments is added to the generated SQL script for SQL Server databases.
Disabled browse for database button in Snowflake connection dialog because this feauture is not yet available for Snowflake.
When archiving a version, the new version will get a new unique version number instead of X.x.x.
A "check permissions" message will be displayed before importing Snowflake databases.
Fixed an issue with missing description for BigQuery procedures after reverse engineering.
The local import model database is created on-demand instead of a static model installed by the setup program.

New in DeZign for Databases 14.4.0 (Apr 18, 2024)

New in DeZign for Databases 14.3.0 (Apr 9, 2024)

New in DeZign for Databases 14.2.0 (Feb 1, 2024)

New in DeZign for Databases 14.1.0 (Jan 8, 2024)

New in DeZign for Databases 14.0.2 (Dec 13, 2023)

New in DeZign for Databases 14.0.1 (Dec 11, 2023)

New in DeZign for Databases 12.0.0 (May 20, 2020)

New in DeZign for Databases 11.1.0 (Oct 22, 2019)

New in DeZign for Databases 11.0.4 (Jun 26, 2019)

New in DeZign for Databases 11.0.3 (May 22, 2019)

New in DeZign for Databases 11.0.2 (May 21, 2019)

New in DeZign for Databases 11.0.1 (May 8, 2019)

New in DeZign for Databases 11.0.0 (Apr 25, 2019)

Added support for user defined properties. You can define custom properties (user defined properties) and assign them to the different object types such as entities, attributes, views, procedures etc.
Redesigned the Options dialog.
New software activation dialog.
Added support for PostgreSQL 10 and PostgreSQL 11.
Added support for MySQL 6 and MySQL 8.
Added support for Oracle 18c.
Added support for MS SQL Server 2017.
Performance improvements for loading (large) projects, commiting changes to the repository and database/model comparisons.
Added support for reporting about user defined properties.
Field size detecting for database servers with multi-byte charset when is improved.
Support for detecting utf8mb4 charset is added when reverse engineering MySQL databases.
Added user defined properties to generated reports (option).
New selection method added: Select diagram objects by label.
From now on database independent models are also supported in the Standard and Professional edition.
From now on repository access is available in the Expert edition.
Stopped with the Teamwork edition (functionality has been moved to the Expert edition).
New: Find related objects of a relationship easier with the related objects popup menus of a relationship in a diagram.
Fixed an issue with the list of attributes in the Entity dialog. In some cases you was not able to use the keyboard to navigate in the list.
New default background color for new diagrams.
Fixed and issue with "Data type is not supported" exception when reverse engineering InterBase databases.
Fixed an issue with recognizing CLOB columns when reverse engineering an Oracle database.
Database independent models are now also supported in the Standard and the Professional edition.
Added the option to display a tooltip when you hover over an object in the diagram. You can define what will be displayed (for example description) in the Options dialog.
Fixed an issue with the last field in property editor which was not completely visible in some cases.
Generate report dialog is now resizable.
New splash screen.
Fixed an issue with software deactivation.
New licensing system.
Added two Attribute display level options: Show first 10 attributes and Show first 20 attributes.
Improvements to the standard (Linear) auto-layout algorithm.
Fixed an issue with committing changes to the repository when the model contained one or more subcategories.
Added support for links in text areas. You can now link to an external file, a webpage, a specific object in your model or a subdiagram.
Fixed an issue with deactivating the software.
Fixed an issue with invalid change comments message when committing changes to the repository.

New in DeZign for Databases 10.0.2 (Feb 8, 2018)

New in DeZign for Databases 10.0.1 (Oct 11, 2017)

New in DeZign for Databases 10.0.0 (Sep 15, 2017)

Fixed an issue with authentication in Direct mode for Oracle.
Field size detecting for servers with multi-byte charset is improved when reverse engineering Oracle databases.
Fixed a bug with special symbols in the password for Oracle databases.
Connecting to SQLite databases now is based on the SQLite engine version 3.17.0.
Added support for MS SQL Server 2016.
Bug with international characters in an InterBase database path name in is fixed.
Support for IPv6 protocol when reverse engineering SQL Server databases has been improved.
Fixed a bug with detecting TIMESTAMP(1)..TIMESTAMP(5) fields when reverse engineering MySQL databases.
Fixed a bug in connecting to a PostgreSQL databases when using default port.
Fixed a bug with detecting MONEY data type when reverse engineering SQL Server databases.
Fixed a bug with incorrect milliseconds part of timestamp fields when reverse engineering PostgreSQL databases.
Added PostgreSQL 9.5 support.
'Range check error' when connecting to SQL Server 2005 is fixed.
Bug with international characters in a Firebird database path name in is fixed.
Fixed a bug with detecting AutoInc fields when reverse engineering SQLite databases.
Fixed a bug with displaying the correct filter in the Define filter dialog when making a selection using a filter.
Improved performance of displaying the items in the Object Browser while searching.
Added support to search for labels in the Object Browser. Use LABELS:MYLABEL to search for a specific label.
Added a labels field to the Edit entity dialog.
Added 'labels' field to the list of attributes in the Edit entity dialog.
Added 'labels' field to the list of indexes in the Edit entity dialog.
Added 'labels' field to the list of constraints in the Edit entity dialog.
Added 'labels' field to the list of triggers in the Edit entity dialog.
Fixed an issue with a fatal error when generating InterBase and Firebird create scripts when the server's client DLL was not found.
Fixed an issue with a missing schema name when generating Insert, Update or Select statement for an entity.
Added support for labels in reports.
Added labeling support for entities, views, procedures, attributes, indexes, triggers, sequences, domains and constraints.
Added the Manage labels dialog to create and edit labels (Menu: Labels | Manage labels...).
Fixed an issue with merging project properties when committing changes to the repository.
Improved MS Access 2013 support with new definition file.
Fixed an issue with loading the editor font in the SQL editor.
Fixed an issue in many dialogs with disappearing buttons when you pressed the Alt key.
Modified the Firebird 3 SQL statements for adding, dropping and changing comments on tables, columns, views, procedures and generators.
Fixed an issue with saving the form's state when the form was maximized.
Added the option to display labels in the diagram to the entity display options menu.
Fixed an issue with parsing default value constraint names when reverse engineering a database using a SQL file.
Added Update model options dialog with options to automatically label new and/or changed objects and the option to keep your relationships in the model when you don't have them defined in your database.

New in DeZign for Databases 9.2.1 (Mar 3, 2017)

New in DeZign for Databases 9.2.0 (Dec 14, 2016)

New in DeZign for Databases 9.1.5 (Sep 21, 2016)

New in DeZign for Databases 9.1.4 (Sep 6, 2016)

New in DeZign for Databases 9.1.3 (Apr 25, 2016)

New in DeZign for Databases 9.1.2 (Feb 25, 2016)

New in DeZign for Databases 9.1.1 (Jan 14, 2016)

New in DeZign for Databases 9.1.0 (Nov 27, 2015)

New in DeZign for Databases 9.0.0 (Oct 7, 2015)

Added the option to bring a diagram object to the front or send it to the back of other overlapping objects, as part of arranging the objects on the diagram.
Fixed an issue with auto layout function for complex diagrams.
Added the option to exclude the file header when generating the create database script and when generating the alter database script.
Added the option to exclude the remarks when generating the create database script and when generating the alter database script.
Added support for Oracle 12c.
Added support for MicroSoft Azure databases.
Fixed an issue with dropping comments on objects when altering the database.
Changed the order of menu items in the import database menu.
Added support for MS SQL Server 2014.
Removed support for MS SQL Server 7 and MS Access 95.
Added a search box to the Object browser pane. Now quickly search for objects in the Object browser.
Added the option to include multiple diagrams in a report.
Fixed an issue with forward engineering arrays for PostgreSQL databases.
Setting to display schema names in the Object browser was not saved. Fixed.
Modernized look for the Print Preview dialog.
Added the option to define a custom width and height for page size in diagram window.
Fixes an issue with deleting a foreign key attribute that is part of the primary key.
Added the option to select/deselect all attributes in the Show/hide attributes.
List of attributes in Show/hide attributes dialog can be filtered now.
Diagram name entry field and description field did not fit in the dialog. Fixed.
Improved the import of PostgreSQL SQL files. Long COPY statements could cause the import to fail.
When reverse engineering a database by importing SQL files, the statement after the create table statement was sometimes seen as the table's table options. Fixed.
Fixed an issue reverse engineering from Oracle SQL files when the PROMPT command was used in the SQL files.
Added support for Windows 10.
Fixed an issue with changing the case of an entity, view and procedure using the Naming tools dialog.
From now on Oracle script comments are filtered out prior to parsing the SQL file. This results in a faster import for large SQL files.
Fixed an issue with the question and info dialog being displayed behind another dialog.
Fixed an issue with the PostgreSQL 9 definition file. Direct connection to a PostgreSQL 9 database was not available. Fixed.
When altering a non SQL database, the database parameters used in the compare database dialog are now copied to the alter database dialog when no connection parameters are available.
A default file name for the alter script is available now when updating a SQL database.
You are now asked to overwrite an existing alter script before the alter script is generated.
Adjusted the timeout period for slow connections when checking for updates.
Fixed an issue with unnecessary statements for object comments when a table must be recreated in the alter database script.

New in DeZign for Databases 8.1.2 (Apr 3, 2014)

New in DeZign for Databases 8.1.1 (Mar 11, 2014)

New in DeZign for Databases 8.1.0 (Feb 19, 2014)

New in DeZign for Databases 8.0.3 (Feb 5, 2014)

New in DeZign for Databases 8.0.2 (Feb 4, 2014)

New in DeZign for Databases 8.0.1 (Feb 4, 2014)

New in DeZign for Databases 8.0.0 (Jan 9, 2014)

New auto-layout routines for model diagrams. Select from three routines: linear, hierarchical or sugiyama.
New auto-layout preview dialog. Preview the new layout before applying it to the diagram.
New auto-layout grouping routines. Select which grouping you want: group by schema, group by connected objects,...
New auto-layout options such as straighten lines and autosize entities.
New: Teamwork support. Save your model in a central repository.
Layout diagram menu moved from Tools to Diagram menu.
New: Dynamic highlighting of related objects in a diagram. You can highlight children, parents, parents and children, transitive.
Added the option to make a selection of diagram objects based on include filters and exclude filters.
Improved SQL parser. From now on the import continues when an error in the script is found.
Added the option to forward engineer nullability columns as explicitly null (adds NULL to the column definition).
From now on you can choose whether you want to see all objects or only the objects in the active diagram in the Object browser.
Fixed an issue with a wrong order of child-parent columns in multi-column foreign key constraints when reverse engineering MS SQL Server 2005, 2008 and 2012 databases.
Added a schema name combo box to the edit view, edit domain, edit procedure and edit sequence dialog.
Added a schema name combo box to the Edit entity dialog. Schema name entry box can be found next to the entity name under the General tab.
Generated MS SQL Server scripts now have a terminator after each block of comments. This way these comments wille object definition that appears after this comment will
Fixed an issue with missing CACHE/NO CACHE text in the create sequence statement for MS SQL Server 2012 databases when generating the database.
Fixed an issue with renaming a column in the generated alter script for MS SQL Server 2005, 2008 and 2012 databases. In some cases the schema name was missing in the generated rename column statement.
Fixed an issue with recognizing NOCACHE setting for sequences when reverse engineering an Oracle SQL script.
Fixed an issue with ordering index columns for unique indexes when reverse engineering an MS SQL Server database with a direct database connection. Ordering was done based on the column's position in the table.
From now on, data type's identity, seed and increment properties are not disabled anymore when a domain is associated with the attribute.
Improved routine to determine logical order for data generation (Self referencing relationships are treated different).
Removed the select sibling menu from the pop-up menu of an object in the diagram window.
Extended the select menu. Now you can select children, parents, parents and children, transitive.
Added the select and highlight menus to the pop-up menu of the diagram window.
Added the select and highlight menus to the pop-up menu of an object in the diagram window.
Fixed an issue with finding the view name and replacing the view name in the view definition with a variable when reverse engineering a database.
Fixed an issue with finding the function name and replacing the function name in the code with a variable when reverse engineering a database.
Fixed an issue with finding the procedure name and replacing the procedure name in the procedure code with a variable when reverse engineering a database.
The table name in the definition of a trigger was not always replaced with the correct variable when reverse engineering a database. Fixed.
Fixed an issue with replacing the trigger name with a variable in the trigger code when reverse engineering databases.
Fixed an issue with reverse engineering length value for character based data type definitions in Oracle databases when multibyte characters sets are used.
Fixed an issue when comparing MS SQL check constraints defined at column level. The constraint in the database was defined inside the table and the constraint in the model was defined in an alter table statement. Now both are defined in alter table statements.
Fixed an issue with incomplete functions, triggers and procedures when reverse engineering from SQL files for Informix, Sybase and DB2 script files.
Fixed an issue with reverse engineering MS Access 2007 databases. The import failed if the Primary key index was not defined correctly.
Fixed an issue with wrong usage of global prefix when comparing data model and database. Global prefix was applied to data model and database. From now on the global prefix is only applied to the objects in the data model.
Extended the list of MS SQL data type conversion rules.
Added Windows 8 support.
Fixed an issue with merging subcategories.
Fixed an issue with reverse engineering SQLite databases. Check constraints were not imported correctly.
Fixed an issue with reverse engineering table columns for SQLite databases. In some cases the characters "--" were recognized as table columns.
Fixed an issue with Informix database generation. Sequences were not added to the generated SQL script.
Fixed an issue with the Drop script generation. In some cases, a function was dropped with a Drop procedure command instead of a Drop function command.
From now on you can hold down your mouse button and the CTRL key while you drag upwards or downwards or in any direction you want and you will be able to navigate through the complete diagram.
Fixed an issue with an hidden messages list when errors where found during model validation. From now on, the messages list will be shown automatically when errors are found.
From now on each individual difference in the Comparison dialog is highlighted and not only the line that contains the differences.
From now on you can sort the differences in the Comparison results dialog on difference status (left only, right only, changed).
Fixed an issue with forward engineering default values for date fields in PostgreSQL. Default value was quoted twice when the default value was already quoted in the model.
Fixed an issue with the default schema name for new views/procedures/sequences and domains. The default schema name was not assigned to these new objects.
Now you can double click on a views/sequences/procedures folder node in the Object browser to open the object's type edit dialog.

New in DeZign for Databases 7.3.6 (Jun 13, 2013)

New in DeZign for Databases 7.3.5 (Apr 19, 2013)

New in DeZign for Databases 7.3.4 (Feb 22, 2013)

New in DeZign for Databases 7.3.3 (Dec 18, 2012)

New in DeZign for Databases 7.3.2 (Dec 17, 2012)

New in DeZign for Databases 7.3.1 (Nov 15, 2012)

New in DeZign for Databases 7.3.0 (Nov 15, 2012)

New in DeZign for Databases 7.2.1 (Oct 24, 2012)

New in DeZign for Databases 7.2.0 (Jul 9, 2012)

New in DeZign for Databases 7.1.2 (May 25, 2012)

New in DeZign for Databases 7.1.1 (May 15, 2012)

New in DeZign for Databases 7.1.0 (May 15, 2012)

New in DeZign for Databases 7.0.1 (May 15, 2012)

New in DeZign for Databases 7.0.0 (May 15, 2012)

Diagramming Environment:
Added functionality to zoom in and out with the CTRL key in combination with the mouse wheel.
When a relationship is added to a diagram (while importing a database, when updating an existing model, or when manually adding a relationship), it will be positionized in such a way that relationship lines will not overlap each other.
Added a Manage occurrences in diagrams dialog to give you an overview in which diagrams an object is used. You can also add/remove objects to/from multiple diagrams at once in this new dialog. The Manage occurrences in diagrams dialog can be called from the "In diagrams" menu.
Workspace is now about 30% larger.
Added Copy/paste support for relationships. When you select entities to copy/paste, the relationships between the selected entities will be copied and pasted now also.
Added a "Related objects" popup menu for the selected diagram object in the Diagram window. This menu will show you a submenu with all children and parents of the selected object. Clicking on such a menu item will make you jump to the related object in the diagram window.
Fixed an issue with moving a groupbox in the diagram window. When you select a groupbox and entities inside the groupbox, the entities did not move as expected.
New "In diagrams" context menu to quickly jump to the object in another diagram.
Added a pan and zoom window.
Improved auto-layout functionality with better support for avoiding overlapping relationship lines.
Extended the number of supported page sizes.
Added support for hiding attributes for an individual entity. The right-click context menu offers a Show/hide attributes for the selected entity.
Added support for hiding attributes on project level. These are called globally hidden attributes. This is very useful when you want to hide audit columns like modifieddate, createdby etc which are used in multiple entities.
Added the option to display indexes in the diagram (functionality available in the Diagram menu).
When double-clicking on a message in the messagelist, it will now also highlight the object in the diagram as well as the object browser.
From now on you can automatically create (or update) a subdiagram for each schema/owner. Menu: Diagram | Create (or update) subdiagram for each schema.
Modeling:
Added global search and replace functionality.
Added the option to select the properties to search (and replace) for. You can do this in the Search & replace dialog.
Added regular expressions support for searching in your model.
Added an option to search on whole words only.
Search results in the Messages window now highlight the matching text.
When checking your model it will now also check global uniqueness of index names.
Added a Search results dialog for the Search & replace data types function.
Changed the default index sort order to ASC for InterBase and Firebird databases.
Fixed an issue with an "empty" trigger being created when assigning an a sequence to an attribute for PostgreSQL databases.
Fixed an issue with deletion of table options, index options, collation settings and character sets when switching a model to a database independent model.
Fixed an issue with the %triggername% template. It only gave the trigger name, and did not include the schema name.
Extended the list of available templates (e.g. %quotedqualifiedindexname%). See the Help files for a complete list.
Added a "Related objects" popup menu for the selected object in the Object browser. This menu will show you a submenu with all children and parents of the selected object. Clicking on such a menu item will open the Edit dialog for the selected related object.
User Interface:
Extended docking support. Both tool and tabbed document style docking windows are supported now. All docking windows can now be docked to the left, right and bottom docking site.
Added captions to docked tool windows.
You can now create a new entity without leaving the Entity dialog. A button to create a new entity has been added to the dialog.
You can now select, search and step through all entities from within the Entity dialog. A editable combo box (search box) is added to the top of the dialog. You can also use the next and previous button to step through the entities.
Removed the integrity tab in the Relationship dialog. The on update and on delete behaviour comboboxes have been moved to the General tab.
Relationship example in Relationship dialog now uses a fading gradient background for the entity boxes.
Relationship example in Relationship dialog now also displays the verb phrase and the inverse phrase.
A single click in the messages panel now automatically highlights the object in the active diagram.
Replaced menu items to restore individual tool windows with one menu item to restore all tool windows.
Extended docking support with new docking sites. Tool windows can now be floating, docked, and tabbed.
Fixed an issue with focussing while editing attributes in the Edit package dialog.
Options in Import database dialog are now displayed in a standard options list.
Fixed an issue with partial selections of objects in the Generate database dialog. The top node did not correctly show the partial selection status.
Attribute packages are now being displayed in an Attribute package browser tool window (removed from the Object browser).
Options in the Generate database dialog are now displayed in the standard options list.
Changed the diagram menu. You now have separate menus for Entity display options and for Relationship display options.
Added a new tab to the Entity dialog: Preview SQL. The Preview SQL tab displays the SQL script that will be used to create the table for the chosen database.
Code Editor:
Added a new code editor with lots of customization options and improved syntax highlighting.
Database Connectivity:
Added support for MS SQL Server 2012.
Enhanced Oracle connectivity. Added instant client support and RAC support.
Added support for InterBase 2009 and InterBase XE databases.
Added support for reverse engineering SQLite databases with a direct database connection. A new SQLite driver was created.
Reverse Engineering:
You can now make a selection of objects (tables, views, procedures, ...) to import. The selection list can be filtered with user defined filters.
Fixed an issue with reverse engineering PostgreSQL partial expressions.
Fixed an issue with reverse engineering PostgreSQL primary key and foreign key constraints for when the contstraint's table name was used in multiple schemas.
Fixed an issue with importing Sybase SQL files. The importer did not find the terminator (GO).
Fixed an issue with importing SQL files. When an entity was defined without schema name, but the relationships, triggers and indexes did make use of a schema name, it did not import the relationship/trigger/index correctly.
Improved support for importing unicode text for MySQL, Oracle and MS SQL Server database.
Improved support for importing CREATE TYPE statements when importing a SQL file.
Added support for importing PostgreSQL ENUM types.
Fixed an issue with importing clustered or non-clustered primary keys when importing a MS SQL Server SQL file.
Improved support for importing SQL files with use of temporarily redefined delimiters.
Fixed an issue with importing dBase data types with precision values.
Forward Engineering & Altering Databases:
You can now select the objects you want to compare when altering a database (or updating a model). You can compare all objects, compare selected objects, or compare objects which belong to selected schemas only.
Fixed an issue with changed sequences not being recreated when altering the database.
Added the option to define custom comparison rules which you can use when comparing your data model and your database. With custom comparison rules you can control what will be seen as a difference. You can for example define a comparison rule that says that data type INT is identical to INTEGER.
Fixed an issue with missing comments in the generated alter script when it was necessary to re-create a complete table.
Added support for creating PostgreSQL ENUM types.
Reporting:
Added conditional generation support to the reporting engine. You can enter your conditional generation directives in the Report dialog.
Added the option to ignore comments in code when generating reports.
Added the option to add the To do items to the generated report.
Fixed an issue with a missing link to the generated image of a diagram in the report when the name of the diagram contained special characters like \ /:*?|.
Miscellaneous:
New sample diagrams added to the samples folder.
New standard diagram when you run the application for the first time.
Added a warning when the software activation fails due to a firewall setting.
Added a warning to use the update model functionality when you try to import a database into an existing data model.
Removed the "naming tool". Naming tool functionality is now available in the Search & replace function.
Removed the option to create a subdiagram for each schema when importing a database. This is now done automatically.

New in DeZign for Databases 6.3.2 (May 19, 2011)

New in DeZign for Databases 6.3.1 (May 19, 2011)

Fixed a problem with importing SQL files when quotes were used inside
comments.
When reverse engineering triggers, sometimes the table name in the trigger
code was wrongly replaced by the table name variable.
Fixed an issue when importing SQL files with missing CONSTRAINT keyword in
foreign key constraint definitions. When the CONSTRAINT keyword could not
be found, the constraint was not imported.
Fixed an issue with reverse engineering relationships with duplicate
names.
When reverse engineering a MySQL database it will now correctly determine
if an index is of type FREETEXT.
In the Import database dialog the default setting for importing alternate
key indexes has been changed. The new default is not ignore indexes on
alternate keys.
Forward engineering. Tables are now generated in logical order (if a
logical order can be determined).
Fixed an issue with importing PostgreSQL 9 triggers.
Added a version check when connecting to a PostgreSQL database. This to be
sure the correct driver will be used.
When editing relationships and %relname% is used in FK constraint name,
it did not immediatly change the FK constraint name when the relationship
name was edited.
Fixed a problem with importing comments when importing a MS SQL Server
script.
When generating a database, and a data type had no length specified
(length is optional), it generated () behind the data type. eg VARCHAR()
where it should be VARCHAR.
The conditional generation options are now also applied to table options.
Fixed a problem with importing MS SQL Server foreign key constraints
when the parent column was part of a unique constraint and a primary key
constraint.
Fixed a problem when the Compare to database and update database function
was used while connecting to an Oracle database. If a binary type datatype
was changed to another datatype, the "ALTER Table MODIFY Column" command
was not valid (Oracle error #22859). In this case it will now create a
temporary table using the new entity structure, copy the current data
from the original table to the temporary table, drop the original table
and then rename the temporary table to the original table name.
Fixed a problem when the Compare to database and update database function
was used while connecting to an Oracle database. When generating the alter
script for renaming an Oracle table, the schema name may not be used in
the target.
Fixed an issue with changing the scale on the Print preview dialog.
Added support for MS Access 2010.
Type group of the MS SQL Server SQL_Variant data type was change from Exact
Numeric to String.
When comparing databases, and the "Ignore * constraint names" option was
used, then the order in which constraints were displayed was not correct.

New in DeZign for Databases 6.3.0 (May 19, 2011)

New in DeZign for Databases 6.2.1 (May 19, 2011)

New in DeZign for Databases 6.2 (May 19, 2011)

Renamed columns were not always found when comparing model to database.
This could result in a incorrect alter script. Fixed.
The default schema/owner name in project options was not used when
creating a new entity. Fixed.
Error when opening a project with Sub Categories and relationships with a
routing different than auto-routing. Fixed.
Schema name not editable for MS SQL Server 2000 models. Fixed.
Fixed an issue with attribute defaults. The square brackets were ignored
and caused function names to become quoted. Fixed.
Fixed an issue with missing foreign key constraints in the generated
SQLite 3 SQL.
For PostgreSQL, there was a problem when sequences was applied to an
attribute. It will now use nextval() in the default when you apply a
sequence to an attribute.
When creating new sequences, the cache code was always blank by default.
It will now use the first entry from seqcachecodes variable specified in
the in the database definition file.
Added support to map schemas when comparing your data model to an existing
database. You can map schema in the compare options dialog.
Domains were not displayed in the Object browser when the target DBMS did
not support domains. Fixed.
Reporting: Sequence descriptions were not added to the generated report.
Fixed.
Reporting: The lists of selectable properties for each object are now
filtered based on what's supported for the target DBMS.
Reporting: Object details did not appear directly after the "Details"
heading but on a new page in MS Word and PDF reports. Fixed.
When importing a new database a new subdiagram was created when no schemas
were found. Fixed.
File does not exist error when converting a V2 .dez file. Fixed.
No Alter statement was generated when the CLUSTERING of a Primary key
constraint changed. Fixed.
Added the option for case insensitive comparison of model and database.
Added the option to ignore empty lines when comparing model and database.
Fixed an issue with importing CREATE TYPE statements for PostgreSQL when
reverse engineering from SQL file.
Reporting: Fixed an issue with missing table borders for PDF reports.
Reporting: Improved quality of image of diagram in PDF reports.
When connecting to Microsoft SQL Server, it will now ensure that the
specified version is the same as the actual database.
Eg. when MS SQLServer 2005 is specified, then it will only connect to a
MS SQL Server 2005 database.

New in DeZign for Databases 6.1.3 (May 19, 2011)

New in DeZign for Databases 6.1.2 (May 19, 2011)

New in DeZign for Databases 6.1.1 (May 19, 2011)

Subcategories were not displayed in the list of objects under the
add/remove objects tab in the Diagram properties dialog. Fixed.
"on update CURRENT_TIMESTAMP" for a TIMESTAMP column was not imported for
MySQL databases. Fixed.
Attribute/column options for MySQL (such as "on update CURRENT_TIMESTAMP")
can now be specified in the attribute's property editor in the Entity
dialog.
Added support for generating attribute/column options for MySQL databases.
Importing MySQL databases. Defaults defined as an empty string ('') are
not imported. Fixed.
When importing a database with column default containing a string with
only spaces the default value was emptied. Fixed.
Fixed several formatting issues for imported database object comments.
Default values will not be unquoted automatically when the text was found
in the file with the list of reserved words.
Generated SQL scripts were saved in UNICODE (introduced in v6.1.0). Files
are now saved as normal text files again.
When importing MySQL databases, table comments could include storage
settings when table type is INNODB. Fixed.
Reintroduced the "-generate" command line option.
Import of MySQL SQL files. ON UPDATE CURRENT_TIMESTAMP attribute option
now imported.
Import of SQL files. Fixed several issues when removing comments in
SQL code.
Import of SQL files. Foreign key constraint could not be imported when
the table definition of the parent table appeared later in the file.
Fixed.
Report generation. Column names for default value constraints were
missing in the list of constraints. Fixed.
MySQL database generation. INTEGER(10) was automatically generated as
INTEGER. Fixed.
Fixed an issue with changed sequences when updating your data model after
comparing it to a database or SQL file.
MS SQL Server database generation. XML(CONTENT table.column) was exported
as XML(CONTENT .). Fixed.
Comments in SQL code option in the Compare options dialog was not saved
and not used. Fixed.
Added a default filter (*.sql) to the Open file dialog in the Compare
options dialog.
The SQL file you selected in the Compare options dialog in a previous
compare session is now remembered.
You can now start the Smart Relationship Finder for existing projects.
Tools | Smart relationship finder...
Extended the number of available paper types for the diagram window in
the Page settings dialog.
Fixed a printing bug when selecting a paper type in the printer dialog
that was not in the list of available design time paper types. From now
on, you can select all paper types that are supported by the selected
printer.
Database alter scripts. Fixed an issue with a missing drop and create
statement for foreign key constraints when the parent table changed.

New in DeZign for Databases 6.1.0 (May 19, 2011)

Improved Smart Relationship Finder. Smart Relationship Finder now also
finds identifying relationships.
Improved Smart Relationship Finder. New relationships found by the Smart
Relationship Finder will now get names based on the project's name
templates.
When printing a model in landscape, it always printed as portrait. Fixed.
When printing a model, and Landscape was used with 'fit to print', then
the result was not correct. Fixed.
When using the report generator, it did not show the default value of an
attribute.
When using the report generator and selecting "Only objects of active
diagram", then the ER diagram in the HTML result is non clickable. Fixed.
Code editor cannot be minimized anymore.
Code editor now has horizontal and vertical scrollbars.
When using a single monitor after using multiple monitors, it looked like
the application froze when a dialog was opened. Fixed.
Fixed a memory leak when using the undo functionality.
When converting a database to a Firebird database, all VARCHAR columns
where converted to VARCHAR(40). Fixed.
Fixed an issue with default values of domains. Default value was added to
the column definition when generating the database.
When environment does not use shadows, and Export as image is used, then
shadows never appeared in the image. Fixed.
When using the Query builder, it did not use schema names. Fixed.
Tabsize in the code editors changed from 8 to 4.
Added support for defining, forward engineering and reverse engineering
clustered or nonclustered primary key constraints for MS SQL Server.
When using the undo function, it could result in duplicate id's for
objects. Fixed.
Added horizontal scrollbars to the listboxes with table names in the
Select tables to import dialog.
Fixed an issue with missing help text in the Schema manager dialog.
Importing SQL files. Fixed an issue with multiline and inline comments.
Importing SQL files. Added support for the primary key constraint's
clustered property.
Importing SQL files. Fixed an issue with replacing the name of a view,
procedure or trigger. When a schema name was found in the code it was not
replaced correctly.
Importing SQL files. Quoted strings in SQL code of views, procedures and
triggers are now correctly dequoted when needed.
Database/model compare. Compare options now displayed in a tree.
Database/model compare. Added the option to ignore check constraints.
Database/model compare. Added the option to ignore default values.
Database/model compare. Added the option to ignore triggers.
Database/model compare. Added the option to ignore non key indexes.
Database/model compare. Added the option ignore comments in SQL for views,
procedures and triggers.
Database/model compare. Added the option auto-format the SQL code for
views when comparing a database to a model.
Altering MS Access database fails when the table was used by another
database object. Removing and recreating all foreign key constraints
fixes this.
When comparing a MySQL data model to a database, the length value for
integer data types is ignored when the length is the database's default
length. Implemented for INTEGER, SMALLINT and TINYINT data types.
Improved comparison of check constraints. We get better comparison results
when sorting column and table check constraints on the name of the
constraint.
Added case insensitive comparison of MS SQL Server data types with length
set to "MAX".
Fixed a problem for comparing a data model to a database and then updating
it. Problem could occur when target DBMS does not support domains and the
model contains domains. Problem only occurs when data type display level
was set to show domains in the diagram.
When importing a database, the name of an object will be replaced with a
variable/template in the code of a view, procedure or trigger. Now, only
the first occurrence of the object name will be replaced.
When importing a PostgreSQL 8.3 database, some procedures were imported
twice. Fixed.
View code is now automatically formatted when importing MySQL databases.
View code is now automatically formatted when importing PostgreSQL
Importing views, procedures and triggers from MS SQL Server removed
leading Tabs. Fixed.
For MS SQL Server 2005 and 2008 it only imported schema names for domains
if the domain was in schema 'dbo'. Fixed.
Generate database and alter database options in the Generate database
dialog now displayed in a tree.
Fixed an Out of memory issue when generating/altering very large
databases.
Performance improvements when generating/altering databases.
Generate database/alter database. Added the option to ignore check
constraints.
Generate database/alter database. Added the option to ignore default
values.
Generate database/alter database. Added the option to ignore triggers.
Generate database/alter database. Added the option to ignore non key
indexes.
Fixed an issue with the generation of SQLite primary key autoincrement
columns.
Help function was not working on the Alter database dialog. Fixed.
Quotes were removed from index expressions when generating a database.
Fixed.
Commands to change an existing foreign key definition were missing when
the old and new table had no other differences. Fixed.
When generating create/drop scripts it did not use schema names when using
domains. Fixed.
When generating database scripts and triggers, procedures or functions
have no code, then the empty triggers, procedures or functions will be
ignored.
No SQL was generated for Informix, Pervasive, SQLite and Sybase
databases. Fixed.
When there was an error while adding an object to an MS Access database,
the log still mentioned the object was added. Fixed.
Name of foreign key constraint in the log now contains the name of its
child entity.
Primary key constraint options were not generated for MS SQL Server
databases. Fixed.

New in DeZign for Databases 6.0.0 (May 19, 2011)

When importing a database that supports schemas, you can choose to
automatically create a subdiagram for each schema and add imported schema
objects to the approriate subdiagram.
Added the option to ignore indexes on keys when reverse engineering a
database. You can set this option in the Import database dialog.
Import attribute options for MS SQL Server.
Import index options for MS SQL Server.
Added MS SQL Server 2008 support.
System sequences are no longer imported for Oracle databases.
For some data types a wrong value for length of non-numeric data types was
imported. Fixed.
DB2 system schemas are not imported anymore.
Short object names in code of views, procedures and triggers wrongly
replaced by variables (e.g. %viewname%). Fixed.
Added support for reverse engineering unicode SQL scripts.
Added schema/owner support to the SQL parser that is used when reverse
engineering SQL scripts.
Added support for PostgreSQL 8.3.
New faster and more reliable driver used for connection to
PostgreSQL databases. DLL in bin folder are not needed anymore.
PostgreSQL: Text "::regclass" in default values and check constraints
no longer imported for PostgreSQL.
Added functionality to import attribute options.
Added functionality to import index options.
Foreign key information in table description when using INNODB will now be
removed when importing a MySQL database.
MySQL functions no longer imported as procedures. Function will have the
CREATE FUNCTION header.
InterBase+Firebase: Combined trigger events like "BEFORE INSERT OR UPDATE"
or "AFTER INSERT OR DELETE" now imported when reverse engineering
InterBase or Firebird databases.
Redesigned Import database dialog.
Selection of objects to generate now stored.
When importing SQL files, domains with names starting with a "N" were not
imported correctly. Fixed.
Expression for computed fields was not imported correctly when reverse
engineering a SQL file.
Importing SQL files. Missing schema/owner name when a table name is
similar to the schema name. Fixed.
Descriptions/comments not found when importing MS SQL Server SQL file.
Fixed.
Importing SQL files. Terminator (GO) at the end of the SQL code for MS
SQL Server triggers and procedures was not always deleted from the code.
Fixed.
Importing SQL files. MS SQL Server triggers and procedures created with
procedure "dbo.sp_executesql" were not found. Fixed.
Importing SQL files. Import fails when script contains definitions for
indexes on views. Fixed.
Importing SQL files. Added support for importing collation settings.
Importing SQL files. Default values with brackets were not imported.
Fixed.
Importing SQL files. Fixed an issue importing references to domains when
domain names included schema name and object name.
Importing SQL files. Fixed an issue with importing XML types.
Importing SQL files. Added support for importing domains created with the
CREATE TYPE command.
Importing SQL files. Removed superfluous messages about missing check
constraint clauses from the log file.
Importing SQL files. Constraint name for default not found in column
definition. Fixed.
Importing SQL files. Removed superfluous brackets from check constraints
in MS SQL Server SQL files.
Forward Engineering and Altering Databases
New. Generate an alter/update database script for differences between
your data model and a live database (or SQL script).
Added the option to ignore indexes on primary keys, foreign keys and/or
alternate keys when generating and altering databases.
Added conditional generation functionality. This lets you generate
selected parts of your data model. You can define the generation
directives that must be used for schema generation. You can use
generation directives in code of database objects.
Redesigned alter script generator. The new alter script generator fixes
some object dependencies issues and generates smaller and more reliable
alter scripts.
New generate database and alter database options. New options enable you
to ignore indexes on keys, ignore constraint names (for primary keys,
foreign keys etc), ignore descriptions, character sets, collation
settings, etc. when generating create or alter scripts.
When generating or altering a database, default values for string and date
data types were automatically quoted when the default value did not
contain a reserved word. DeZign for Databases now does not quote the
default when it contains a function like for example TO_DATE.
Fixed a problem with a wrong drop order of tables in the generated drop
script. This could occur when not all tables were selected in the Generate
database dialog.
Selection of objects to generate has been enhanced. You can now select
individual constraints, indexes, views, procedures, domains and sequences.
When generating a MS Access 2007 database, it created a *.accdb file but
used the JET engine. It will now use the ACE engine.
MS Access 2007 password was ignored. Fixed.
Comparing Data Models/Databases
New. Compare your data model to a live database or a SQL script, view and
select the differences you want to update in the database. Generate an
alter/update database script for the selected differences.
Improved routine to automatically detect and map renamed database objects
such as entities, attributes etc. is used when comparing data model and
database.
Added compare data model versions functionality for dBase, Paradox, DBISAM
and FoxPro projects.
Added compare and update model from database functionality for dBase,
Paradox, DBISAM and FoxPro projects.
Added the option to sort on object type in the comparison results dialog.
New comparison results summary dialog. This dialog will be displayed
after comparing a model with a database.
Added the option to ignore indexes on primary keys, foreign keys and/or
alternate keys when comparing models/databases.
Readability of the differences between objects in the comparison results
dialog has been improved.
New. When no relationships are defined in your database and you compare
this database to your model, you are asked whether you want to maintain
the relationships in your data model.
New compare options. Define what you want to see as a difference when
comparing data models and databases. New compare options enable you to
ignore indexes on keys, ignore constraint names (for primary keys, foreign
keys etc), ignore descriptions, character sets, collation settings, etc.
Improved readability for HTML differences reports. Added linebreaks to
long lines.
Collaboration
Added compare and merge projects wizard (File | Compare and merge
projects).
Modeling
New Note property for all database objects. Note can be used to describe
the object. The note contents will not be changed when you synchronize
your data model with the database.
New Update indexes on keys dialog. You can now add, delete or update
indexes on keys. You can do this individually for primary key indexes,
foreign key indexes or alternate key indexes. For new key indexes you can
define a name template.
Added support for database-independent data models. When you work with
database-independent data models, you select a target DBMS when
generating, altering or comparing your data model.
Diagramming Environment
Entities, text areas and group boxes now all have a gradient. This
gradiency will be turned on by default. You can define the gradient setting
for each subdiagram in the Display preferences dialog.
Flexible line routing. Added two new line routing styles: C-style and
U-style line routing.
New default color for new diagrams.
The page divider does not honor the "Landscape" page orientation in the
diagram window. Fixed.
You can now define the page settings for the diagram window in the Page
setting dialog (File | Page settings).
User Interface
New undo functionality lets you go back. Undo entity changes, diagram
changes, object renaming and more.
Added the option to display schema/owner names in the Object Browser.
You can change this setting in the Options dialog.
Added the option to insert an attribute in the Entity dialog.
Generate database and modify database setting have been removed from the
Project options dialog. These settings are now available in the Generate
database dialog and the Alter database dialog.
New Progress dialog.
Begin and end database scripts have been removed from the Project options
dialog. You can now edit these scripts in the Begin/end database scripts
dialog (Dictionary | Begin/end database scripts).
Fixed an issue with opening the Entity dialog in the indexes, triggers
or constraints tab when no indexes, triggers or constraints were defined.
Reporting
Tables in PDF reports were align to the right border without a margin.
Fixed.
Redesigned Generate reports dialog. New options allow you to select the
fonts, colors and elements to include.
You can now save your report settings to a reusable template.
New title page for MS Word and PDF reports. You can define the contents of
title page in the Report dialog.
Improved handling of long lines and long words for MS Word and PDF
reports.
Performance improvements for generating reports of large models.
Fixed an out of memory issue when generating large PDF reports.
Improved quality of included image of diagram in MS Word and PDF reports.
To avoid that images of diagrams become too large, they are automatically
resized to a proper size now.
Model Validation
Check model before generating the database option added. This option is
available in the Generate database dialog.
Performance improvements for validating data models.
Removed the question whether you want to give nameless constraints a name
when generating and altering your database.
Validation error when a table with the same name appeared in more than one
schema. Fixed.
Constraint names are now also checked for uniqueness when validating your
model.
Miscellaneous
Performance improvements for loading projects. Up to 4 times faster.
New data type conversion rules editor. You can open this editor through the
menu: Tools | Resources.
The file format of the .dez file has changed to accommodate new features.
When adding a table constraint in the Entity dialog the name template for
table constraints was not assigned. Fixed.
Added support for foreign key constraint options support to postgreSQL 8
and 8.3.
Added support for constraint options for unique constraints in Oracle 10
databases.
Improved the description of Default and Not Null constraint values in
reports.
Added a vertical scrollbars to the table options fields and the primary
key constraint options field in the entity dialog.
You will now see a message when the alter database operation failed.
Fixed problem w.r.t. Windows Data Excecution Prevention (DEP).
Template for Not null constraint names changed to 'NN_%table%_%column%'
Discontinued Functionality
Removed ElevateDB support.
Removed NexusDB V2 support.

New in DeZign for Databases 4.2.0 (May 7, 2007)

Grid-based Editing: New grid-based editors for attributes, indexes, table constraints, domains, sequences, procedures and views. The grid view provides a convenient means for viewing and editing database object properties. With its spreadsheet-like interface, the grid view allows users to easily manipulate database object properties. You can move in the grid by using the TAB-key, Enter-key and keyboard arrows. At the bottom of such a grid a property editor is shown which will display the property values for the selected object.
IDEF1X Modeling Notation Support: In addition to Crow's Feet, the industry standard design notation IDEF1X is now supported. Each subdiagram can use its own notation: Relational/Crow's Feet or IDEF1X.
Alter Database Functionality: Generate Alter database SQL scripts based on a comparison between two versions (supported for Oracle, InterBase, MySQL, Firebird and MS SQL Server). Alter a MS Access database directly based on a comparison between two versions.
Compare Versions and Extensive Version Management:
Automatic version creation. When generating or altering a database, a version is archived.
New Manage versions dialog with functionality to add, edit, delete and compare data model versions.
Compare two versions and examine the differences in a differences browser.
Export an overview of the differences between two versions to a HTML file.
Regenerate the database for an archived version.
Integrated Reverse Engineering Support: DeZign for Databases V4 now allows you to reverse engineer complete databases with a direct native connection. A direct connection to import databases directly is available for Oracle, MySQL, InterBase, Firebird, MS SQL Server, MS Access, Paradox, dBase, FoxPro, DBISAM, Clipper and NexusDB. You can also reverse engineer existing databases through SQL scripts with the improved SQL script analyzer. You don't need the separate ImportER products for reverse engineering tasks anymore.
Reusable Attributes (Packages): Attribute packages are reusable user-defined attributes that promote consistent attribute definitions. You construct attribute packages as you would entities, specifying a name, attributes with datatype properties, default values and validation rules. Afterwards, you can reuse these attribute packages in your data model by applying them to entities.
Enhanced Diagramming Tools:
Pan around a diagram with the Hand tool (like in Adobe Reader).
Smooth direct scrolling when using the scrollbar.
Better mouse-wheel support. The diagram doesn't scroll anymore when the diagram does not have the focus. The steps taken are smaller which results in much smoother scrolling.
Move selected objects using the keyboard arrows.
Group entities or other diagram objects by using the groupbox object.
Add entities to a subdiagram by dragging them from the Object Browser and drop them on the diagram.
Configurable HTML, PDF and MS Word Reports: DeZign for Databases V4 now allows users to configure which elements to include or to exclude when generating data model reports. Instead of generating standard reports, users now have a great deal of control over the content and structure of their reports.
Target Database Related Enhancements
Newly supported: Oracle 10g, MySQL 5, NexusDB 2, Firebird 2, MS SQL Server 2005, PostgreSQL 8 and MS Access 2003.
Enhancements available for: Oracle 7,8,9, MS Access 95,97,2000, PostgreSQL 7, Informix 9, DBISAM 3,4, NexusDB 1, MySQL 3,4, InterBase 5,6,7, Firebird 1.5, Paradox, Clipper, FoxPro, MaxDB, MS SQL Server 6.5,7,2000, DB2 Universal DB 7,8, Sybase 11,12, Pervasive 8,9 and dBase.
Oracle 10g Support
Reverse engineer Oracle 10g databases with a direct connection or through SQL scripts.
Generate Oracle 10g databases.
Alter Oracle 10g databases. Generate intelligent alteration code for Oracle 10g databases by comparing two versions of your data model.
Compare Oracle 10g data models.
Enhanced Oracle 7,8,9 Support
In addition to forward engineering (generating) Oracle 7,8 and 9 databases, DeZign for Databases now also offers:
Reverse engineer Oracle 7,8,9 databases with a direct connection or through SQL scripts.
Alter Oracle 7,8,9 databases. Generate intelligent alteration code for Oracle 7,8,9 databases by comparing two versions of your data model.
Compare Oracle 7,8,9 data models.
Support for Not null constraint names.
MySQL 5 Support
Reverse engineer MySQL 5 databases with a direct connection or through SQL scripts.
Generate MySQL 5 databases including triggers, procedures and views.
Alter MySQL 5 databases. Generate intelligent alteration code for MySQL 5 databases by comparing two versions of your data model.
Compare MySQL 5 data models.
Enhanced MySQL 3,4 Support
In addition to forward engineering (generating) MySQL 3,4 databases, DeZign for Databases now also offers:
Reverse engineer MySQL 3,4 databases with a direct connection or through SQL scripts.
Alter MySQL 3,4 databases. Generate intelligent alteration code for MySQL 3,4 databases by comparing two versions of your data model.
Compare MySQL 3,4 data models.
PostgreSQL 8 Support
Reverse engineer PostgreSQL 8 databases through SQL scripts.
Generate PostgreSQL 8 databases.
Compare PostgreSQL 8 data models.
Enhanced PostgreSQL 7 Support
In addition to forward engineering (generating) PostgreSQL 7 databases, DeZign for Databases now also offers:
Reverse engineer PostgreSQL 7 databases through SQL scripts.
Compare PostgreSQL 7 data models.
Support for Not null constraint names.
Firebird 2 Support
Reverse engineer Firebird 2 databases with a direct connection or through SQL scripts.
Generate Firebird 2 databases.
Alter Firebird 2 databases. Generate intelligent alteration code for Firebird 2 databases by comparing two versions of your data model.
Compare Firebird 2 data models.
Enhanced Firebird 1.5 Support
In addition to forward engineering (generating) Firebird 1.5 databases, DeZign for Databases now also offers:
Reverse engineer Firebird 1.5 databases with a direct connection or through SQL scripts.
Alter Firebird 1.5 databases. Generate intelligent alteration code for Firebird 1.5 databases by comparing two versions of your data model.
Compare Firebird 1.5 data models.
Character sets, blob subtypes and segment sizes supported.
Collations support.
RECREATE TABLE recognized by the SQL parser.
Enhanced InterBase 5,6,7 Support
In addition to forward engineering (generating) InterBase 5,6,7 databases, DeZign for Databases now also offers:
Reverse engineer InterBase 5,6,7 databases with a direct connection or through SQL scripts.
Alter InterBase 5,6,7 databases. Generate intelligent alteration code for InterBase 5,6,7 databases by comparing two versions of your data model.
Compare InterBase 5,6,7 data models.
Character sets, blob subtypes and segment sizes supported.
Collations support.
MS SQL Server 2005 Support
Reverse engineer MS SQL Server 2005 databases with a direct connection or through SQL scripts.
Generate MS SQL Server 2005 databases.
Alter MS SQL Server 2005 databases. Generate intelligent alteration code for MS SQL Server 2005 databases by comparing two versions of your data model.
Compare MS SQL Server 2005 data models.
Enhanced MS SQL Server 6.5,7,2000 Support
In addition to forward engineering (generating) MS SQL Server 6.5,7,2000 databases, DeZign for Databases now also offers:
Reverse engineer MS SQL Server 6.5,7,2000 databases with a direct connection or through SQL scripts.
Alter MS SQL Server 6.5,7,2000 databases. Generate intelligent alteration code for MS SQL Server 6.5,7,2000 databases by comparing two versions of your data model.
Compare MS SQL Server 6.5,7,2000 data models.
Support for Not null constraint names.
Support for Default constraint names.
MS Access 2003 Support
Reverse engineer MS Access 2003 databases with an ADO connection.
Generate MS Access 2003 databases.
Alter MS Access 2003 databases.
Compare MS Access 2003 data models.
Enhanced MS Access 95,97,2000 Support
In addition to forward engineering (generating) MS Access 95,97,2000 databases, DeZign for Databases now also offers:
Reverse engineer MS Access 95,97,2000 databases with an ADO connection.
Alter MS Access 95,97,2000 databases by comparing two versions of your data model.
Compare MS Access 95,97,2000 data models.
Enhanced DB2 Universal DB 7,8 Support
In addition to forward engineering (generating) DB2 Universal DB 7,8 databases, DeZign for Databases now also offers:
Reverse engineer DB2 Universal DB 7,8 databases through SQL scripts.
Compare DB2 Universal DB 7,8 data models.
Support for Not null constraint names.
Support for Default constraint names.
Enhanced Sybase 11,12 Support
In addition to forward engineering (generating) Sybase 11,12 databases, DeZign for Databases now also offers:
Reverse engineer Sybase 11,12 databases through SQL scripts.
Compare Sybase 11,12 data models.
Support for Not null constraint names.
Support for Default constraint names.
Enhanced Pervasive 8,9 Support
In addition to forward engineering (generating) Pervasive 8,9 databases, DeZign for Databases now also offers:
Reverse engineer Pervasive 8,9 databases through SQL scripts.
Compare Pervasive 8,9 data models.
Enhanced Informix 9 Support
In addition to forward engineering (generating) Informix 9 databases, DeZign for Databases now also offers:
Reverse engineer Informix 9 databases through SQL scripts.
Compare Informix 9 data models.
Enhanced MaxDB Support
In addition to forward engineering (generating) MaxDB databases, DeZign for Databases now also offers:
Reverse engineer MaxDB databases through SQL scripts.
Compare MaxDB data models.
Enhanced DBISAM 3,4 Support
In addition to forward engineering (generating) DBISAM 3,4 databases, DeZign for Databases now also offers:
Reverse engineer DBISAM 3,4 databases with a direct connection.
Enhanced dBase Support
In addition to forward engineering (generating) dBase databases, DeZign for Databases now also offers:
Reverse engineer dBase databases with a direct connection.
A new and more reliable database connectivity component is used to connect to dBase tables. The BDE is not used anymore to connect to dBase tables.
Enhanced Clipper Support
In addition to forward engineering (generating) Clipper databases, DeZign for Databases now also offers:
Reverse engineer Clipper databases with a direct connection.
A new and more reliable database connectivity component is used to connect to Clipper tables.
Enhanced FoxPro Support
In addition to forward engineering (generating) FoxPro databases, DeZign for Databases now also offers:
Reverse engineer FoxPro databases with a direct connection.
A new and more reliable database connectivity component is used to connect to FoxPro tables.
Enhanced Paradox Support
In addition to forward engineering (generating) Paradox databases, DeZign for Databases now also offers:
Reverse engineer Paradox databases with a direct connection.
NexusDB 2 Support
Reverse engineer NexusDB 2 databases with a direct connection.
Generate NexusDB 2 databases including triggers, procedures and views.
Enhanced NexusDB 1 Support
In addition to forward engineering (generating) NexusDB 1 databases, DeZign for Databases now also offers:
Reverse engineer NexusDB 1 databases with a direct connection.