The Best Database Client & Diagram Designer for Windows PC

DbSchema

DbSchema 9.5.3

  -  151 MB  -  Trial

Sometimes latest versions of the software can cause issues when installed on older devices or devices running an older version of the operating system.

Software makers usually fix these issues but it can take them some time. What you can do in the meantime is to download and install an older version of DbSchema 9.5.3.


For those interested in downloading the most recent release of DbSchema or reading our review, simply click here.


All old versions distributed on our website are completely virus-free and available for download at no cost.


We would love to hear from you

If you have any questions or ideas that you want to share with us - head over to our Contact page and let us know. We value your feedback!

  • DbSchema 9.5.3 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    DbSchema 9.5.3 Screenshot 1
  • DbSchema 9.5.3 Screenshot 2
  • DbSchema 9.5.3 Screenshot 3
  • DbSchema 9.5.3 Screenshot 4

What's new in this version:

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=
- java.net.sql.trustStore=
- 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.