Softpedia >Windows >Internet >Servers >Database Utils >DbWrench >  Changelog

DbWrench Changelog

What's new in DbWrench 5.1.1

Jan 22, 2024
  • Added hot keys to main menu items.
  • Fixed Save Changes prompt not showing on newly created databases.
  • Fixed incorrect auto-generated index name when index was created using Click Actions.
  • Database Connection drop down automatically selects the newly added database connection.
  • Fixed error that ocurred when adding a new Database Connection without specifying a name.

New in DbWrench 5.0.8 (Jun 6, 2023)

  • General:
  • Added feature to generate HTML documentation of a database design.
  • Diagrams:
  • Can export diagrams as SVG (Scalable Vector Graphics) or PNG (Portable Network Graphics) format.

New in DbWrench 5.0.7 (Mar 25, 2023)

  • General GUI:
  • Fixed a null pointer bug that sometimes occurred while saving a Column Template.
  • Fixed issue with toolbar icons not always showing in SQL Results data viewer.

New in DbWrench 5.0.6 (Feb 8, 2023)

  • Fixed Diagram tree nodes in Database Explorer always expanding when a database design was opened.
  • Modifying the order of columns in a table didn't result in an auto save. This is now fixed.
  • Changing the nullability of the child column didn't automatically redraw the foreign key glyph, this is now fixed.
  • Automatically recalculates forward engineering script when this panel is opened.
  • Fixed Column Templates adding common columns in alphabetical order instead of the list (specified) order.

New in DbWrench 5.0.5 (Dec 27, 2022)

  • General GUI:
  • Re-organized foreign key edit panel to make changing cardinality quicker.
  • Diagrams:
  • Fixed the issue of the diagram popup not displaying after right clicking on a foreign key glyph.

New in DbWrench 5.0.4 (Nov 28, 2022)

  • Implemented auto saving of database design file.
  • Fixed text alignment of table title hover text.
  • Improved alignment of elements on Data Type panel
  • Fixed data type length dialog not closing on ESC typed.

New in DbWrench 5.0.3 (Oct 6, 2022)

  • General GUI:
  • Fixed the garbled font on diagram objects and the main text field in SQL Editor.

New in DbWrench 5.0.2 (Sep 8, 2022)

  • General:
  • Removed the Database menu from the main menu bar. These actions (such as add columns, tables, etc) can be performed more easily from the diagram and other popup menus.
  • General GUI:
  • Fixed the garbled font on the status bar and on one of the labels on the license panel.

New in DbWrench 5.0.1 (Sep 5, 2022)

  • General:
  • Switched the application default font to Verdana. The existing default System font was not properly rendering on many systems.
  • General GUI:
  • Added new About panel. This can be used to view system and application information to assist in trouble shooting. From the main menu use Help | About

New in DbWrench 4.2.5 (Sep 18, 2019)

  • Diagrams:
  • When foreign keys names are displayed on a diagram and a foreign key is renamed, the diagram would not reflect the new foreign key name. This is now fixed.
  • Forward Engineering:
  • If a malformed PostgreSQL stored procedure was encountered during forward engineer script generation an unhandled error would occur. Now the error is handled and a warning message is shown to the user.

New in DbWrench 4.2.4 (Aug 6, 2019)

  • General:
  • Tracking object renames is now done using a GUID instead of an integer increment which caused merge conflicts when managing design files with a source control respository.
  • The CREATE TABLE SQL generator command now includes foreign key DDL.
  • Forward Engineering:
  • An error would occur in Reverse Synchronize of a foreign key if a table involved in the foreign key was renamed. This is now fixed.

New in DbWrench 4.2.3 (Jul 16, 2019)

  • Forward Engineering:
  • Support added for specifying 'start' value on PostgreSQL sequences.
  • Support added for specifying 'increment' value on PostgreSQL sequences.

New in DbWrench 4.2.2 (Jun 12, 2019)

  • Diagrams:
  • Diagram notes now render in solid color and not in gradients.
  • The default color of diagram notes is now a darker yellow.
  • Table Data Viewer:
  • Table data editing panels did not display the columns in the correct order. This is now fixed.

New in DbWrench 4.2.2 (Jun 12, 2019)

  • Diagrams:
  • Diagram notes now render in solid color and not in gradients.
  • The default color of diagram notes is now a darker yellow.
  • Table Data Viewer:
  • Table data editing panels did not display the columns in the correct order. This is now fixed.

