May 8th, 2012General:
· Automatic save on exit failed sometimes, this is now fixed.
· SQL Reserved Word warning sometimes appeared twice in a row, this is now fixed.
General GUI:
· Can save a design using Ctrl+S in addition to the current Ctrl+D.
· Can use Ctrl+Z and Ctrl+Y for undo and redo respectively. In addtion to the current Ctrl+Shift+Z and Ctrl+Shift+Y.
Diagrams:
· New diagram Click Actions to edit tables, columns, etc directly from a diagram. Reduced reliance on editing using tree navigation or grids. Just position mouse over the item to edit and click to edit.
· Diagrams now display a NULLABLE icon instead of the text NULL or NOT NULL. It is hoped that this saves space on diagrams. .
· Can use DELETE key to delete glyphs from diagrams. In addition to CTRL-DELETE which was already available.
· Diagram auto layout sometimes produced a runtime error related to foreign key glyph connections. This is now fixed.
· Diagram right click popup menu only shows the menu items that are applicable for the click context. Before it used to disable the non applicable menu items.
· On table glyphs the foreign key icon as been moved from the left side to the right side. No more overlapping with primary key icon.
Reverse Engineering:
· Support for table level unique constraints.
· Support for PostGIS GEOMETRY data type.
· Some PostgreSQL user tables starting with 'pg' or 'sql' were ignored during reverse engineer because they were thought to be system tables. This is now fixed.
Forward Engineering:
· Script Explorer tree hierarchy as been 'flattened', in that the number of folder nodes has been reduced. It is hoped that this will reduce the number clicks during script navigation because there are fewer folder nodes to open.
· Reserved words weren't being escaped or enquoted properly in the generated script if the database only had a single schema. This is now fixed.
· Generated script text uses more line feeds now. It is hoped that this will make reviewing scripts easier.
· PostgreSQL generated scripts don't automatically create a sequence from the Autonumber flag anymore. Users will now have to specify the sequence themselves and give it a name. The previous arrangement was resulting in unintended sequence generation sometimes.
· Error 'Dbms.getFormattedname()' occured during some script generation. This is now fixed.
· DROP INDEX generated script for Oracle was incorrect, this is now fixed.
· SYSDATE generated script enquoting for Oracle was incorrect, this is now fixed.
· Oracle generated scripts incorrectly enquoted NULL DEFAULT values. This is now fixed.
Table Data Viewer:
· Can view table data in it's own tab. Just click on the Click Action icon in the top right corner of any diagram table glyph and a data panel will open in it's own tab.
SQL Editors:
· SQL Editor code complete did not handle dot notation. Now it does.
February 14th, 2012General:
· Reverse Synchronize has been renamed Database Compare. Perhaps the new name will be more intuitive for new users.
· Attempting to Save with no design open caused an error. This is now fixed.
General GUI:
· Many panels, like Reverse Engineer, had their own status bars at the bottom of the panel. These status bars have been removed and the status information integrated into the panel, giving more space to the panel itself and providing a cleaner interface.
· The white header panel used by many panels is now shorter, making more space available for the panel itself.
Diagrams:
· Diagrams now support three new entity relation (ER) notations. The new notations are Bachman, Barker and Information Engineering (IE). Use tbe Relations tab in the Edit Diagram panel to change the notation.
· Users can add & remove preset diagram zoom levels. Use Edit | Preferences | Diagrams to do this.
· Diagrams can be set to display the foriegn key name on top of the link drawn in the diagram.
· The shading around table glyphs has been improved.
Reverse Engineering:
· Users can now specify schemas on the database server to ignore. Use the Ignore Schemas tab in the Edit Connection panel. These schemas will be ignored by DbWrench for Reverse Engineer, Forward Engineer and Database Compare.
· PostgreSQL array data types are now supported. Use the DBMS Specific tab in the Edit Column panel.
· MySQL reverse engineer of the index UNIQUE flag was incorrect, this is now fixed.
Forward Engineering:
· If a table needs to be rebuilt by the generated script, the generated script will explain using comments in the script, why the table needed to be rebuilt.
· Oracle ALTER TABLE...MODIFY COLUMN... is now supported. This will make scripts generated for Oracle shorter and with fewer table rebuilds.
· MS SQL Server DATE data types were erroneously scripted as DATETIME. This is now fixed.
· The data type of PostgreSQL autonumber columns was not always updated if it was switched between INTEGER, BIGINT and SMALLINT. This is now fixed.
SQL Editors:
· The Undo/Redo functionality in the SQL Editors didn't respond to CTRL-Z and CTRL-Y. This is now fixed.
Database Documentation:
· Users can now export diagrams in Scalable Vector Graphics (SVG) format. From the main menu use File | Export SVG.
October 5th, 2011General:
· The number of Java & NetBeans modules used by the application has been reduced by about 30%. This has reduced the zip distributable file size significantly and has slightly improved application startup time.
· Print preview now shows the page margins in the preview.
· In the main application status bar the INS text ran up against the current design name text. A spacing gap has now been added.
· A toolbar button as been added to the main toolbar for the Open Design action.
· Many menu items in the main menu have had icons added to them. Particularly in the Window menu. This should make finding particular items easier.
General:
· The number of Java & NetBeans modules used by the application has been reduced by about 30%. This has reduced the zip distributable file size significantly and has slightly improved application startup time.
· Print preview now shows the page margins in the preview.
· In the main application status bar the INS text ran up against the current design name text. A spacing gap has now been added.
· A toolbar button as been added to the main toolbar for the Open Design action.
· Many menu items in the main menu have had icons added to them. Particularly in the Window menu. This should make finding particular items easier.
Diagrams:
· Diagram refresh and redraw performance has been improved. Particularly at the zoom level of 100%. Other zoom levels still need to be optimized.
· The diagram will auto scroll when mouse is dragged beyond the diagram panel's limits.
· Diagram link lines are now always drawn under table glyphs.
· Diagram link lines are now always drawn over glyph shadows making link cardinality easier to read.
· When a table glyph is dragged, it's links are continuously redrawn during the drag operation.
· When the mouse cursor passes over a link in a diagram, the link and the columns involved in that link are highlighted.
· The sliding speed of the auto locating glyphs functionality has been increased.
· Changing the background color of a table, zone or note glyph is now stored. This stored color is then applied automatically to the next table, zone or note glyph added.
· Clicking on a table glyph in the navigator panel now automatically slides the diagram to show that table glyph.
· Navigator panel's background color now matches the diagrams background color.
· Pressing the shift key while the mouse is over a diagram now shows a closed hand cursor rather than an open hand cursor. Making the cursor behaviour more standardized.
· Menu items in the diagram popup menu were missing accelerator ( short cut) keys. These have now been added.
Reverse Engineering:
· Oracle triggers were sometimes associated with the wrong table. This is now fixed.
· Reverse engineer of Oracle NUMBER types with NULL precision sometimes created a null exception. This is now fixed.
· Oracle TIMESTAMP types were erroneously reverse engineered as custom types. This is now fixed.
· Reverse engineer of case sensitive MS SQL Server databases resulted in several errors. These are now all fixed.
· Oracle connections that specified SID failed because the JDBC URL was malformed. This is now fixed.
· A generic connection, available in DbWrench to generate create script DDL, was not available for Oracle. Now it is.
· Reverse Synchronize now automatically highlights and sets focus to the first row of the grid after a refresh.
Forward Engineering:
· Oracle DDL generated for NUMBER types with both the length and the scale specified was incorrectly formatted. This is now fixed.
· MS SQL Server forward engineer DDL now always specifies the schema name even if there is only one schema. This keeps items from automatically being added to the dbo schema.
· If a PostgreSQL 8.4 schema a was renamed, DROP INDEX generated DDL statements would still used the old schema name. This is now fixed.
Table Data Viewer:
· Editing Oracle row data did not show combo boxes for foreign key fields. This is now fixed.
· On some smaller instantiations of the Row Edit panel, a vertical scrollbar was displayed even though it was not necessary. This is now fixed.
SQL Editors:
· The SQL Results grid now allows single cell selection rather than just row selection. This should allow users to copy (via CTRL+C) just the single cell value they want.
August 30th, 2011General:
· Direct support for printing large diagrams over multiple pages.
· Default memory allocation for the application is increased to 256 MB.
· Repeated use of the color chooser on some Linux machines resulted in an error, this is now fixed.
· Can specify primary key in the same panel when creating the column itself.
General GUI:
· New upgraded look and feel for the application.
· 'Save Database' menu items and such have been renamed to 'Save Design', etc.
Diagrams:
· The number of tables that can be used with autolayout are now unlimited.
Reverse Engineering:
· Support for reverse engineering Oracle databases.
· Support for PostgreSQL 9, MySQL 5.5 and SQL Server 2008r2
· Upgraded to use the latest JDBC drivers for each of the supported database management systems. Resulting in improved performance and reliability.
· If a PostgreSQL trigger referenced a function in another schema this caused an error. This is now fixed.
· Reverse engineer of PostgreSQL functions did not distinguish between 'returns setof record' and 'returns table', this is now fixed.
· Reverse engineer of PostgreSQL functions did not recognize COST and ROWS values, now it does.
· Reverse engineer of PostgreSQL functions left out the space between IMMUTABLE and the following qualifier, this is now fixed.
· Reverse engineer of PostgreSQL functions did not recognize the path location specified for external function calls, now it does.
· Reverse engineer of MS SQL Server triggers failed if there were extra line feeds after the 'AS' clause, this is now fixed.
· Reverse engineer of MS SQL Server multicolumn foreign keys sometimes reversed the order of the columns in foreign key, this is now fixed
Forward Engineering:
· Support for forward engineering Oracle databases.
· Edit Connection panel now warns users if they have any trailing spaces in any of the fields used to define a server connection.
· Added HTML links to the edit server connections panel to help users who may be having problems getting their connection to work.
· PostgreSQL generated scripts did not enclose entity names containing a dash in quotes, this is now fixed.
· Create DDL for sequences sometimes added an unnecessary space at the start of the DDL, this is now fixed.
· Forward engineer of NUMERIC datatypes were scripted as MONEY, this is now fixed.
· MySQL BIT datatypes were scripted as TINYINT, this is now fixed.
SQL Editors:
· Code complete now has entries for names of user objects in the current design.
· Code complete's popup speed has been improved.
October 13th, 2010General:
· The Connection Edit panel now has an Optional Parameters field which can be used to specify the name of a MS SQL Server named instance. Use the 'instance=myinstance' format.
· MySQL users can use the same Optional Parameters field to specify that a connection use Unicode.
· Config files for older DbWrench versions produced errors when being loaded. This was because they referred to (Unknown) data types as (Custom) still. This is now fixed.
General GUI:
· Edit Connection panel only shows DSN information if a MS Access database is selected. Otherwise it hides this field.
· Edit of Note texts are now undo-able. The bug that prevented them from being undone has now been fixed.
· Undo of Add Note tool tip displayed a numeric ID which wasn't very helpful. Now it displays 'Add Note'.
· Rdo after an Undo of an Add Table command sometimes failed. This has now been fixed.
· The New Table edit panel no longer contains the Column Sorting tab. This slightly simplifies the interface.
Diagrams:
· Holding down the Ctrl key to select more diagram items didn't work. This is now fixed.
Reverse Engineering:
· Reverse Engineer queries for PostgreSQL use a different character escaping format. The older format was leaving warning messages in the PostgreSQL 9 server log.
Forward Engineering:
· Forward engineering's DROP VIEW DDL formatting was not completely correct making it difficult to read. The formatting has been improved.
Table Data Viewer:
· Data editing combo boxes automatically used the 'desc' field of a table before using the 'name' field for the combo box text. Now they will look for the 'name' field first.
· Inserting data with Data Viewer with an invalid column value caused DbWrench to hang on some systems. We believe this was due to a dialog box being created from another dialog box. This should now be fixed as success and error messages are now displayed in the Session Log tab.
SQL Editors:
· DbWrench editors and script viewer panels had a somewhat excessively large font. This default font size has been reduced.
· SQL Results no longer displays tabs if there is only one result set. Thus saving some space.
· SQL Communicator displays it's status messages without having it's own status bar. Thus saving some space.
Database Documentation:
· Documentation now includes the column's UNIQUE flag settings.
September 7th, 2010General:
· Support for Custom Data Types.
· Support for Unique Constraints.
· Support for MySQL Procedures and Functions.
· Tested against and supports MS SQL Server 2008.
General GUI:
· Edit of Note texts are now undoable. The bug that prevented them from being undone has now been fixed.
· Entering a string value into the Scale field in Column Templates caused a runtime error. This is now fixed.
· Runtime error occured sometimes if design file was being saved but DB Explorer was closed. This is now fixed.
Diagrams:
· Navigator Panel sometimes erroneously continued to display a diagram after a different database file had been opened. This is now fixed.
· Navigator Panel did not resize correctly if it was covered over by another panel when DbWrench started up. This is now fixed.
· Highlights and slides the diagram to display a Note or Zone that has been selected in Database Explorer.
· Runtime error when using Foreign Key to Primary Key Column diagram link strategy if more than one foreign key of a table referenced the same column. This is now fixed.
· Runtime error if diagram contained foreign keys with the same name. This is now fixed.
· Opening a new database for the first time now automatically displays the default diagram that is created.
Reverse Engineering:
· Some MS SQL Server system indexes were being reverse engineered. This is now fixed.
· Error handling during reverse engineer of foreign keys, primary keys and indexes has been improved.
· Reverse engineer of MS SQL Server procedures sometimes included the [ and ] in the schema name. This is now fixed.
· Reverse Synchronize sometimes produced errors if multiple rows were selected to be synchronized. This is now fixed.
· Undo of reverse synched values sometimes caused an error. This is now fixed.
Forward Engineering:
· Support for PostgreSQL datatypes: tsvector and tsquery.
· Transaction rollback on PostgreSQL incorrectly listed the DDL command after the one that actually caused the rollback. This is now fixed.
· Forward engineers PostgreSQL columns that only contain a change in the case of their name. For example: changing between upper and lower case.
September 7th, 2010General:
· The Help Contents has been completely updated.
· Support for SSL connnections implemented.
· Saving edits to procedures and views caused the following procedure or view node to be selected. This is now fixed.
· Undo didn't work for zone edits. This is now fixed.
· Saving a database design produced an error if procedures or views did not have any code defined. This is now fixed.
· Rename History produced errors if a rename was undone and redone several times. This is now fixed.
· Removing or adding diagram objects didn't always display the 'modified' asterisk in the status bar. Now it does.
· A bug in Foreign Key Edit panel sometimes only listed one table in the Parent Table combo box is now fixed.
General GUI:
· On Add Column and Column Templates panels, the text field for length and scale didn't render properly on some operating systems and certain look and feels. This is now fixed.
· Added new Database and Diagram menus to centrally locate common actions. These actions now also have new short cut keys assigned to them.
Diagrams:
· Can now cut/copy/paste diagram objects to other diagrams.
· A zoom toolbar has now been implemented showing the zoom level of the current diagram.
· Adding a table to a diagram where the zoom wasn't 100% resulted in the table being placed at an incorrect location. This is now fixed.
· Diagram zooming now maintains the image center while zooming.
· Diagram Export menus didn't always refresh when a different database was opened or when new diagrams were added. This is now fixed.
Reverse Engineering:
· Postgresql entites starting with pg weren't always being reverse engineered. This is now fixed
· Reverse Engineer of views failed if the view's code contained multiple FROM clauses. This is now fixed.
· Minor capitalization inconsistancies in the Reverse Engineer Log have been fixed.
Forward Engineering:
· Support for NULL length and NULL scale values for PostgreSQL data types is now implemented
· PostgreSQL data types BIT and BIT VARYING weren't forward engineering properly. This is now fixed.
· Support for UUID data type in PostgreSQL has now been added
· Objects that have been unselected by users in Preferences | Forward Engineer to be ignored during Forward Engineer script calculation will also now be ignored in database comparisons in Reverse Synchronize.
· Script Hierarchy Explorer is now cleared when a new database design is opened.
· Carriage returns are now added to some DDL statements in the generated scripts that were significantly and consistantly longer than 80 characters.
Table Data Viewer:
· On the dynamically generated data edit panels the combo boxes for fields with foreign keys weren't always available when they could have been. This is now fixed
· Cache containing database data for a table is deleted when the table is deleted from the database design.
· Inserting or updating values containing apostrophes sometimes caused errors. This is now fixed.
Database Documentation:
· The database documentation panel has been renamed to Document DB.
September 7th, 2010General:
· Sort Columns panel now has Up and Down buttons as an alternative to using drag and drop.
· Removal of most elements no longer shows a Delete Confirmation message box since the removal of these elements is undo-able.
· Renaming a schema by double clicking on it's tree node resulted in it's schema objects being lost. This is now fixed.
· If the database design does not use sequences or procedures the folder nodes of these items can be hidden. Select this option in the Database Explorer section of Preferences.
General GUI:
· Database Explorer tracks which nodes were expanded prior to exiting and re-expands them the next time DbWrench is started.
· DbWrench tracks which editors and diagrams were open when it was closed and only re-opens those editors and diagrams the next time it is started.
· Undo/Redo toolbar is no longer embedded within the File toolbar. It is now it's own distinct toolbar.
· Undo/Redo can be performed using Ctrl+Z and Ctrl-Y respectively.
· Editor tabs can be closed using Ctrl-W.
· The DbWrench Log window shows up in front of the Forward Engineer Log window by default.
· Database Properties panel now has an Update button which can be used to make sure that edits are applied.
· Trigger Edit panel incorrectly displayed in a pop-up dialog, now it displays properly as a tabbed editor.
· New mnemonic keys to navigate Table Details panel's tabs. See the View menu.
Diagrams:
· DbWrench now supports Notes in diagrams.
· DbWrench now supports Zones in diagrams allowing for more visual grouping of tables.
· The Delete key can be used to remove foreign keys directly from diagrams.
· Diagram glyphs have gradient backgrounds now.
· The highlight border for selected table glyphs and foreign key links is thicker and brighter making it easier to see which diagram items are selected.
· When diagram glyphs are being dragged to a new location the mouse cursor displays a proper Move cursor.
· Auto-layout of tables on a diagram has been improved to make the layout more balanced with fewer large empty areas.
· Link corners drawn on Key to Key link strategy diagrams are now rounded making it easier to see the direction of link when several links overlap or cross over.
· Ctrl++ and Ctrl-- can now be used to zoom in and zoom out diagrams, respectively.
Reverse Engineering:
· Errors were generated if PostgreSQL table names contained 'pg_' somewhere other then the start. This is now fixed.
· Cosmetic and layout improvements to Reverse Engineer panel.
Forward Engineering:
· Enclosing mixed case entity names in double quotes for PostgreSQL are now supported. Ensure this option is selected in Preference's PostgreSQL options. Script Explorer tracks which nodes were expanded prior to script recalculation and re-expands them after the calculation.
SQL Editors:
· Layout improvements to SQL Results panel.
Database Documentation:
· 'DbWrench' is removed from the header in HTML docs. Now it's displayed in the 'Documentations Created...' line.
· Cosmetic and layout improvements to Database Documentation panel.
September 7th, 2010General GUI:
· The Details panel did not update when the Database Explorer tree nodes were navigated to using keyboard actions, only with mouse clicks. Now it updates with either type of action.
· Glyphs can no longer be moved off the screen (to negative coordinates), preventing them from becoming unretrievable.
· If an entity editor panel had an asterisk in the tab title (see Figure 1), that editor panel would not be re-located and a duplicate editor panel would be opened. This is now fixed.
· DbWrench Output Log window was erroneously displaying v1.6.0, even with newer versions. This is now fixed.
Diagrams:
· Can now specify that a diagram display only primary key and/or foreign key columns for tables, in addition to displaying all table columns. See Figure 2.
· Diagrams didn't retain their last viewport position when switching between diagrams, this is now fixed.
· Changes made to diagram properties are now undoable.
· The diagram redrawing process has been made slightly more efficient and faster.
· Diagram edit panels, when displayed from tree nodes, wouldn't default to (remember) the last used font and link strategy. This is now fixed.
· Diagram edit panels didn't default to (remember) previous settings of 'Display' values, this is now fixed.
Reverse Engineering:
· Reverse engineer of extremely large MySQL tables would hang sometimes, this is now fixed.
· Reverse engineer of PostgreSQL 8.2 and newer sometimes would miss a pair of parenthesis in the default field of a column. This is now fixed.
· Reverse engineer of PostgreSQL databases would place an unnecessary set of brackets around negative numerical default values. This is now fixed.
· If the source code of a stored procedure specified a different schema than the schema containing the stored procedure (within DbWrench) a null pointer error occured. This error is now handled.
· An error occurred if two entities of different types (i.e. views and stored procedures) had the same name and were in the same schema. This is now fixed.
· If an error occurred during reverse engineer, the reverse engineer status bar would reset and erroneously display 'Reverse Engineer Started', this is now fixed.
· Reverse Engineer status bar would display 'Reverse Engineer Started' when more detailed status messages were available, this is now fixed.
Forward Engineering:
· Unlimited VARCHAR for PostgreSQL can now be created by setting the datatype to VARCHAR and not specifying a length, resulting in a VARCHAR(). In Reverse Synchronize, indexes were added before the columns they depended on were added, resulting in an error message. Now the columns are added first.
Table Data Viewer:
· Data grid is cleared while a data refresh is in progress.
· When a refresh of data fails, the 'Data Retrieval Error' message for the failure is now more informative.
SQL Editors:
· Database Documentation
· The Clear button has been removed from the Database Documentation panel to save space, since the documentation Log clears automatically when appropriate.
Find us on Google+
