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

DbSchema Changelog

What's new in DbSchema 9.5.3

Apr 25, 2024
  • JDBC driver for CSV Files:
  • Data analysts are often working with CSV files, using Excel or text editors.
  • DbSchema can handle now CSV files in a relational way, so you can visualize and manage multiple CSV files similar with a relational database.
  • To use CSV files, start a new model and using ‘CSV files’ as data source.
  • This will ask for the folder where the CSV files are saved, and load them in DbSchema as tables, with indexes and foreign keys.
  • Behind the scenes, the JDBC driver is loading the data to an H2 database.
  • CSV JDBC Driver:
  • This allows to interact with the CSV files as they would be a relational database. You can explore data in a relational way, write SQL queries
  • and use the Visual Query Editor.
  • To save back the data changes to CSV use the command ‘save csv to ‘.
  • KeyStore tab to the Connection Dialog:
  • In the connection dialog there is now a tab where you can load TLS keys into a keystore. There are two key stores: an authentication keystore and
  • a trust store. These are passed over to Java as system variables
  • java.net.sql.keyStore=<pathToStoreFile>
  • java.net.sql.trustStore=<pathToStoreFile>
  • The keystore files are saved to the ‘.DbSchema/connection/‘ folder in the user home.
  • Copy/Paste tables using SQL:
  • Move or clone tables between different design models using the option Edit / Copy as SQL and Paste as SQL.
  • Other Improvements:
  • Feature: Export documentation always enable ‘Generate’ button. Until now was enabled only when a file was selected
  • Feature: Oracle add FIRST_ROWS hint for browsing large tables
  • Bug: Postgres sync issues for indexes with INCLUDE clause
  • Bug: Postgres reverse engineer columns using domains as data type
  • Bug: Postgres reverse engineer tables using inheritance
  • Bug: Postgres reverse engineer column comments as table comments.
  • Bug: Oracle reverse engineer procedures, triggers and functions body text
  • Bug: Postgres read-only connections do not import FKs
  • Bug: MonetDB wrong class name in the JDBC Driver
  • Bug: Multiple message on duplicate or invalid table or column names
  • Bug: Oracle issues with reverse engineer tables with comments in Chinese. Upgrade the JDBC Driver.

New in DbSchema 9.5.2 (Feb 24, 2024)

  • UI Internationalization:
  • DbSchema UI can show in english, spanish, german, italian, portugese, japanese, and chinese simplified.
  • DbSchema Internationalization:
  • This can be re-configured from Model / Settings Dialog
  • Floating License Server:
  • Floating licenses can be used by teams, when a license can be shared across multiple users.
  • This is more for the cases when DbSchema is used by multiple users in a team, for short intervals to time each.
  • The floating licenses requires installing the floating license server on a separate machine. The client computers will connect to the floating license server.
  • The floating license server can be started from DbSchemaCLI using the command ‘license server’.
  • Manually Start DbSchema PRO Evaluation:
  • In the earlier releases, DbSchema PRO trial was started automatically, after installation.
  • This has created confusion, as the design model was a feature the PRO edition, and as soon as the trial ended this feature couldn’t be used anymore.
  • Now, the PRO trial is started only at the user request, making users aware about this.
  • Improve Relational Data Explorer:
  • Exploring the data from one table will open the table in maximized view. The view can be restored using the maximize button in the upper right corner.
  • Data Explorer Maximized View:
  • Cascading a further table will automatically minimize the table.
  • Data Explorer Cascade Table:
  • Editing table data will show the editor directly into the table. Double-click cells to start editing. Press ENTER with Control pressed to enter new lines of text.
  • Data Explorer Inline Edit:
  • Multiple table cells can be edited simultaneously.
  • Data Explorer Edit Multiple Cells Simultaneously
  • Auto-completion for Java Groovy Scripts
  • DbSchema can automate different tasks using Java Groovy automation scripts. Sample scripts are shown in the Tools menu / Automation Scripts.
  • Scripts can be added in the Automation Scripts dialog under User Defined.
  • User Defined Automation Scripts:
  • You can also open the SQL editor, switch to Java Groovy and edit or execute scripts.
  • Edit Groovy Scripts in the SQL Editor:
  • Now, pressing CTRL-Space a completion menu will show.
  • Java Groovy Auto-Completion:
  • Placing the caret between the method brackets and pressing CTRL-P, the different parameter combination can be listed.
  • Other improvements:
  • Feature: Add method Schema.cloneTable()
  • Feature: Logical design specify column auto_increment
  • Feature: Upgrade Firebird JDBC drivers
  • Bug: Editing foreign key columns was not possible for Pk tables with more than 100 records
  • Bug: Editing column in table dialog, after sorting the columns, would break the sort
  • Bug: Data explorer insert UUID in PostgresSQL
  • Bug: Browse Filter pop-up not showing when the data view is scrolled to right
  • Bug: Different bugs in GIT dialog

New in DbSchema 9.5.1 (Jan 17, 2024)

  • Feature: Improve View reverse engineer using DDL if they have parameters or comments in the view body.
  • Feature: Add Help / Create Article on Blog dialogs
  • Feature: Improve the Report Designer
  • Feature: Improve Dark theme
  • Feature: Upgrade MAC OS certificate
  • Bug: Data Importer always skips first line
  • Bug: UserDataTypes, Functions and Procedures export didn’t work if they contains unescaped Java backslashes ‘'
  • Bug: Export PDF documentation FK arrows
  • Bug: License activation
  • Bug: Postgres reverse engineer schema missing comments in some cases
  • Bug: Fix in Export-Schema-DDL.groovy script
  • Bug: Cassandra not listing keyspaces
  • Bug: Application designer open another page when no value was selected in combo box
  • Bug: Support for OpenSSH new keys. JGit brought a JSch artifact, conflicting with Mwide artifact.

New in DbSchema 9.5.0 (Dec 4, 2023)

  • Feature: Improve license management
  • Feature: First phase of supporting floating licenses
  • Feature: Support for DocumentDB
  • Feature: Improve support for Oracle computed and functional columns
  • Feature: Data conversion rules support for computed and functional columns
  • Feature: Add Automation Scrips to the Logical Design
  • Feature: Cassandra connectivity add entry for SSL
  • Feature: Support for GoogleCloudSpanner with Postgres Dialect. This is showing as a separate entry in the database list.
  • Feature: Configurable max query number of lines
  • Feature: Configurable data generator null percentage
  • Bug: Google Cloud Spanner reverse engineer indexes do not load managed indexes
  • Bug: Reverse engineer fails for schemes with hyphens in names (‘test-schema’)
  • Bug: Sync issue with Postgres Timestamp and Timestmaptz default precision 6
  • Bug: View definition validation when view name contains ${schemaName} or other tags
  • Bug: Boolean and Bit data types
  • Bug: Code review and improvement of handling Input/Output Streams