New in DbWrench 4.2.1 (May 14, 2019)

  • General:
  • Fixed the bug where if a column used in both a primary key and foriegn key was renamed an error would occur.
  • General GUI:
  • Fixed the bug where newly added columns were not displayed in the Column Sort panel.
  • Diagrams:
  • The foreign key joint glyphs rendered on diagrams have been made larger.
  • The table name text on table glyphs is vertically aligned better.
  • Table Data Viewer:
  • Fixed the bug on Table Data editor in which UUID values were not single quoted on inserts and updates.

New in DbWrench 4.2.0 (Apr 18, 2019)

  • The foreign key joint glyphs rendered on diagrams have been made larger.
  • The spacing between the column text rows on table glyphs has been increased. Note that this will make table glyphs vertically larger.
  • The default font for a diagram is now 12 point which is one point larger than it previously was.

New in DbWrench 4.1.9 (Mar 19, 2019)

  • Diagrams:
  • Table glyphs are now rendered with solid header and footers instead of gradients.
  • Table Glyph Rendering Enhancements
  • New Generated Documentation Styling
  • The table header and footer have been made larger making it easier to drag and move glyphs.
  • The default table color is a different shade of blue.

New in DbWrench 4.1.8 (Feb 5, 2019)

  • Forward Engineering:
  • DROP TABLE and DROP COLUMN now use IF EXISTS, if the underlying database supports it.
  • SQL Editor:
  • Hot key based actions in SQL Editor are more responsive.
  • Can use Cmd + d (ctrl + d) to duplicate selected line.
  • Can use Cmd + e (ctrl + e) to delete selected line.

New in DbWrench 4.1.7 (Jan 15, 2019)

  • SQL Editor:
  • A bug where undo and redo in the SQL editor would undo or redo diagram related actions has been fixed.
  • Database Documentation:
  • A bug that prevented HTML documentation pages from not being accessiable has been fixed.

New in DbWrench 4.1.6 (Dec 11, 2018)

  • The generated database documentation now features new look and styling.
  • New documenation styling
  • New Generated Documentation Styling
  • A bug where the selected documentation folder would include the last folder of the path twice has been fixed.
  • For new databases the documentation folder now defaults to the user folder.

New in DbWrench 4.1.5 (Nov 22, 2018)

  • SQL editor now supports Find and Replace functionality. Use cmd + F or ctrl + F to display the Find and Replace panel.

New in DbWrench 4.1.4 (Oct 11, 2018)

  • Fixed the issue of text overflowing the bottom of the table glyph when the diagram font was changed to a smaller font.
  • Text overflowing glyph
  • Text overflowing glyph
  • Support has been added for changing the diagram zoom using Ctrl + mouse (wheel) scroll.
  • Database design HTML documentation now suppprts unique constraints.

New in DbWrench 4.1.3 (Sep 13, 2018)

  • Table Data Viewer:
  • Fixed an error that would occur if the SQL specified did not reference a valid table on the server.
  • SQL Editor:
  • Fixed the issue when the code complete popup did not close even when the SQL Editor lost focus.

New in DbWrench 4.1.2 (Jul 19, 2018)

  • General:
  • General support added for PostgreSQL 10
  • Reverse Engineering:
  • Fixed sequence reverse engineer bug in PostgreSQL 10
  • SQL Editor:
  • UI correctly shows server response for non SELECT queries
  • Fixed bug when executing multiple queries simultaneously

New in DbWrench 4.1.1 (Apr 23, 2018)

  • Use the right mouse click to copy data from the results grid to clip board.
  • Copy data from results grid
  • The results grid now displays a null icon for null values making it easy to differentiate null values from empty values.
  • Null icon in results grid
  • SQL Editor
  • Fixed the bug that prevented the SQL editor code complete popup from being disabled.
  • Toggle code complete popup
  • Database Documentation

New in DbWrench 4.1.0 (Dec 14, 2017)

  • Table Data Viewer:
  • SELECT statements of a single table, such as SELECT * FROM license, will now display the results in an editable Query Results panel. This allows the query results to be edited with dynamic dialog panels.

