Dreamweaver
Visual Studio
UltraEdit
dbForge SQL
Portfolio
Access
SQL 2019
dbForge Studio
-
Latest Version
DbSchema 9.5.3 LATEST
-
Review by
-
Operating System
Windows 7 64 / Windows 8 64 / Windows 10 64 / Windows 11
-
User Rating
Click to vote -
Author / Product
-
Filename
DbSchema_9_5_3.exe
Using Db Schema you can design the schema with or without a database, save the design as project file, deploy schema on multiple databases, and share the design in a team. Build-in tools allow to visually explore the database data, build and execute queries, generate random data, build forms applications or reports, and more. It can be evaluated 15 days for free, no registration required. It can work on all operating systems.
Db Schema is built for large schemas and complex databases. Build meaningful relations between tables and document the schema. Discover DbSchema layouts, virtual foreign keys, Relational Data Browse, interactive PDF documentation, and many other features.
Features and Highlights
Import database schemas
- Load JDBC driver
- Connect to any JDBC compatible database. Several DBMS have already been tested, but more will be added later.
- Currently tested DBMS include: Oracle, MySQL, PostgreSQL, DB2 for Windows/Linux, Cache, DaffodilDB, FrontBase, HSQLDB, Informix, JavaDB/Derby, Microsoft SQL Server, Mimer, Pervasive, PointBase, Sybase SQL Anywhere, Sybase ASE.
- Schema import includes: tables, views, foreign keys, procedures, triggers, sequences, and comments.
- Uses an abstraction level between internal database schema representation and any particular database.
- Edit tables, columns, indexes, foreign keys, procedures, triggers, sequences, and comments.
- Edit your schemas Graphically using Layouts, including: tables, views, foreign keys, etc...
- Create and use multiple Layouts inside a project.
- Drag, pan, and zoom Layouts using simple mouse movements.
- Supports Drag&Drop from project tree to graphical Layout.
- Highlight Foreign Keys for a given table, which trigger on delete events.
- Generate SQL statements directly from the schema graphical Layout.
- Generate schema scripts to any particular database.
- Change schema data types from one database to another.
- Edit schema offline support.
- Browse data from multiple tables simultaneously.
- Set filters over browse data.
- Order browse data on one or more columns.
- Unlimited browse depth.
- Paginates browse data.
- Single or multiple record views.
- Insert, update, and delete records.
- View Large Objects (LOBs) fields as image, Html, text, or using an external application.
- Saves browse sessions in the project file, which can later be browsed again.
- Edit SQL statements.
- Syntax highlight covering database keywords, functions, table, and view names.
- Auto-completion of table, view, and column names.
- Quick Click&Show tables or columns in SQL pane and show them in Layout.
- Execute SQL statements individually or as scripts.
- Paginate and order SQL results, after query execution.
- Keep multiple SQL result panes, and refresh query results.
- Explain the SQL execution plan.
- Saves SQL scripts working sessions in the project file, which can later be continued.
- Synchronize project schema with another project or database.
- List schema differences.
- Select which differences to keep, either on a local or remote schema.
- Generate Merge SQL scripts based on schema differences.
- Upload differences on to a database, with automatic step by step execution.
- Synchronize schemas offline, which empowers teamwork.
- Generates SQL schema creation scripts for any database.
- Document tables, columns, foreign keys, indexes, etc... by adding Comments
- Generates schema specification as an HTML document.
- Print schema Layouts with precise control on actual print size, using the Zoom print feature.
- Generates schema Layout image files, in a few formats (PNG [raster] or SVG [vectorial])
- Provides a Database Template System, which allows to create, edit and maintain database templates
- Several Database Templates are already supplied, but new ones can be learned as well, by connecting to the target database.
-
DbSchema 9.5.3 Screenshots
The images below have been resized. Click on them to view the screenshots in full size.
-
-
-
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.
OperaOpera 109.0 Build 5097.68 (64-bit)
iTop VPNiTop VPN 5.4.0 - Fast, Safe & Secure
PhotoshopAdobe Photoshop CC 2024 25.7 (64-bit)
iAnyGoTenorshare iAnyGo 4.0.15
Opera GXOpera GX 109.0.5097.70 (64-bit)
Adobe AcrobatAdobe Acrobat Pro 2024.002.20687
BlueStacksBlueStacks - Play on PC 5.21.150
Hero WarsHero Wars - Online Action Game
Data Recovery4DDiG Windows Data Recovery 9.8.6
TradingViewTradingView - Trusted by 60 Million Traders
Comments and User Reviews