New in DbSchema 9.4.3 (Oct 24, 2023)

  • Feature: Store database connections in a separate file ‘ ~ /.DbSchema/connections/connections.xml’, configurable in Model / Settings. Passwords are stored encrypted in ‘ ~ /.DbSchema/connections/passwords.xml’.
  • Feature: New function evaluate(…) can be used in CREATE TABLE statement, to dynamically evaluate parameters. Sample CREATE TABLE ${table} ( ${body} ) ${createPartitionEnding} ${createClusterEnding} ${createSortEnding} ${createIndex1Ending} ${evaluete(options)} Where options can be someText${System.getProperty(“test”)}
  • Feature: Support for DuckDB
  • Feature: Export dialog add combo for the file selection
  • Feature: Add Model /Settings parameter to define a custom location to store the DbSchema settings. This allows to share the settings in a team via GIT.
  • Feature: Logical Design table and column options conversion to physical using regular expressions.
  • Feature: Upgrade SqlServer JDBC Driver
  • Feature: Faster Snowflake reverse engineer View columns
  • Feature: Allow executing SQL insert statements with more than 1000 rows.
  • Feature: Make the time limit to trigger auto-refresh after running ALTER TABLE statements configurable
  • Feature: Implement DbSchema Test in Tools / Automation Scripts.
  • Feature: Automation Scripts can be executed directly in the Tools / Automation Scripts dialog
  • Feature: Improve Data Explorer insert components
  • Bug: SqlServer issue in reverse engineer with Foreign keys using columns with spaces or dots.
  • Bug: Exception in Grid Editor
  • Bug: Issue in Logical Design Naming Conversion
  • Bug: Temporary issue with printing the data types
  • Bug: SQL Editor open multiple files from one editor menu is using the wrong files.
  • Bug: Default value conversion dialog not working.
  • Bug: SQL Editor auto-completion include SELECT, UPDATE statements.
  • Bug: Postgres reverse engineer User Defined Types created in another schema
  • Bug: SQL Editor caret move left-right go to the next line
  • Bug: Postgres reverse engineer varchar[] and timestamp(precision)

New in DbSchema 9.4.2 (Sep 16, 2023)

  • Feature: Data Governance Dialog
  • Feature: Oracle table option for partitioning
  • Feature: Option to export data including auto-increment columns
  • Feature: SQL Editor add area selection with Alt key
  • Feature: Upgrade MySql, MariaDb, H2 and PostgreSQL JDBC Drivers
  • Feature: PostgreSQL use DDL to reverse schema from the database. Use Model / Settings / Show Reverse Engineer DDL to see the statements in the Help / Output Logs.
  • Feature: GIT dialog, add fields for author name and email in the commit pane
  • Feature: Upgrade Snowflake JDBC Driver
  • Feature: Include Synchronization Pre an Post scripts in the Commit Dialog scripts
  • Feature: Support TimescaleDB
  • Bug: Links in markdown documentation
  • Bug: Create statement on foreign keys shows an empty script
  • Bug: GIT revision date is incorrect
  • Bug: Postgres reverse engineer unique indexes/constraints
  • Bug: Commit schema changes dialog, when pressing the ‘Skip’ button

New in DbSchema 9.4.1 (Aug 4, 2023)

  • Feature: Improve GIT dialog. Add commits tree representation. Fixes for pull, push and conflicts solving.
  • Feature: HBase new JDBC drivers
  • Feature: CSV Editor add ~ delimiter
  • Feature: Databricks add support for STRUCT, ARRAYS
  • Feature: Documentation dialog has an option to export layouts having a comment tag ‘documentation’
  • Feature: Databricks support for Unity Catalog
  • Feature: Rename DbShell into DbSchemaCLI (Command Line Interface)
  • Bug: MSAccess BOOLEAN as YESNO, comments are not supported.
  • Bug: Markdown SVG encoding issue
  • Bug: Sync issue with Foreign keys shown as missing
  • Bug: SqlServer correct reverse engineer unique constraints vs unique indexes
  • Bug: Table sort in HTML5 documentation
  • Bug: GIT improve authentication mechanism
  • Bug: Azure issues with USE command, when listing the schemes and catalogs
  • Bug: DDL Parser SqlServer references FKs.
  • Bug: Redshift fixes for distkey.
  • Bug: Databricks rename column, partition key
  • Bug: GIT Clone a fresh repository error
  • Bug: GIT use SSH private key file and paraphrase

New in DbSchema 9.2.2 (Apr 12, 2023)

  • Features:
  • Improve data generator repository. The data generator has an option to generate data to SQL File.
  • Renaming a column in the offline mode and logical design will rename also the columns bind by foreign keys.
  • Sqlite improvements in creating foreign keys
  • MySql generated columns disable mandatory field
  • Bug Fixes:
  • Create or edit indexes exception
  • Editing tags activate the save button
  • MySql text default length 65535
  • Editing pattern in Data Generator
  • Data Explorer, hidden columns showing again on cascaded tables
  • SqlAnywhere and SAPHana fixes in reverse engineer

New in DbSchema 9.2.1 (Jan 24, 2023)

  • Improve Logical Design
  • Show Database Objects in the Project Structure
  • Improve HTML5 Documentation
  • ‘SQL’ Button to Table Dialog
  • Feature: Improve Data Loader
  • Feature: MongoDB support for SSL connections
  • Feature: CSV Editor memory optimizations
  • Feature: Triple-click in SQL Editor select line
  • Feature: Show triggers under the table structure
  • Feature: Increase text sharpness in diagram
  • Feature: Improve GUI font and contrast
  • Bug: Data Loader date format issue
  • Bug: SqlServer reverse engineer foreign keys between different schemes

New in DbSchema 9.2.0 (Dec 12, 2022)

  • Feature: Remove group gradients
  • Feature: HTML5 documentation - add tags to text comments
  • Feature: Improve HTML5 documentation look
  • Feature: Upgrade Google Cloud Spanner JDBC Driver
  • Feature: Configurable time for deducing view columns in Model / Settings / Reverse engineer.
  • Feature: PostgreSQL, Oracle load number of rows per table
  • Feature: Improve the Reports Designer
  • Feature: Improve Dark theme
  • Bug: Adding multiple tags to tables or columns
  • Bug: Snowflake does not reverse engineer view definition
  • Bug: HTML5 Documentation when the schema, table, or column name includes <, >
  • Bug: SqlServer computed columns skip the NULL keyword
  • Bug: Driver Management dialog not showing classes without URLs