New in DbWrench 4.0.4 (Oct 25, 2017)

  • Diagrams:
  • Diagram rendering and responsiveness at zoom levels other than 100% has been significantly improved.
  • Table Data Viewer:
  • Viewing table data for MS SQL Server would generate an error on the SQL SELECT statement. This is now fixed.
  • Database Documentation:
  • Documentation now handles spaces and other invalid characters in table and other database object names.

New in DbWrench 4.0.3 (Mar 9, 2017)

  • General:
  • The issue with the saving of the DbWrench configuration file has been resolved.
  • Reverse Engineering:
  • The issue with prompting for a database password even though a database configuration was defined has been resolved.
  • SQL Editor:
  • Use Shift + Enter to execute all lines in editor and use Ctrl (or Command) + Enter to execute the current line the in editor.

New in DbWrench 4.0.1 (Dec 23, 2016)

  • General GUI:
  • The white header area on many panels has been reduced in size. This should make for a more efficient and streamlined user interface.
  • Table Data Viewer:
  • When data is updated using the data grid the data grid automatically scrolls to the updated row.
  • Incorrect quoting for JSON fields prevented them from being edited in the table data editor, this is now fixed.
  • SQL Editor:
  • Code complete popup did not appear when cursor was followed by a semi-colon, this is now fixed.

New in DbWrench 4.0.0 (Nov 30, 2016)

  • SQL Editor:
  • The code complete popup panel used in the editor panels has been entirely replaced. The new framework is more compact and very responsive.
  • Code Complete:
  • New code complete popup panel.
  • Database Documentation:
  • The database documentation has a new look and new styling.

New in DbWrench 3.3.7 (Jul 11, 2016)

  • General GUI:
  • The Comment text field in the column panel now supports multiple lines.
  • The Note edit panel now supports multiple lines
  • Removing a JDBC connection resulted in the error message. This is now fixed.
  • Forward Engineering:
  • Stored procedure, view and trigger texts are automatically saved when forward engineer are calculated or database compare is executed.
  • The 'USE `databasename`' clause has been removed from MySQL forward engineer scripts.

New in DbWrench 3.3.6 (May 18, 2016)

  • Reverse Engineering:
  • Reverse engineer of sequence increment values for PostgresSQL produced an error if there was only a single schema. This is now fixed.
  • Forward Engineering:
  • A null pointer resulted during Forward Engineer of some indexes that used Column Functions. This is now fixed.
  • Table Data Viewer:
  • In generated UPDATE SQL statement the WHERE clause of a table with a composite primary key was incorrect. It lacked a space before the AND. This is now fixed.
  • SQL Editor:
  • The use of SHIFT + TAB in empty SQL editors resulted in an error. This is now fixed.

New in DbWrench 3.3.5 (May 18, 2016)

  • General GUI:
  • Issues relating to dialog boxes not displaying in the same monitor in multiple monitor setups have been fixed.
  • A Sort button has been added to the column grid panel making it easier to order columns.
  • Image:
  • Newly added column Sort button
  • The layout of the Sort Columns panel has been improved.
  • Diagrams:
  • Using the 'command' key and the mouse to select multiple glyphs was not working. This is now fixed.
  • Forward Engineering:
  • Autogenerated stored procedure names don't automatically prepend the schema name anymore. Prepending the schema name resulted in name comparison failures in Database Comparse between the name in the design and the name on the server.
  • Forward engineer scripts for MySQL now use the keyword 'after' to apply the column order on the server.
  • New columns added using the 'after' keyword
  • Null pointer errors would sometimes result in Database Compare when comparing foreign keys. This is now fixed.
  • Table Data Viewer:
  • When using Table Data editor for table where a new column was added in the design but not yet on the server an error message would be displayed and the table's data could not be edited. Now the error message is not displayed and the table data can be edited.
  • A new column that is not yet on the server.
  • Table Data Editor now inserts empty text fields as NULL not empty strings. To insert an empty string please use ''.
  • Auto number columns in Table Data Editor now use a label instead of a disabled text field. This should prevent auto number from receiving editing focus and also make the user interface cleaner.
  • Autonumber columns display as text labels
  • Table Data Editor generated SQL now uses a closing semi-colon.

