SQL Power Architect Community Edition Release Notes 1.0.9 Bug Fixes : * Fixed issue of including Target (output) table as an input table in a generated transformation job. * Fixed issue related to exporting 'MergeJoin' keys in a transformation. * Resolved the issue of not populating database connection name in a kettle Job. * Fixed issue of not including a [JOIN_KEY] field in a reference stream. * Improved UI for column mapping in a Column properties dialog box. Enhancement: * Enhanced to save the transformation output to different type like 'Insert/Update' in a kettle job. * Split the big kettle job into multiple jobs by allowing user to select the desired tables for each job. * Add sort step before a 'MergeJoin' step in a generated transformation of a kettle job. Update: * Updated to support Java 8 1.0.8 Bug Fixes : * Resolved some NPE issues * Fixed several issues in the cut/copy/paste and delete operations. * Improved UI for print dialog. (spinner width) * Added validation check on creation of new/edit Column with empty logical name * Implemented to display database name (SQL server database) in connection settings of Pentaho job creation store Enhancement: * Added a property of quoting column name for PostgresSQL. * Implemented to support SQL Server 2012 for database connection. Update: * Updated to support Java 7 1.0.7 Bug Fixes: * Fixed several issues in the copy and paste operations. * Improved on the undo and redo of table columns. * Improved the straighten lines layout feature. * Added 11g configuration to the basic database list that comes with Architect. 1.0.6 Bug Fixes: * Fixed saving of files with XML characters in remarks fields. * Fixed a exception when right clicking in the play pen while dragging. * Fixed an exception when sorting numerical value fields in the graphical viewer of profiles. 1.0.5 Bug Fixes: * Fixed the JDBC driver panel to properly save the modified drivers. * Comments do not lose new line characters * Corrected the label layout on relationships. 1.0.0 Validation: * There is now a critic manager window that allows users to specify what validations apply to their project. * On forward engineer the validator will check if the data model follows the desired restrictions and provide error messages with suggested fixes where applicable. UI: * Users can now open multiple projects in one window. The new projects will appear in different tabs. Bug Fixes: * Adding a data source that is invalid will no longer display numerous error messages. 0.9.16 Updates: * Updated the SQL Server driver. Users can now connect to SQL Server 2008 (Requires Java 6 and up). * Improved saving. Users will now be warned if they are about to save over a file with a different version. Additionally, users will be warned if they are trying to open a file that has been saved with a newer version. Bug Fixes: * Fixed the Copy Table Data panel. Users can expand and navigate the data sources again. * Other minor bug fixes. 0.9.15 Bug Fixes: * Fixed comments in MySQL's DDL generator * Copy & paste of tables no longer causes illegal state exceptions when pasting into a different schema. * Fixed a null pointer exception on DDL generation when the comments are null. * Other minor bug fixes 0.9.14 New Features: * German translation (contributed by Thomas Kellerer) * Brazilian Portuguese translation (contributed by Rogério Ramos da Silva) * DDL foward engineering support for H2 (contributed by Thomas Kellerer) * Support for using Apache Velocity templates for HTML reports (contributed by Thomas Kellerer) Bug Fixes: * Now Mondrian schemas are always exported with UTF-8 encoding (previously, was platform default encoding) * Fixed graphical artifacts while moving around Playpen components are non-default zoom levels (contributed by Israel Rios) * Fixed Windows installer so that it works properly on 64-bit Windows * Other minor bug fixes 0.9.13-release * Relationship labels now display vertically if there's not enough room horizontally * An improved installer for Windows that can detect where your Java Runtime is located, and if it is missing, it can point you to a website to download it. * Decreased file size (down to 16 MB from 18 MB) due to cleaning out some unused libraries * A few additional bug fixes 0.9.13-rc2 New Features: * Source databases can now be refreshed to pick up structural changes made to them after there were added to the project * Support for Copy, Cut, and Paste for Tables, Columns, and Relationships * Profiles can now be searched with regular expressions, or by exact match * Export to PDF for OLAP Playpens * Ability to export an HTML report generator * The colour of relationship lines can now be changed * The default settings for new columns can now be changed in Preferences * Relationship lines can now be labeled Usability Enhancements * Profile rows are now selectable in the Profile Manager, and they can be naviagated with the keyboard (up and down keys to change rows, enter to open, and del to delete) * Fixed OS X keyboard shortcut so that it uses Command-Select to multi-select tables and columns instead of CTRL-Select. * Shift-select can now select multiple columns in a table Bug Fixes: * MySQL DDL generator now uses the fully qualified table name when creating indexes. Before, it would only put the table name, which would only look for the table in the default catalog. * BIGINT data type now gets properly forward engineered to PostgreSQL as BIGINT 0.9.13-rc1 New Features: * Added a new SQL Query Tool to replace the older SQL Runner * Added more keyboard shortcuts to the OLAP editor * Added an a new 'Advanced Properties' tab for Database Types in the JDBC drivers panel that allows for tweaking of database type behaviour without having to directly edit the pl.ini Bug Fixes: * Improved reverse engineering performance on Oracle * Repositioning OLAP components in the OLAP editor is undo-able * Fixed drop primary key syntax in Compare DM for SQL Server 2005 * Fixed an error when reverse engineering an index on a function * Dragging and dropping objects from one tree in one window to the playpen of another separate window is now possible * Fixed print preview behaviour * Fixed an issue where loading an OLAP session resulted in a new OLAP session being added to the project. * Improved the Show Column features in Project Settings. Change the settings from checkboxes to radiobuttons which makes more sense.(Note: when first time useing this build to load previous projects, it will be set to the default value - Show All Columns) 0.9.12 New Features: * Added support for ON DELETE and ON UPDATE actions in all supported database platforms, both forward and reverse engineering * Introduced specific support for SQL Server 2000 vs. SQL Server 2005 for forward engineering, because they support different ON DELETE and ON UPDATE actions * Added a new Russian translation * The Korean translation is now more complete * Added a navigation window to help when working with large playpens (Window->Playpen Navigator) * Table colours, line, and corner style changes can now be applied to multiple tables at once * Added support for modeling OLAP schemas: Cubes, Measures, Dimensions, Hierarchies, and Levels. OLAP schemas can be exported in Mondrian's XML schema definition format. * The remarks field in the column properties dialog has been enlarged to make model documentation easier. Bug Fixes: * It is now possible to delete indexes from the DB Tree view * When dragging a table left or up past the edge of a model, this operation can now be undone in one step (formerly, it was one undo step per table in the playpen) * It is now possible to undo and redo table colour, line, and corner style changes * When forward engineering, the reported "statements attempted" vs "statements successfully executed" was reported in reverse. This has been fixed. * Improved formatting and indentation for generated DDL scripts (all platforms) * Improved DDL Warning/QuickFix interface * Fixed several problems related to dragging columns in and out of a self-referencing table's primary key. 0.9.11 New Features: * Forward engineering scripts are now organized so that parent tables are created before any of their children. * PDF profiling reports now show the database connection name and the fully- qualified table name rather than just the unqualified table name * An easier-to-use executable (.exe) installer for Windows users * A new Installation Guide * Framework to support multiple langauges. Partial Korean translation available. Volunteers for other translations are welcome! * Item selection is now synchronized between the DB Tree and the Playpen. When something is selected in the Playpen, its corresponding item is selected on DB Tree. * Feature to check availability of newer releases * Undo/Redo now work with relationships, including moving connection points, and straigtening lines. * Option to hide certain types columns * Ability to change the colour of tables and their text, and the ability to display them with rounded edges. * Auto-scrolling for the Playpen * Ability to reverse the direction of a relationship * Ability to focus on either the parent or child table of a relationship from its right-click menu * Ability to delete columns when columns and relationships are selected at the same time * Ability to align tables either horizontally or vertically on the Playpen * Ability to delete items by deleting their corresponding node in the DB Tree * Added restore window size preference on start * Relationships now change between identifying and non-identifying when foreign key columns are moved in or out of the child table's primary key. * Ability to select all child tables of a particular table in DB Tree * Expand all and collapse all options on the DB Tree * Columns in the Playpen are specially marked if they are a primary key, a foreign key, or an alternate key Bug Fixes: * Fixed a bug which prevented PK columns from getting pushed into tables beyond immediate children (see forum thread 1899) * List of source connections in the top menu bar now updates properly * Bug 1548: BLOB and CLOB no longer specify precision/size in Oracle DDL * Bug 1542: Column insertion point correction during addition/removal * Bug 1301: Sorting tables by date in the Profile Manager now works properly * Bug 1580: Sorting tables by date is done dynamically during profiling * Bug 1161: Tables are now created in the correct location after changing the zoom level * Added work-around for Oracle JDBC driver bug: Reverse engineering Oracle databases no longer performs ANALYZE TABLES operation! Known Issues: * If you create a table with a self-referencing relationship, and you move the 'foreign' key column around, it may start throwing Exceptions. If you plan to use a lot of self-referencing relationships in your data model, we recommend that you continue using version 0.9.10. 0.9.10 * Release is now licensed under the GPL version 3. * Revamped support for creating, editing, and reverse engineering indexes. * Fixed the relationship lines to be straight when printing if they were already straight in the playpen. * Added preliminary support for Apache Derby. It is now possible to connect to a Derby instance and use it as a source database. Forward engineering is not available yet. * Relationship connection points can now be moved along acceptable edges on tables. * Playpen zoom level and view position now gets saved with the project. * Tables are now drawn correctly in print preview when printing the data model. * Fixed some table formatting issues when generating a table profile PDF report. * The 'Copy Table Data' tool now has a button for the Database Connection Settings. * Fixed a bug that caused non-identifying relationships to be reverse engineered as identifying relationships in the Playpen. 0.9.9 * Added support for explicitly named sequences in PostgreSQL and Oracle * Added the ability to choose the constraint checking deferrability policy on foreign key relationships on supported platforms * Tweaked the database comparison feature to ignore meaningless data type differences between columns (for example, DECIMAL vs. NUMERIC) * Got rid of an excessive repainting problem introduced in version 0.9.8 (improves drawing performance) * Added the SQL BOOLEAN type to the set of generic types. It forward engineers to BOOLEAN on platforms that support it, and TINYINT on platforms that lack the BOOLEAN type. * Added DDL (forward engineering) support for HSQLDB * Fixed a bug in the SQL script dialog where if the user has chosen not to continue after an error, clicking execute has no effect. * Added a GUI relationship column mapping editor, allowing you to change which primary key column a foreign key maps to in the relationship properties editor. * Fixed support for self-referencing relationships (where the primary key and foreign key are in the same table). * Improved 'Zoom-to-Fit' feature so that it can zoom-to-fit on selected objects in the playpen instead of the entire model. Useful for very large data models. * The table profiler can now optionally perform its calculations locally, instead of on the database server. This may improve profiling performance. * Changed the action for Enter in the play pen to edit the selected item, it is no longer limited to columns. 0.9.8 * Fixed a bug where re-profiling a cancelled profile would freeze the GUI until the profiling was finished. * Fixed recent menu. It now works as expected. * Fixed forward engineering syntax error for LONG and LONG RAW in Oracle. * Added convenient shortcut for performing a structural comparison directly from tree view of source database connections. * Added the ability to forward engineer auto-increment columns in MySQL, PostgreSQL and SQL Server. * Added project option to have relationship lines drawn as direct, straight lines or in the old rectilinear style. The default is still the old style. * Made dragging tables much easier at extreme zoom levels by dragging the table instead of a column when dragging with the Alt key held down (option key on Mac) * Added a new feature to automatically straighten relationship lines that can be straightened without moving any tables. It can be found in the play pen's context menu (also known as the popup menu or the right-click menu). * Corrected the DDL syntax for adding a column in SQL Server (the COLUMN keyword is not allowed) 0.9.7 * Fixed a bug with handling of automatic cascading primary keys in multi-level identifying relationships. * Fixed a bug which was causing the Architect to save corrupt project files. This bug was triggered by adding and removing a column from the primary key. * Further enhanced the profile manager so it is possible to run profiles multiple times per session. * Made it possible to add new database connection types from within the GUI. * Corrected the JDBC URL template for IBM DB2. If upgrading, to obtain this fix, you have to remove the DB2 database type from the user preferences dialog, then restart the Architect. * Corrected an error in the user guide relating to the creation of FK relationships. * And more! 0.9.6 Initial open-source release! * Added the ability to create ETL jobs for Pentaho Data Integration (formerly Kettle) * A number of bug fixes * Replaced the icon set with the free FAMFAMFAM icon set, which looks much nicer than the Java Look-and-feel Graphics Repository we were using before. 0.9.5 Internal release, not publically promoted. * Major bugfix: We now escape all characters in the project file which are impossible to represent in XML. It is entirely possible for these characters to sneak into a profile result. 0.9.4 * Added PDF Export feature under File menu * Added MySQL compatibility * Improved DDL Generator Warnings interface to include a better UI and a "quick fix" feature which guesses the new value * Improved Profiling GUI to include a profile manager for browsing, searching, and deleting existing profile data in the project * Added index support for tables, forward engineering, and reverse engineering (supports unique and non-unique indices) * Completely reworked the strategy for loading JDBC driver classes. New features include: +A better GUI for configuring database connections +Users can create new database connection types within the Architect (previously this required editing PL.INI by hand) +Can have multiple versions of the same driver in use at the same time (required for Oracle 8i/9i/10g) +It is now possible to ship Architect distributions with JDBC drivers built in +There is now a place where we will be able to allow much more user configuration per database type in the future +Unfortunately, this change is not backward compatible with the 0.0.x versions of the Architect PL.INI file. * Replaced the old tree icons with much nicer-looking new ones IMPORTANT NOTE to users upgrading from pre-0.9.x versions of the Architect: We have made incompatible modifications to the PL.INI file which specifies your database connections. After upgrading to this version, you will need to set up database connection types for all your databases in the user preferences dialog, then edit the properties on your existing connections to associate them with one of the configured database types. This will also apply to connections within projects you have saved with older versions of the Architect. We apologize for the inconvenience, but the benefits will outweigh the costs! 0.0.91 * Added in a new function: Profiling -Displays the distrobution of a column's data in a pie chart -Displays useful profiling information such as maximum and minimum values of a column -Shows the most frequent n values within the column (the number of results to display is configurable within project settings) -Ability to sort the information by column attribute -Easy to use search function to narrow down results -Save profiling data in csv, pdf or html formats * Rectify "Save" filename handling: the file suffix is used in preference to the selected File Selection Filter. * Fixed the "Locked Column throwing silent exceptions" bug. When moving a imported column to another table, it did * not show the warning error. * Fixed null count problem in sql server * Fixed minor type mapping problem in the oracle ddl generator * Change from directly using the Swing Browser to display the manual as a form of Help, to using Sun's JavaHelp API. * Added an Index file to the help file.