New in DbSchema 9.1.1 (Nov 9, 2022)

  • Result Pane:
  • Add icon in Result Pane cell to show large text cells in PopOver
  • MongoDB:
  • MongoDB collection flag for virtual (no validation rule) and also symbol in the diagram.
  • Setting it will skip implementing validation rules.
  • Import Model from External Formats:
  • Add Dialog to import model from CSV file. See Model / Load from External Format.
  • Dark Theme:
  • Improve Dark theme.
  • Other Features and Bug Fixes:
  • Feature: Project Structure expand by default only the first schema
  • Feature: Refactor SQL and JSON indentation (Ctrl-I in SQL Editor)
  • Feature: Add search field in Automation Scripts Dialog
  • Feature: Add data type auto-match patterns to the Model / Settings / Database Specific / Data Types. Used to match newly created column names and auto-select the data type.
  • Feature: Auto-disable diagram shadow when the rendering is slow.
  • Feature: Change tab traversal policy in the Column Dialog.
  • Bug: In MongoDB Query Builder

New in DbSchema 9.0.4 (Oct 10, 2022)

  • Query Builder:
  • Thanks to JavaFX configurable CSS look, we were able to improve our look and feel.
  • MongoDB Query Builder:
  • Improvements for JSON documents. Query Builder use joined routing and show data type
  • Also improvements for MongoDB and better handling of large documents.
  • Diagram performance improvements:
  • Diagram routing and drawing works faster.
  • Logical and Physical Design:
  • We introduced the data type and naming dictionaries.
  • Data Type Conversion Dictionary
  • GIT Dialog:
  • The GIT dialog has improved. It has options to compare the model from two revisions, or generate the change audit log from multiple revisions.
  • Other Features and Bug Fixes:
  • Feature: Thread improvements for diagram routing
  • Feature: Upgrade SSH and internal libraries
  • Feature: SQL Syntax fixes for GoogleCloudSpanner
  • Feature: Edit / Show Schema name will show it also in the Foreign key tooltips and documentation
  • Bug: Editing existing connection the URL is not loaded

New in DbSchema 9.0.0 (Apr 12, 2022)

  • Logical Design:
  • DbSchema supports logical design. The logical design is database-independent, with entities and sub-entities:
  • Logical Design Sub-Entities:
  • Sub-entities can be created by adding a field of type sub-entity to a table.
  • There are also supported different relation types:
  • Logical Design Relations:
  • The logical model can be converted to a physical model and synchronized with the database.
  • We continue to improve the logical design also in the upcoming releases.
  • Reverse engineer using DDL:
  • In the previous versions, we reverse-engineer the schema by reading the metadata from system tables.
  • For most of the databases, we call methods from the JDBC driver, and only for a few of them did we execute direct queries on the system tables.
  • Now, we are using a DDL parser that can reverse engineer the schema from the CREATE TABLE DDL statement.
  • The DDL is generated using commands like ‘Show create table’, or using a dedicated procedure (SqlServer).
  • Comment Tags:
  • Besides text, the table, column, and foreign keys can use key/value comment tags.
  • The tags can be used in the automation scripts, and in the logical design for the entity or field’s physical name.
  • Reverse Engineer Using DDL:
  • This allows us to reverse engineer all parameters, like collation, partition keys, etc., and more table-specific parameters - like temporal tables, etc.
  • This feature is available for all databases where we found a way to generate the table DDL.
  • Here are the current databases where this feature is implemented:
  • MySql, MariaDb, Oracle, SqlServer, AzureSQL, Snowflake, Redshift, Vertica, Sqlite, Exasol, SAPHana, GoogleBigQuery, Databricks, Cassandra
  • Improvements for MongoDB
  • We do diagrams and schema validation rules for MongoDB. Whenever a validation rule is defined, we reverse engineer the collection structure using it.
  • If not, we deduce the collection structure by introspecting a few documents.
  • Whenever you design a collection, the collection validation rule gets updated.
  • Automation Scripts for generating HTML or PDF Documentation:
  • We added more parameters for generating the HTML or PDF documentation.
  • Therefore we created a more flexible method in Java. Please have a look on the DbSchema API for details.
  • Further improvements:
  • Feature: Result Pane error message as dialog
  • Feature: InfluxDB integrations
  • Feature: PDF documentation, add parameter for skipping tooltip comments. Improve look.
  • Feature: Add more options to the documentation dialog
  • Feature: Exasol support hashtype data type
  • Feature: Color picker editable hex value
  • Bug: Fixes and improvements in the DDL Parser
  • Bug: MongoDB load statement using the driver class loader. This solves issues with ObjectId.

New in DbSchema 8.5.0 (Jan 10, 2022)

  • CSV Editor for Large Files:
  • DbSchema include now a CSV Editor for large files. The editor can open files up to 500 million of records, depending on the record size
  • Analytic Applications:
  • The DbSchema Reports was renamed to Analytic Applications. The designer was improved.
  • Now it is more easy to create charts.
  • New Look:
  • We improved our default theme.
  • Other improvements:
  • Feature: Snowflake connection using private key
  • Feature: Implement functions, procedures and trigger comments into the database
  • Feature: Right-click copy to clipboard message dialogs
  • Feature: Oracle use GENERATED AS IDENTITY
  • Feature: Groovy scripts rename com.wisecoders.dbs.diagram.model.Location to com.wisecoders.dbs.diagram.model.Point
  • Bug: MongoDb rename collections and objects
  • Bug: MongoDb use ‘int’ instead of ‘integer’ data type
  • Bug: Query Builder exclude table won’t remove it from the generated SQL
  • Bug: HTML5 documentation fix special character
  • Bug: Fix unreadable red error message in result pane
  • Bug: Improve connectivity layer, for better code and correctly closing the SQL dead statements
  • Bug: Fixes in SQL Parser
  • Bug: Snowflake support varchar() without length
  • Bug: Vertica reverse engineer table and column comments