New in DbWrench 3.3.4 (Feb 10, 2016)

  • General GUI
  • Diagrams
  • Table Data Viewer
  • Database Documentation
  • General:
  • Database explorer tree nodes support multiple selection and deletion.
  • Reverse Engineering:
  • Reverse engineer of MySQL table comments containing brackets caused errors. This is now fixed.
  • Forward Engineering:
  • The forward engineer script didn't correctly append the schema name for PostgreSQL indexes when there was only a single schema. This is now fixed.
  • SQL Editor:
  • The contents of SQL Communicator panels are stored when the application is close and automatically reopened when the application is restarted.

New in DbWrench 3.3.3 (Feb 10, 2016)

  • Forward Engineering
  • Table Data Viewer
  • SQL Editor
  • Database Documentation
  • Reverse Engineering:
  • Error on saving designs containing Oracle system indexes has now been fixed.
  • Diagrams:
  • Use new toolbar button to quickly add foreign keys by selecting the child and parent tables on the diagram. Use tool bar button to quickly add a foreign key. The diagram zoom level in the zoom toolbar is now editable allowing for an alternative way to specify diagram zoom.
  • General GUI:
  • Trigger edit panel displays name of its parent table.
  • General:
  • Auto save will automatically save design changes. This feature is enabled by default but can be disabled. Use preferences to enable or disable auto save.

New in DbWrench 3.3.2 (Oct 5, 2015)

  • General GUI:
  • Whether new columns added default to NULL or NOT NULL can now be specified in preferences.
  • Toggle whether new columns default to NULL or NOT NULL.
  • In the Database menu, the Add Trigger menu item failed to display the trigger dialog box. This is now fixed.
  • Diagrams:
  • Enabling the display of comments on a digram did not display column comments. This is now fixed.
  • Forward Engineering:
  • Support added for JSON, JSONB and INTERVAL database types.
  • JSON and JSONB example.
  • The list of reserved words for each DBMS has been updated.
  • Option added to always prepend the schema name to objects. This is useful in databases with only one schema where schema name may not always be prepended.
  • SQL Editor:
  • Color coding is disabled on text documents tha have more than 30,000 characters.
  • Back tick enclosed texts were not being color coded. This is now fixed.

New in DbWrench 3.3.1 (Jun 29, 2015)

  • General GUI:
  • Column Edit Panel's Enum field now automatically enables and disables when the appropriate data type (enum or set) is selected. Before the panel had to be re-opened.
  • Diagrams:
  • Double click on a table glyph in a diagram now brings up the Table Details Panel instead of the right click popup menu.
  • Double click on a foreign key glyph in a diagram now brings up the Edit Foreign Key panel.
  • Many of the alt shortcuts for diagrams did not work on Mac. This is now fixed.
  • Spacing of dashes on dashed-line links has been increased.
  • Foreign key diagram popup menu now has menu items for Edit and Remove.
  • Forward Engineering:
  • Fixed MySQL forward engineer bug where a foreign key would be continually scripted to be added and then dropped.
  • Implemented support for PostgreSQL ALTER of column type, length or scale in a single DDL statment.
  • Default values for BOOLEAN fields (i.e. true/false/t/f) are now properly enquoted in generated forward engineer scripts.
  • Setting a MySQL column default to CURRENT_TIMESTAMP no longer requires a backtick to escape it.
  • SHOW CREATE SQL would sometimes error for very long column names. This is now fixed.
  • SQL Editor:
  • Auto code complete erroneously popped up when backspace key was hit. This is now fixed.
  • Text edit undo and redo would sometimes stop responding. This is now fixed.
  • Background color of editor when the text is not editable has been improved.

New in DbWrench 3.3 (Jun 1, 2015)

  • General:
  • Support for the latest MySQL version (MySQL v5.6.24).
  • Support for the latest PostgreSQL version (PostgreSQL v9.4.1).
  • General GUI:
  • Application name and icon now display correctly in the Mac dock.
  • Several panels were not sizing correctly on Mac. This is now fixed.
  • Diagrams:
  • Navigator panel bug that showed zones above tables is now fixed.
  • SQL Editor:
  • Automatic popup of the code completion can now be disabled using main menu: Edit > Preferences > Query Editor

