DbSchema Change Log

Version 8.3.1 - Aug 20.08.2020

Bug: Issues with Unique index and Unique Keys. Synchronization skips the differences between this two.
Bug: Issue with SqlServer reverse engineer Foreign Keys
Feature: Improve diagram font size. Make SQL text readable by increasing SQL Editor font size

Feature: Rename 'DbSchema Project' to DbSchema Model. Use this all over the menus and website.
Feature: Connection dialog, the JDBC URL is editable directly in the first tab.
Feature: HTML5 and PDF documentation omit description column if empty
Feature: Improve HTML5 documentation annotations and TOC.
Feature: Data Importer use serialization for XLSX files - avoid memory issues for large input files.
Feature: Use batches for Data Importer and Data Generator for faster data insert.
Feature: Improve Schema Synchronization dialog
Feature: Schema catalog is editable in the Schema dialog
Feature: In Index Dialog added checkbox to implement unique indexes via constraint (ALTER TABLE ADD CONSTRAINT) or index (CREATE UNIQUE INDEX). This should solve also some issues when dropping unique indexes.
Feature: MongoDB Data Generator and Data importer use batches. New MongoDb driver deployed.
Bug: Oracle correct reverse engineer VARCHAR2(length CHAR)
Bug: Postgres create view having 'with(exp)' failing
Bug: Synchronization dialog 'Generate Script Button' does not work by second click.
Bug: Open large project files with many browse and query editors is opening all of the editors.
Bug: Fix error dialog position. Sometimes they show on the very left side of the screen
Bug: Reverse engineer Postgres User Defined Type as enum. The values were not quoted.
Bug: Relational Data Browse edit enumeration columns.

Bug: Loose zoom when dragging new table in layout
Bug: Sqlite reverse engineer multiple foreign keys between two tables
Bug: Issue in schema selection dialog
Bug: Relational Data Browse edit date time bug fix
Feature: Project / Settings / Export Schema Script - add option for pre and post scripts to be attached to exported schema script
Feature: Support reading comments by reverse engineer from SQL files
Feature: Integrate NuoDb
Feature: SQL result pane status and error combo use Monospaced font
Feature: Option to compare two schemas
Feature: Improve dark theme
Feature: Redshift reverse engineer diststyle
Feature: Improve PDF documentation
Feature: Customizable UI Scaling added in Project / Appearance

Feature: Review Sqlite data types
Feature: Postgres support for types and enums
Feature: Postgres reverse engineer indexe WHERE clause
Feature: Improve Find Virtual Foreign Keys dialog to support multiple databasese
Feature: Vertica improvements
Feature: Improve MongoDb diagram auto-arrange
Feature: New Driver for MongoDb
Feature: Upgrade SqlServer driver to 8.2.2
Feature: Improve Pdf documentation look
Feature: Upgrade to OpenJdk 14 and OpenJFX 14
Feature: Move fast view table data ( CTLR-SHIFT-click table header ) to dialog
Bug: Sqlserver reverse engineer only column collations which are different from the database
Bug: Improve view reverse engineer
Bug: Improve column options dialog
Bug: Data Importer with Excel empty cells
Bug: Postgres drop unique index statement
Bug: Insert data in Relational Data Browse
Bug: Fix for ZoomIn shortcut on Mac
Bug: Fix PDF documenation with Cyrilic text
Bug: Fix show print page borders in combination with zoom

Feature: Column collation and charset. Configurable in synchronization using Project Settings / Rdbms Settings / Sync column options
Feature: Intoroduce JDBC driver for CSV files. Now listed as 'CSVFiles' database - directly execute SQL over CSV files.
Feature: Support Firebird domains
Feature: Improve dark theme
Feature: Support for Postgres Arrays in Relational Data Browse
Feature: Snowflake fast list databases
Feature: Improve Report a Bug dialog
Bug: MonogoDb insert document
Bug: MySql reverse engineer procedures
Bug: Fix rendering issues in SQL Editor result pane

Feature: Include Apache Ignite Database
Feature: Sybase support multiple databases
Feature: Add description dialog for procedures and functions. Available in right-click pop-up.
Feature: Redesign Forms and Reports
Feature: Reverse engineer collation for PostgreSQL and SqlServer
Bug: Improve synchronization
Bug: Fix threading in schema reverse engineer
Bug: Fix $and statements in MongoDb driver
Bug: Rename index bug crashes script generation
Bug: PostgreSQL reverse engineer indexes with 'order asc'
Bug: postgreSQL 9.x and before reverse engineer identity columns to 'nextval'

Feature: Data generator edit dialog cell notification to press ENTER
Feature: Improve error dialog
Feature: New logic for Views. We store the complete view definition, including CREATE VIEW..., with tags for view and schema name.
Feature: Improve Architect Look & Feel
Bug: SQL Editor / Run Script for SqlServer
Bug: Cassandra and MongoDb reverse engineer with latest JDBC drivers
Bug: SQL Editor error highlight for Redshift
Bug: Layout tooltip moved position after 1 sec
Bug: Copy/Paste in SQL Editor
Bug: Exasol drop functions

Bug: Fix SqlServer schema synchronization issues after adding support for multiple databases. See also the Connection Dialog/Others/Edit Schema Mapping
Bug: Fix export materialized views in Schema / Generate SQL Script
Bug: Fix Mongodb db.collection.count()
Bug: Fix bug in Data Importer for importing tab separated CSV files
Bug: Fix SqlServer add comments on columns
Feature: Improve Welcome screen
Feature: Improve Find Virtual Foreign Keys dialog
Feature: Add table create computed column to Table Dialog.

Feature: Add Apple Notarization required by Mac OS Catalina
Feature: Improvements in SQL Editor / Run Script
Feature: Compatibility improvements for Exasol
Bug: Issue in data type options and saving edited data types from Project / Settings

Feature: Improve column, table and index options
Feature: Support SqlServer multi-database
Bug: Fix Exasol partition and distribution keys
Bug: Fix locking when 'show page borders' was enabled and computer had no configured printer
Bug: For SqlServer show correctly the schemas, triggers and procedures

Feature: Complete migration of DbSchema to OpenJfx and OpenJDK. First version on the market standard technologies and migration to a stable product.
Feature: Add Postgres options for table, column and indexes: collation, tablespaceName and other.
Feature: Update SqlServer and AzureSql driver to