New in DbSchema 8.4.5 (Nov 11, 2021)

  • Reverse Engineer using DDL:
  • This feature allows reverse-engineering the schema by parsing the CREATE TABLE DDL statements.
  • This is available now for MySql, MariaDB, Oracle, Redshift, Snowflake, Sqlite, and Vertica.
  • Enable this option from the Database Selection Dialog, shown before the Connection Dialog.
  • The same option can be enabled from ‘Model /Settings / Reverse Engineer’.
  • Pan and Zoom HTML5 Database Documentation:
  • Zoom the HTML5 diagram vector image using CTRL + mouse wheel and pan (scroll ) by dragging the image using the right mouse button.
  • Detect Virtual Foreign Keys:
  • When the database does not contain foreign keys, DbSchema can create virtual foreign keys. The virtual foreign keys will be saved in the model file, without creating them in the database.
  • In the Layout menu, you can find a dialog that will automatically detect virtual foreign keys.
  • There are two methods to detect them:
  • By matching columns by names
  • By parsing the SQL statements from the database history cache for SELECT statements with JOINS. The joined columns are used for creating virtual foreign keys.
  • Matching columns by name is usually searching first for the primary keys, and trying to find other columns and data types in other tables, with the same name.
  • Databases like Snowflake have no Primary Keys. In this case, you can disable the ‘Referred Column is Primary Key’ checkbox.
  • Save Results as JSON:
  • In the SQL Editor Result Pane, there is an option to save the result as JSON.
  • Other Improvements:
  • Feature: HTML5 generates documentation using Groovy has one more method in Layout.
  • Feature: Improve PDF documentation
  • Feature: Introduce wizard in Reports sub-tables
  • Feature: The format used in browse and SQL results for numbers is configurable from Model / Settings / DbSchema General
  • Feature: Upgrade to JavaFX 17
  • Feature: Upgrade MongoDB JDBC Driver libraries
  • Bug: Disable column reordering for Sqlite, which creates issues in metatable.
  • Bug: Fix issue when refreshing the model and foreign key should be dropped in the database.
  • Bug: SQL text indentation issue

New in DbSchema 8.4.4 (Sep 6, 2021)

  • Stability and design improvements

New in DbSchema 8.4.2 (Jul 27, 2021)

  • New SQL Parser:
  • DbSchema can deduce the schema structure and diagrams by parsing SQL scripts from the file.
  • Then you can use DbSchema to document the model, edit it, create new layouts, or deploy it on different databases.
  • DbSchema 8.4.2 has a new SQL Parser, which is much more flexible. It can parse all database scripts, including Snowflake, SqlServer, Postgres, MySql, Oracle, with partition indexes, sorting, and clustering specifications.
  • Please write us if you find any statement which is not correctly parsed.
  • Markdown Database Documentation
  • DbSchema can export now documentation in Markdown format.
  • Reports Designer:
  • We redesigned the reports designer. You have to press the Design button to edit the report. Then you can click any cell to edit or create a component.
  • We got less feedback about the reports designer, please write us about your experience with it! Together we can make it a very powerful tool.
  • Other Features:
  • Feature: Prepare code for implementing Logical Design using DbSchema
  • Feature: Sqlite supports renaming columns
  • Feature: Hive - fix add & drop column, cluster, partition and skew keys
  • Bug: MySql & MariaDB datetime and timestamp precision
  • Bug: Reverse engineer Postgres functional columns.
  • Bug: Export data on large tables for more than 10k rows.
  • Bug: Postgres drop column cascade
  • Bug: Fix Elasticsearch JDBC URL

New in DbSchema 8.4.1 (Mar 18, 2021)

  • Implement Mongodb Validation Rules:
  • Validation rules are used to ensure a collection has a given structure.
  • All inserts and updates into a collection should match the validation rule.
  • Validation rules:
  • When creating a new collection or field, DbSchema will also implement the validation rule.
  • Reverse engineering the schema will deduce the schema from the validation rule, if a validation rule is available.
  • Add SqlServer Fulltext Index.
  • Include role in Snowflake connection:
  • Sometimes, connecting to Snowflake you will see no tables in DbSchema.
  • In this case you may need to set a role in the connection.
  • Other Features:
  • Feature: Use System Proxies by default
  • Feature: Include role in Snowflake connection
  • Feature: Improve dark theme
  • Bug: SqlServer comments in multiple databases
  • Bug: SqlServer identity synchronization issue

New in DbSchema 8.3.4 (Dec 14, 2020)

  • Launch DbSchema Analyst BI:
  • Analyst BI is a tool for creating charts and database reports.
  • Improve SQL editor color scheme and rendering:
  • The color schemes has changed.
  • Support MonetDB:
  • DbSchema can connect, reverse engineer schema and manage MonetDB databases.
  • Bug in Relational Data ExplorerZ:
  • Fix problem with resizing columns in Relational Data Explorer.
  • Improve space in the Synchronization dialog:
  • Improve space in the Synchronization dialog.

New in DbSchema 8.3.3 (Nov 5, 2020)

  • Launch DbSchema Free Version:
  • We created two DbSchema Editions: Free and Pro. There is a single download package, which will start the Free edition after download. From the menu you can choose to evaluate the Pro Edition.
  • Improve the Relational Data Explorer:
  • Better editing functionalities, improve menu, table header more compact.
  • Integrate ThoughtSpot Database:
  • This is a new database that we added to our list.
  • Trebuchet MS Diagram Font:
  • Now we use Trebuchet MS font for diagrams.
  • HTML5 Documentation:
  • Add option to generate documentation images in separate SVG files.
  • Upgrade OpenJDK and OpenJFX Libraries:
  • Upgrade to OpenJDK 15 and OpenJFX 15.0.1
  • Sqlite autoincrement:
  • Sqlite reverse engineer column autoincrement
  • Connection Properties. Support Oracle Kerberos Authentication:
  • We added a field to the Connection Dialog for setting connection properties. This is used for example by Oracle Kerberos Authentication.
  • Redesign Forms and Reports:
  • The Forms and Reports designer will work directly over the generated form or report. We are working to add charts to the designer. In the next versions we will create a powerful BI tools out of it.
  • Bug Fixes:
  • Generating PDF with TOC fix error
  • SSH Tunnel conflict with local running database.
  • Relational Data Explorer when foreign key is over multiple columns.
  • Data loader on large files may wrong evaluate the MANDATORY (not null) for new tables. Therefore we create all columns as nullable.
  • SQL Editor issues with Japanese text
  • Column dialog default value automatic add comma bug

New in DbSchema 8.3.2 (Sep 28, 2020)

  • Feature: Improve connection dialog. Now can choose to build URL automatic or manual.
  • Feature: PDF comments are easier to read
  • Feature: Integrate Azure Synapse
  • Feature: Integrate TimescaleDB
  • Feature: Support for MongoDb Views
  • Feature: SQL parser can deduce schema also from SQL Select statements. The Groovy scripts to start the parser has changed.
  • Feature: MongoDB virtual foreign keys work also from/to sub-documents.
  • Feature: Improve appearance
  • Feature: Support Postgres Constraints 'DEFERREABLE' and 'INITIALLY DEFERRED'
  • Feature: Migrate to latest SqlServer, PostgreSQL and MySql JDBC drivers
  • Feature: Add Schema / Sync Settings dialog, with DDL pre/post scripts and sync filter. Pre and post scripts are migrated from local settings to project.
  • Feature: Add Groovy Code Samples Dialog. Accessible from SQL Editor menu and Sync Settings Dialog.
  • Feature: Improve Data Export Task for better compatibility with all databases
  • Bug: Save the model file in the same folder as the one where it has been open
  • Bug: Issue when generating PDF documentation
  • Bug: Postgres reverse engineer timestamp
  • Bug: Postgres reverse engineer identity columns