New in DbWrench 3.2.4 (Jun 1, 2015)

  • Diagrams:
  • If the joint line is positiioned to be very short it will shorten and not pretrude out.
  • Clicking on a foreign key link while it was positioned over a zone would not bring up the detailed information for that foreign key. This is now fixed.
  • The default entity relation notation is now Barker. Before it was the Information Engineering notation.
  • When selecting one of the corner anchor points to resize a zone, the selection of the anchor would occasionally fail. This is now fixed.
  • The Print Diagram menu item was missing a space. That is now fixed.
  • Forward Engineering:
  • An error would occur if no database design was open and Recalculate Script was clicked. This is now fixed.
  • SQL Editor:
  • Code completion popup is now automatic. There is no need to type Ctrl-Space. However Ctrl-Space will still bring up the popup too.
  • Ctrl-Enter will now submit the query too. Along with the previously existing Alt-X.
  • SQL Editor did not show code completion for a table if the schema of the table was not specified. This is now fixed.
  • The color highlighting on SQL Editor text have been refined.
  • The code completion popup sometimes appeared when a mouse click was received by the editor. This is now fixed.
  • A runtime error would occur if multiple characters were repeated typed quickly. This is now fixed.

New in DbWrench 3.2.3 (Mar 9, 2015)

  • Diagrams:
  • The cardinality drawn for a parent joint was set manually. Now it updates automatically whenever the null setting of referenced column(s) is changed
  • When a diagram in full screen mode was clicked upon, the diagram Navigator panel would expand taking up a large portion of the lower part of the screen. This is now fixed
  • The diagram Navigator panel would get focus when a diagram was clicked. Typing Ctrl-W would close the Navigator panel not the diagram panel. This is now fixed
  • Arcs connecting link lines to joints would be draw with an incorrect orientation when the arc was really close to the joint. This is now fixed
  • A right angle link would redraw at the origin if one of the link's tables were removed from a diagram and then re-added to the diagram using an undo operation. This is now fixed
  • A right angle link would redraw at the origin if Quick Foreign Key was used followed by an Undo which was then followed by a Redo. This is now fixed
  • If a table glyph was over a zone, it's surrounding shadow would be incorrectly colored. This is now fixed

New in DbWrench 3.2.2 (Feb 9, 2015)

  • General:
  • CREATE TABLE syntax generator resulted in a null pointer error when the table or column had a comment for SQL Server databases. This is now fixed.
  • When a column was being removed checks were not done to see if the column was used in an index. This is now fixed.
  • General GUI:
  • When a new database connection is added the Connection list box in the main menu defaults to that new connection.
  • Diagrams:
  • Removing a diagram zoom level without selecting a zoom level resulted in a misleading error. This is now fixed.
  • Locate Glyph resulted in a error if the Navigator panel was not open. This is now fixed.
  • Forward Engineering:
  • The text editors used by the Difference Details of Database Compare did not have proper syntax highlighting. This is now fixed.
  • Forwarding Engineer now automatically syncs PostgreSQL Table Options such as without oids so they don't appear in Database Compare.
  • Database Compare now ignores the numerical portion of autonumber=1234 when performing a comparison.
  • Specifying CURRENT_TIMESTAMP as the default value for a MySQL column caused it to be continually scripted in forward engineer script. This is now fixed.
  • SQL Editor:
  • After typing the '.' character the SQL Editor code complete erroneously showed keywords and other words that were out of scope. This is now fixed.
  • The SQL Editor did not automatically show the code completions for sub objects after just the '.' character was typed. This is now fixed.
  • Database Documentation:
  • Table comments are now displayed in the database documentation.

New in DbWrench 3.2.1 (Sep 26, 2014)

  • General:
  • Empty borders around many of the edits panels have been reduced.
  • The menu item for 'Object Details' was missing in the v3.2.0. It has been added back in and can be accessed from the Windows menu and the Tools menu.
  • The diagram Navigator panel automatically opened and displayed when a diagram received focus. This behaviour has been changed so that the navigator panel will only display if it has been opened by the user. It will not automatically open.
  • Ctrl-w was failing to close the current panel (window). This is now fixed.
  • The keyboard shortcuts for Database Compare and SQL Communicator overlapped in v3.2.0. Now short cuts are F8 and F9 respectively.
  • Diagrams:
  • Movable link lines flickered into incorrect positions when being moved. This has now been fixed.
  • Diagrams now support a font size up to 60
  • Renaming a table using diagram click actions allowed for duplicate table names in the same schema. This is now fixed. Duplicate table names will not be accepted and an error message will be displayed.
  • Increasing diagram font size did not scale up the size of foreign key connections (i.e. crowfoots, etc). This is now fixed.
  • Default diagram font size is now 11.
  • Forward Engineering:
  • Loading a Forward Engineer script into the text panel was slow and would lock up the application. The loading of the script into the text should be much quicker now.
  • SQL Editors:
  • Syntax highlighting (keyword color coding) would be incorrect by one or more characters for multiline texts. This is now fixed.
  • Expansion of abbreviated text would be off by one character under certain conditions. This is now fixed.
  • The SQL text editor threw a runtime exception when invoking the code complete window on the last line of multiline text. This is now fixed.

