DbSchema is an Db2 database designer featuring interactive diagrams, HTML and PDF documentation, schema migration and versioning, relational data browse, random data generator, visual query builder, SQL editor and database reports.

DbSchema is using its own image of the schema separate from the Db2 database. This makes possible to deploy the schema on multiple databases, manage different versions of the same schema and generate migration scripts.

Features like HTML5 vector image documentation, virtual foreign keys and relational data browse are helping to document, understand and explore databases.

DbSchema Database Designer

Db2 Designer

Db2 Diagram Designer Using DbSchema you will interact with Db2 using interactive diagrams. New tables, columns and indexes can be created directly in the diagram. The diagrams can be exported as HTML vector images.

The diagrams will be saved to project file as XML. The project file will hold an database-independent image of the schema together with the layouts (diagrams) and user comments.

Video Introduction Read more »

Schema Deployment and Migration

DbSchema is using its own image of the schema, separate from the database. This can be saved as project file.
The local image of the schema can be compared with any database, migration scripts can be generated.
The local image of the schema can be compared also with other project files, which may hold other versions of the schema. In this way migration scripts between different versions of the schema can be generated.

Relational Data Browse

Simultaneously explore data from multiple tables bind via foreign keys. Selecting a record in one table will update the children tables with the matching records. There is no limit for the number of tables to cascade. If the schema is missing foreign keys, you can create virtual foreign keys in DbSchema and use them in relational data browse.


Relational Data Browse
Video Introduction Read more »

Visual Query Builder and Query Editor

Db2 visual query builder and query editor

The visual query builder can use Group By, Order by clauses, different joins like left join, exists. The joins are using foreign keys or virtual foreign keys.

The Query editor features text-autocompletion, script execution and graphical explain plan.

Video Introduction Read more »

Database Forms and Reports

Db2 Forms and Reports DbSchema Db2 forms and reports can be used to build applications or reports and run which can run as Web applications. The reports may use multiple master-detail sections and responsive bootstrap web pages. Forms can include different input fields, radio buttons, images and charts.

Read more »

For a good database design you may need visual database documentation, diagrams and virtual foreign keys. Here you have an sample interactive documentation. Move the mouse over tables and columns to read the schema comments.



Free Trial

Download DbSchema and try it 15 days for free.

Technical Support

Registered and unregistered users may benefit from technical support.

1 Year Renewals Included

Purchase DbSchema and you will get 1 year free updates to new developed features and fixes.

Money Back Guarantee

Not happy with DbSchema ? 30 days after purchase you can claim your money back.

Start using DbSchema right now !

DbSchema can be evaluated 15 days for free.

DbSchema can run on all operating systems: Windows, Linux, MAC.

DbSchema Database Tool

Navigation