New in DbSchema 8.3.1 (Sep 9, 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

New in DbSchema 8.3.0 (Aug 6, 2020)

  • Feature: HTML5 and PDF documentation omit description column if empty
  • Feature: Improve look on scaled monitors
  • 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 Random Data Generator for faster data insert.
  • Feature: Connection dialog, the JDBC URL is editable directly in the first tab.
  • 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 Random 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.

New in DbSchema 8.2.12 (Jul 3, 2020)

  • Feature: Improve MongoDb support for ISODate()
  • Feature: Improve reverse engineer selection dialog
  • Feature: Improve virtual foreign keys dialog
  • Bug: Fix flickering tooltip on icons

New in DbSchema 8.2.12 (Jul 3, 2020)

  • Feature: Improve MongoDb support for ISODate()
  • Feature: Improve reverse engineer selection dialog
  • Feature: Improve virtual foreign keys dialog
  • Bug: Fix flickering tooltip on icons

New in DbSchema 8.2.11 (Jun 24, 2020)

  • 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

New in DbSchema 8.2.10 (May 6, 2020)

  • 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

New in DbSchema 8.2.8 (Mar 3, 2020)

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

New in DbSchema 8.2.7 (Jan 28, 2020)

  • Feature: Random 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

New in DbSchema 8.2.6 (Jan 28, 2020)

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

New in DbSchema 8.2.5 (Dec 17, 2019)

  • 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
  • Bug(Minor): Copy /Paste in SQL Editor find/replace bar
  • Bug(Major): Closing Frame threading issue may lock the application lock

New in DbSchema 8.1.7 (Jun 25, 2019)

  • Bug: fix 'null' in Export data from database dialog
  • Feature: Improve Schema Mapping Dialog
  • Feature: Improve table auto-arrange code
  • Feature: Add DbSchema/config/appearance/user.css where look and feel css properties can be edited
  • Feature: Migrate MongoDb JDBC driver to Gradle and mongo-java-driver:3.10
  • Feature: Merge Connection/Rdbms Settings Dialog in Project/Settings Dialog
  • Feature: Improve Foreign Key Dependency Dialog
  • Bug: Clone table clone also foreign keys
  • Bug: fix in Data Loader date format
  • Bug: JSqlParser correct handle quoted table and column names
  • Bug: Fixes for Random Data Generator - Fk Generator

New in DbSchema 8.1.6 (May 17, 2019)

  • Feature: Create Virtual Foreign Keys dialog. Virtual foreign keys can be deduced by parsing the cached SELECT statements from the database and looking for JOINS. A new dialog is now available under Layout/Manage Virtual Foreign Keys
  • Feature: Add navigation text field and history to Help Dialog
  • Feature: Add Virtual Data Type. This allows defining columns using a virtual type, and change real type for each database.
  • Feature: Improve in Look & Feel
  • Feature: Refactor code and obsolete more old Swing Classes. DbSchema Java API has changed.
  • Feature: Migrate DbSchema API JavaDoc to Gradle and generate new Documentation
  • Feature: Document view columns in HTML5 documentation
  • Feature: Improve validity checks for Foreign Keys and Constraints in UI
  • Feature: Support Primary key specification for one column PK among the column definition
  • Bug: Fix Postgres GENERATED ALWAYS AS IDENTITY statements

New in DbSchema 8.1.5 (Apr 19, 2019)

  • Feature: Release DbPrompt Version 1.0 Beta. Free-multi-database console featuring simultaneous query execution, Groovy scripts, cron jobs, error reporting and more. Details on https://www.dbschema.com
  • Feature: Advanced menu on clicking Fk icon near columns. Pressing the icon with CTRL pressed may jump to referring/referred table in other layouts
  • Feature: Add Unicode font to Pdf generator (support for Asian text)
  • Feature: Add Copy to clipboard for SQL result pane
  • Feature: Improve schema synchronization. New dialog for managing renamed tables, columns..., so we can better match them during synchronization.
  • Feature: Improve UDT support for Cassandra. Show User Defined Types with columns in diagrams.
  • Feature: Add icon for MongoDb and Cassandra map and array column lists.
  • Feature: Implement Undo/Redo in Diagram Pane
  • Feature: SQL editor / Groovy scripts can run in offline mode
  • Bug: fix database combo not listing databases
  • Bug: fix flickering tooltips on tip labels and checkboxes
  • Bug: thread issue in ResultPane causing cells to show as null
  • BUg: Redshift fix commit after select

New in DbSchema 8.1.4 (Apr 19, 2019)

  • Feature: Improve Random Data Generator interface and documentation
  • Feature: Improve Default Look and Feel
  • Feature: Improve PDF documentation
  • Feature: Add TOC (list of tables) option to the documentation
  • Feature: Add SqlServer encrypted connection URL
  • Feature: Improve Data Loader
  • Feature: Improve Quick Tour
  • Bug: Reduce PATH on DbSchema.exe. This was creating issues on computers where old Java versions were present in the PATH.
  • Bug: SQL code editor copy/paste remove non-printable charachters
  • Bug: Fix bug with ToDo Flags in Diagram
  • Bug: Fast preview popup not working on Windows

New in DbSchema 8.1.3 (Mar 15, 2019)

  • Feature: Look and Feel improvements, for Default and Dark theme
  • Feature: Do not list SqlServerDriver when DbSchema runs on Mac or Linux.
  • Feature: Cloning columns will create new column as nullable to avoid problems if the table contains data.
  • Feature: Clicking browse frame header will show the filter/sort popup.
  • Feature: Upgrade Derby JDBC driver
  • Feature: SQL result pane show tooltip on column headers
  • Feature: Implement 'Toggle Case' in SQL Editor
  • Feature: Sort data types in Column Dialog
  • Feature: Support derby data type 'varchar() for big data'
  • Bug: Fix SqlServer time precision to range 0-7.
  • Bug: Query Builder filter on booleans(bit data type) use 1 instead of true.
  • Bug: Connectivity port and driver fixes for Frontbase.
  • Bug: SQL Editor - display hidden characters (non-printable unicode characters).
  • Bug: Threading issue on rendering diagrams. This could have caused locking problems.
  • Bug: SQL result pane - fix threading issue
  • Bug: Fix directory chooser for Derby create new database
  • Bug: Fix view synchronization issue

New in DbSchema 8.1.2 (Feb 9, 2019)

  • Feature: Dynamic printing resolution, keeping track on available video memory
  • Feature: Navigation buttons in HTML and PDF documentation for multiple layouts documents
  • Feature: Update SqlServer and Azure JDBC drivers to 7.0.0. This may create issues, please write us on Technical page for support.
  • Bug: Pdf Documentation scan for bad encoding characters
  • Bug: Relational Data Browse - fix 'Edit Cell to NULL'
  • Bug: Work on stability of JavaFx threading. Bug affects the application stability
  • Bug: Fixed drag and drop of one or multiple columns over other column to create foreign key or over table header to clone columns
  • Bug: Database Driver Manager - save edited URL is fixed.

New in DbSchema 8.1.1 (Feb 9, 2019)

  • Refactor PDF documentation generator. Migrate from iTextPdf to Apache PdfBox
  • Increase TipLabel hide timeout to 1 min
  • Fix Cassandra Primary Key statements
  • New patterns in Random Data Generator - Groovy object patterns and vehicle VIN
  • Update Cassandra JDBC driver
  • Various bug fixes
  • Upgrade JavaFx libraries

New in DbSchema 8.1.0 (Feb 9, 2019)

  • The Mac OS crash issue is now solved. New JavaFx libraries fixed it.
  • Improve Quick Tour and system messages

New in DbSchema 8.0.11 (Dec 17, 2018)

  • Generate interactive PDF documentation. Move the mouse over diagram table and columns to read schema comments.
  • Improve Printing : better quality, show print dialog, remember page settings
  • MAC CRASH BUG: There is a bug in Java, which leads to application crash with an 'NSInternalInconsistencyException'. We reported this to Java team, they will fix it mid January. There is no fix for this, eventually please downgrade to DbSchema 7 (see the archive link on download page).
  • Improve connection dialog
  • Bug fix in SQL Editor - running some SQLs would never finish
  • Disable aliases in Cassandra Query Builder
  • PLEASE REPORT BUGS AND FEATURE REQUESTS. We are focusing now to get a stable DbSchema 8.2 version, any feedback on [email protected] is appreciated.

New in DbSchema 8.0.10 (Nov 19, 2018)

  • Move project to Gradle
  • Support for Java 11
  • Dark look and feel improvements

New in DbSchema 8.0.9 (Oct 19, 2018)

  • Improve application alerts ( information, warning, error )
  • ix bug on right-click table and 'Refresh from Database'
  • Improve Connection Dialog
  • Fixes for MongoDb
  • Improvements in Forms and Reports

New in DbSchema 8.0.8 (Oct 2, 2018)

  • Implement column aliases in Query Editor
  • Improve Forms and Reports
  • Show Quick Tour dialog as pane when the application is started for the first time
  • Update Font Awesome icons
  • Upgrade Groovy to version 3.0
  • Test and fix automation using DbSchema ( DbSchema -x script.groovy )
  • Improve connectivity tips in the Connection Dialog
  • Bug fix in SQL Editor text pane
  • Use gradient background for diagrams. Is better for large monitors. Also improve Welcome pane look.
  • Bug fix related to closing layout.
  • Bug fix with drag and drop large tables.
  • Bug fix in using Date filters in Query Builder.

New in DbSchema 8.0.7 (Sep 11, 2018)

  • Relational Data Browse, fix editing of Timestamps and Date
  • Improve Browse Arrow between tables
  • Connection dialog got a distinct tip label, on top of driver combo
  • SQL Editor - improve shortcuts indent, un-indent, word selection
  • Improve connectivity tips and Help
  • Add Shortcut Manager dialog to main menu and each tool menu
  • Fix bug related to error highlighting in SQL Editor
  • Add find field to Import Schema Selection Dialog
  • Improve Azure schema reverse engineer
  • Query Editor fix on editing filters
  • Forms and Reports edit cell as a pane, no separate dialog
  • Tabs can be reordered by drag&drop layouts, sql editors, browse, etc.
  • New JDBC driver for OrientDb

New in DbSchema 8.0.6 (Aug 6, 2018)

  • Embed Java 10.0.2 in Windows and Mac installer
  • Improve drag and drop to Relational Data Browse
  • Upgrade JDBC drivers: Access, Hive. We are happy for any feedback about issues with them.
  • Disable 'Generated as identity' setting in Edit /Rdbms Settings for Postgres 8 and 9
  • Improve driver combo title: the connection method is bold
  • Fix Help and Tips and Tricks dialogs to show in a Stage, preventing some display issues.
  • Main frame remember last open position and size
  • New Firebird and GoogleBigData drivers

New in DbSchema 8.0.5 (Jul 23, 2018)

  • Fix installer for correct requirements on Java 10 or 9
  • Various bug fixes

New in DbSchema 8.0.4 (Jul 23, 2018)

  • Complete remove Swing. All components are JavaFx.
  • Various bug fixes. Complete migration to JavaFx.
  • Move application Help to DbSchema website
  • Fix installer for Java 9

New in DbSchema 8.0.3 (Jun 15, 2018)

  • Paint layout speed improvements.
  • Bug fix in Forms and reports
  • Different fixes for create foreign keys
  • Increase graphic memory for high resolution monitors

New in DbSchema 8.0.0 (May 29, 2018)

  • Complete migration to JavaFx. Advantages of JavaFx:
  • Latest technology standard
  • Better look, support for dark theme
  • Integrated WebBrowser

New in DbSchema 7.6.6 Build 4908 (Mar 21, 2018)

  • THIS RELEASE IS FOCUSED ON JAVAFX, WHICH WILL BE EFFECTIVE IN THE NEXT RELEASE.THIS IS A TECHNOLOGICAL UPGRADE WITH ADVANTAGES FOR A BETTER USER INTERFACE, WITH SUPPORT FOR DARK APPEARANCETHIS WILL ENABLE US ALSO DEVELOPING POWERFUL TOOLS FOR DATA ANALYSIS AND BUSINESS INTELLIGENCE
  • Minor bug fix in Relational Data Browse
  • Add parameter LITERAL_PARAMS=true for Sybase JDBC url. This allows executing queries with 'value=?'.
  • Add message if JavaFx is missing
  • Add Rdbms CTreeAce

New in DbSchema 7.6.5 Build 4906 (Mar 21, 2018)

  • START MIGRATING CODE TO JAVAFX. We hope to have first the SqlEditor done, then develop a module for Data Analytics ( Business Intelligence ) under JavaFx.Further-on all modules will be migrated.The current version requires Oracle Java with JavaFx.
  • Forms Multirow Sheet from ControlsFx
  • Video Presentation: General, Relational Data Browse, Query Builder, MongoDb
  • Google Plus and Facebook
  • Exasol Graphs
  • Views sync ( no name )
  • Computed columns SqlServer
  • Bug fix in saving text configuration
  • SqlServer fix for reverse engineer sequences

New in DbSchema 7.6.4 Build 4896 (Nov 21, 2017)

  • SqlServer : add custom query to reverse engineer foreign keys much faster
  • SqlServer / Jtds driver / add Instance parameter to default URL
  • SqlServer: Bug fix related to clustered indexes
  • SqlServer: added support for computed columns
  • SqlServer: add instance to default connection string
  • Firebird: added Advice for fixing Wire Encryption in Jaybird 3
  • Cassandra: support for reverse engineer User Defined Types
  • Cassandra: bug fix for reverse engineer indexes
  • MongoDb: Error highlight in Query Editor
  • Layout: Auto-generate virtual foreign keys option under the Layout menu
  • Layout: Improve table auto-arranger
  • Random Data Generator: add seed setting for each columns. Two columns can be then set to use the same values.
  • Reverse Engineer: Bug fix related to index reverse engineer
  • Forms and Reports: Fix bug related to generated WAR
  • Synchronization: Fix bug with comments on Foreign keys
  • Diagram: improve foreign key line routing - less line intersections
  • JDBC Drivers: download drivers from repository fix for accepting certificates
  • Forms and Reports: fix bug for master-detail reports

New in DbSchema 7.6.0 Build 4755 (Jul 26, 2017)

  • Improved SQL script execution. Now aware on Mysql 'delimiter $$', Postgres 'do $$', Oracle 'declare .... /'
  • Changed SQL Editor shortcuts. Run Query : Ctrl-Enter, Run Script: Ctrl-Shift-Enter
  • Fix reverse engineer of Postgres smallint and functions. Functions are now shown under 'Procedures' as driver works like this.
  • Add repeatable 'Print Stack Trace' in Help / Output logs
  • Improvements for HTML5 documentation: better Fk higlight for IE, improve table comments
  • Update Cassandra JDBC driver to native driver 3.3.0

New in DbSchema 7.5.2 Build 4725 (Jun 30, 2017)

  • Reverese engineer Functions and procedures parameters.Now dropping functions will work correctly for Postgres.Also multiple functions with same name but different parameters are handled correctly.
  • Improve edit mode in Relational Data Browse
  • Show executed SQL in SQL Result pane combo
  • Improve look of Forms Designer and foreign key names in diagram
  • SqlServer connectivity: added more connection strings for the native driver and sqljdbc_auth.dll is automatically installed.
  • Higer JSqlParser library version will improve parsing of SQL scripts* Bugs
  • Fixes for SQL autocomplete
  • Pre-select default printer in print preview dialog
  • Capture from UI Structure Tree exceptions
  • Fix AmazonRedshift data types

New in DbSchema 7.5.1 Build 4690 (May 30, 2017)

  • New driver for Access ( 4.0.2 )
  • HTML5 documentation: clicking table name in text documentation will jump to SVG image
  • Access: add statements for creating foreign keys, ignore index and fk renaming
  • Interbase integration: connectivity, data types, SQL statements
  • Improve forms designer menu
  • Upgrade embedded Java to 1.8.131* Bugs
  • Relational Data Browse issue when editing Timestamps
  • Cassandra bug on relational data browse

New in DbSchema 7.5.0 Build 4679 (May 8, 2017)

  • Implement Database Manager Launcher ( see Forms / Database Manager, now for Postgres and MySql )
  • Improvements in SQL autocomplete
  • SqlServer bug in storing comments larger then 30 chars
  • Switch MongoDb default diagram notation to Barker
  • Fix bug regarding save of MongoDb groups
  • Add percent_true parameter to boolean random data generator.
  • Improve MongoDb Random Data Generator
  • Configurable colors for production, development and test connections

New in DbSchema 7.4.13 Build 4606 (Mar 7, 2017)

  • Space Manager for MySql ( Apps / Space Manager )
  • Improvements for MongoDb. First time reverse engineer will show an Query Editor.
  • Bug fix in Synchronization pane
  • Fixes in Cassandra JDBC driver for getTime(), getTimestamp(), getDate()
  • Add random data generator pattern for UUID
  • Bug fix in saving CSV sheets headers
  • Integrate HBase into DbSchema
  • New drivers for Informix

New in DbSchema 7.4.12 Build 4586 (Feb 7, 2017)

  • Postgres Space, Permission and Activity Manager Applications ( under App menu )
  • Forms final migration from Swing to JavaFx
  • Include OrientDb
  • New Oracle drivers
  • Fix bug: refresh view columns when view changed
  • Add support for SqlServer clustered indexes
  • Add history button in connection dialog
  • Bug fix regarding loaded projects after dropping a schema

New in DbSchema 7.4.11 Build 4572 (Jan 14, 2017)

  • New Look and Feel
  • Added JavaFx run mode in Forms and Reports
  • Use distinct color for Virtual Foreign Keys ( or relations for MongoDb )
  • First tests with JavaFx
  • Configurable HTML documentation logo
  • Various Bug fixes

New in DbSchema 7.4.8 Build 4516 (Oct 31, 2016)

  • added Sybase jconn4.jar Jdbc driver
  • bug fix in forms and reports encoding
  • workaround for MongoDb columns and embedded documents

New in DbSchema 7.4.7 Build 4510 (Oct 12, 2016)

  • Updates many JDBC drivers to recent versions
  • New option in Edit / Configuration for disabling number grouping ( dots used at thousands, etc. ).
  • Added Schema / Synchronization Filters. Use custom Java code to reject certain Sync differences. For example always reject diffs based on table or column name.
  • HTML5 mouse over effect changed to text-shadow
  • Bug related to display of Lists fields in MongoDb
  • Support for SnappyData analytics db
  • FoxPro, Db2 bug fixes

New in DbSchema 7.4.6 Build 4493 (Sep 14, 2016)

  • Fix issues with schema compare and synchronization

New in DbSchema 7.4.5 Build 4470 (Sep 14, 2016)

  • Added Hive to supported databases ( Hadoop )
  • Reduced CPU usage
  • Schema sync and compare uses now Groovy. This gives more flexibility in writing Alter table statements.
  • Fixed bugs in schema sync and compare

New in DbSchema 7.4.4 Build 4470 (Aug 10, 2016)

  • Cassandra:
  • Added support for partition key, clustering keys, ordering in clustering keys.
  • This can be set when the table is created.

New in DbSchema 7.4.2 (Aug 10, 2016)

  • SQL Parser:
  • Added capability in SQL editor to load schema directly from SQL text, by parsing the script.
  • Option is available in after opening an SQL file or from SQL editor menu.
  • Postgres Manager:
  • Added PostgreSql database management interface for managing database roles, permission and space usage overview.
  • The manager is developed in DbSchema forms designer and is open source.
  • We will continue adding interfaces for all databases, next one will be MySql.

New in DbSchema 7.0.0 Build 4206 (Jun 2, 2015)

  • Release Version 7 : Forms and Reports engine

New in DbSchema 6.4.0 Build 3904 (Oct 18, 2013)

  • New version poi.jar libraries for generating Excell files.
  • Moved JDBC drivers in web. DbSchema can download drivers directly from Web. Installation package is getting compact.
  • Refactured Rdbms classes

New in DbSchema 6.4.0 Build 3831 (Jul 26, 2013)

  • Upgrade Nsis installer software
  • Improve draw foreign key lines, threading on routing the lines
  • Bug fix on Create Schema in Database
  • Fixes on Random Data Generator
  • Schema Selection Dialog does not show Root node
  • First Dialogs for Data Generator
  • Added GROOVY support in SQL editor
  • Fix on Search in Project combo
  • Bug fixes

New in DbSchema 6.3.0 Build 3777 (Apr 10, 2013)

  • Added option to show special characters in Sql Editor.
  • Fixes in Shortcut Manager.
  • Added table Dependencies Dialog.
  • Keep table ordered alphabetically on offline projects.
  • Fix on escape reserved keywords column names.
  • Added feature to copy a layout ( from Tree Pane ) into another layout.
  • On small zoom move column or create fk is not allowed. Instead is done drag table.
  • Linux default look and feel to MetalLookAndFeel.
  • Fix for Firebird ALTER TABLE ADD PRIMARY KEY.
  • Sequences support Suffix ( INCREMENT BY, MINVALUE, ... ) as text.
  • Avoid overlapping tables after dragging by moving the tables behind to left or right.
  • Added option in Appearance/ Configuration to disable group gradients.
  • Support multi-line comments in tooltips.
  • Improved connectivity error advices.
  • Improvements in HTML5 documentation. Better looking images & HTML !
  • Improved Quick Tour
  • Added SSH tunnel functionality to the Database Connection Dialog.
  • Added name tool-tip comments in Schema, Table, Index, Foreign Key editors. Comments explains when the rename operation is allowed.
  • Use table color for the complete table background on Rainbow look and feel.
  • New design and look and feel.
  • Added icon in corner of the diagram ( scroll pane corner ) with wait animated gif for the duration of routing foreign keys.
  • Fixed bug related to prefix table name with schema name.
  • Improved table auto-place algorithm. Added logic to group together tables based on name similarity.
  • Added SQLException advices for different databases.
  • Print bug fixes
  • SqlServer for both SqlServer2008 and SqlServer2012
  • SQL editor text indentation improvements
  • SQL editor auto-complete improvements
  • Fast search table using CTRL+ALT+F
  • Improved settings dialog.
  • More configurations for each database.
  • Configurable Alter Statements for each database apart.
  • After application updates are downloaded there is a option to view development changelog.
  • Improved application updates mechanism with precise download progress.
  • In Query builder can exclude more tables at one time
  • Bug fix : modifying comments may not set the project in the modified state
  • Bug fix : Open Data Editor may throws class cast exception
  • Improved SQL text indentation in SQL editor
  • Can add 'to_do' flags for columns. Flags will be displayed in UI
  • New interface for comment panel callout selection
  • Added and tested SqlBase
  • Renamed Tracking Frame to History Frame. Added Copy to Clipboard button for selected History Sql.
  • View table data in a small pop-up by clicking the table header with CTRL+SHIFT down.
  • Added option to export query builder pane as png, gif, jpg image.
  • Ability to see the virtual foreign keys. Right-click the layout pane and choose 'highlight virtual foreign keys'
  • Layout Properties Dialog : Added ability to select tables which are not listed in any other layout
  • UI Improvements. Reverted from Candara size 12 to Dialog size 11 default layout font.
  • Bug fix on Query Builder : un-ticking order by clause will not remove it from the generated SQL.
  • Reopen layouts and editors from the tabbed pane small button on the left.
  • Improvements in ApplicationAction Better Swing Application Framework. This allows a better control of failing actions.
  • Bug fixed related to shown messages on create table, create column Improved create database for MySql
  • Synchronization Dialog got new look
  • Better Task Progress Bar in Status Pane
  • Create or modify table from SQL editor will trigger
  • AutoSynchronization
  • Faster import
  • Refresh in project MySql Enum was not loaded properly. Problem fixed.
  • Used memory improvements. Great gain in memory usage for large projects.
  • Confirm save for Query builder editor.
  • Oracle import number(22,6) not working fine
  • Rename labels in Connector Editor
  • Bug Fix: Generate schema scripts option 'Prefix with Schema name
  • schema].[table]' didn't work
  • Bug Fix: Joining two tables in Query Builder won't refresh the SQL.
  • Better tips in Connector Editor for Host name.
  • Improved ping functionality in Connector Editor.
  • Query Builder panes are saved to project file.
  • Added explain plan including charts for SqlServer.
  • Improved explain plan charts for Oracle, Db2, Mimer.
  • Improved icons and menu item names in Query Builder
  • Default values in Column Editor get a ' character as soon as the user types in text.
  • New Settings button in Generate Schema Scripts Dialog
  • Improvements in HTML5 documentation
  • Fix for : clicking one index icon and than a second would display the wrong pop-up.
  • Fix bug related to mouse over diagram.
  • Improved support for Sqlite on Android. More help information about accessing Sqlite database on Android.
  • Removed usages of SwingUtilities2. The class is Sun proprietary, may be later removed.
  • In Connect to Database Dialog correctly remember the last used driver to connect with.
  • Added Firebird JDBC driver 2.2.0
  • Reveres engineering from PostgreSql on mixed case column names was returning column names surrounded by '"'. Added fix correctly load them.
  • Fixed rename unique index on Postgres
  • Fixes on create new layout. Problems were related to frame docking.
  • SqlServer fix for correctly importing varchar(max)
  • Added option to extend trial period with further 15 days. Option is available on the http://www.dbschema.com/editions.html

New in DbSchema 6.1.0 Build 3653 (Sep 14, 2012)

  • Fixes on create new layout. Problems were related to frame docking.
  • SqlServer fix for correctly importing varchar(max)
  • Added option to extend trial period with further 15 days.
  • Added diagram notation:Information Engineering With Arrows,Information
  • Engineering,Barker,Idef1x
  • Added column order alphabetically
  • User can now hide tables columns in the layout (I.E if a table has 20 column you can
  • now select what column to be showed in the layout)
  • Improved HTML5 documentation
  • Added support for Vertica database, Teradata Database.

New in DbSchema 5.3 Build 1176 (Sep 24, 2009)

  • New features for Database Synchronization, Browse, etc.