New in DbWrench 3.2.0 (Sep 13, 2014)

  • General:
  • Support for Java 8.
  • Underlying NetBeans platform upgraded from NetBeans 6.9.1 to NetBeans 8.0
  • SQL Editors:
  • New SQL editor.
  • Improved keyword support.

New in DbWrench 3.1.1 Build 36 (Apr 23, 2014)

  • General:
  • When columns are created they now default to NULL instead of NOT NULL
  • The default column templates now mark the Id column as a primary key column by default.
  • Diagrams:
  • When a glyph was moved through it's own three line link, the line algorithm would draw the link lines incorrectly. This is now fixed.
  • Also with three line movable links, if the middle connecting line was made smaller than the arc radius of the connecting arcs a null pointer error would result. This is now fixed.
  • A bug that reset all the positioned link lines when a diagram was renamed has been fixed.
  • Zooming in and out sometimes lost the center point of the zoom. Resulting in the diagram shifting from it's original position after zooming in and out. This has now been fixed.
  • Copying and pasting zones or notes from one diagram to another would return a null pointer error. This is now fixed.
  • Forward Engineering:
  • Scripts now automatically recalculate after the script has run.
  • Forward engineering scripts now run in a transaction by default. You can change this default in Preferences.
  • Table Data Viewer:
  • After a data row INSERT operation, the status would get stuck on 'Inserting..'. This is now fixed.
  • If there was an error INSERTING or UPDATING a row, particularly if the data was invalid, the error would not be displayed. The insert would just fail. This now fixed, these errors are now displayed.

New in DbWrench 3.1.0 Build 77 (Mar 31, 2014)

  • General:
  • Support for cloning of tables has been implemented. See Figure 1
  • Table scripts for CREATE, UPDATE, INSERT and DELETE can be viewed using the table's popup menu. Generating a forward engineer script is not necessary.
  • Indexes now support FULL TEXT and SPATIAL options
  • Indexes also now support Option Text which can be used specify additional index parameters and options. See Figure 3
  • Indexes also now support column functions. See Figure 4
  • Additional menu items have been added to the table pop-up menu providing quicker access to common table related tasks
  • A bug that resulted in column renames not cascade updating to column names in unique constraints has been fixed
  • The ctrl+shift+key sometimes produced an error if invoked while the Table Details panel was not displaying. This is now fixed
  • Diagrams:
  • Auto layout of diagrams has been improved to reduce the overlap of connecting lines
  • Connecting lines that passed over diagram zones could not be selected. This is now fixed
  • Reverse Engineering:
  • Reverse engineering didn't reverse engineer the auto number flag correctly for PostgreSQL databases. This is now fixed
  • Forward Engineering:
  • For PostgreSQL columns marked as auto number, forward engineer will automatically create a sequence and update the column's default value to use that sequence. See Figures 5 and 6
  • For Oracle databases, Database Compare will not mark columns with no scale as different from a scale value of 0. It will treat them as equivalent
  • Table Data Viewer:
  • Table Data Editor did not allow for the entry of negative numbers. This is now fixed

New in DbWrench 3.0.1 Build 32 (Oct 10, 2013)

  • General:
  • Further improvements to the memory footprint and memory usage of the application. Particularly for larger data models.
  • Diagrams:
  • A new table linking algorithm for diagrams. Tables are linked using right angle lines. Select Right Angle Connecting Lines strategy in the diagram edit panel.
  • Foreign key lines on diagrams can now be moved and positioned. Must set the link strategy of the diagram to the new Right Angle Connecting Lines strategy.
  • New rectangle fill algorithm for diagram table glyphs. Select the new Header Gradient Fill in the Misc tab of the Diagram Edit panel. Only the header and footer of each table is colored the rest of the glyph is white, which we think improves readability.
  • Details Panel is not automatically shown in the bottom of the application any more. Instead it is shown either by opening it explicity using the Windows menu or by clicking on the details icon in the top left corner of the table glyph itself. Then it will display in a popup dialog. It is hoped that this will keep more space open for viewing diagrams.
  • Table Data Viewer:
  • Table Data Viewer now shows only the first 1000 rows by default. Sometimes invoking it with large tables caused timeouts.
  • The data row editor of Table Data Viewer had a bug which did not allow entry of negative numbers. This is now fixed.

New in DbWrench 2.3.2 Build 12 (Dec 6, 2012)

  • Diagrams:
  • There was a memory leak in diagramming that was causing the programming to hang. This has now been improved. However, we are still trying to reduce the total memory footprint.
  • Performance enhancements to the diagramming. Moving of glyphs around the diagram should now be more responsive.
  • Clicking and dragging on Zone glyphs occasionally produced a runtime error. This is now fixed.
  • Mouse rollover click actions for zone glyphs were not being displayed, this is now fixed.
  • When the mouse exited a table glyph, sometimes the last roll over click action drawn would still remain drawn. This is now fixed.
  • If a zone glyph was dragged to a negative height or width this would produce a runtime error. This is now fixed.

New in DbWrench 2.3.1 Build 14 (Aug 30, 2012)

  • Diagrams:
  • Click actions can be toggled on and off using a toolbar button. See Figure 1 below.
  • Use Preferences panel to disable gradual sliding of the diagram to locate a table glyph. Diagrams will than immediately move to locate the specified glyph.
  • Diagram Properties panel remembers the last used tab and defaults to that tab when opened the next time.
  • Diagram Click Actions automatically disable when zoom is below 50%.
  • If a database contains a significant number of tables, auto diagram layout creates a separate diagram for each schema, rather than putting all the tables onto a single diagram.
  • A run time error would sometimes occur when changing the foreign key cardinality on a newly created diagram, this is now fixed.
  • When many diagrams are automatically being created, such as after a Reverse Engineer, the status bar will display how many diagrams are remaining to be created.
  • The click action for table name, did not allow the changing of the table name's case, this is now fixed.
  • Reverse Engineering:
  • Entities specified to be ignored for Forward Engineer, will also now be ignored for Reverse Engineer too.
  • The automatic prompt to Load Reverse Engineered Database is no longer displayed, the reverse engineered database is automatically loaded.
  • Forward Engineering:
  • Forward Engineer script recalculation can now be done by using a hot key or clicking a toolbar button.
  • Database Compare can now be refreshed by using a hot key or clicking a toolbar button.
  • Update scripts would be generated for sequences, even if Forward Engineer for sequences was disabled, this is now fixed.
  • Calls to sp_rename in forward engineer scripts now always prepend the the schema name to the entity name.
  • The update of a stored procedure is now done in a single step, rather than requiring a sub script.
  • If only a single step was selected in Forward Engineer the command terminating semi-colon was not added, now it is.
  • Table Data Viewer:
  • In Table Data Viewer, when a particular cell is double clicked, the pop up editor automatically sets focus to the corresponding text field.
  • Specifying SYSDATE when updating a date field in a record on an Oracle database errored, this now fixed.

New in DbWrench 2.3 Build 11 (May 8, 2012)

  • General:
  • 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.

New in DbWrench 2.2.1 Build 16 (Feb 14, 2012)

  • General:
  • 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.

New in DbWrench 2.2.0 Build 17 (Oct 5, 2011)

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

New in DbWrench 2.1.0 Build 23 (Aug 30, 2011)

  • General:
  • 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.

New in DbWrench 1.6.6 Build 19 (Oct 13, 2010)

  • General:
  • 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.

New in DbWrench 1.6.5 Build 11 (Sep 7, 2010)

  • General:
  • 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.

New in DbWrench 1.6.4 (Sep 7, 2010)

  • General:
  • 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.

New in DbWrench 1.6.3 (Sep 7, 2010)

  • General:
  • 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.

New in DbWrench 1.6.2 (Sep 7, 2010)

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