Design and Manage Transbase Databases Visually with DbSchema

DbSchema lets you design, manage, and document Transbase databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the Transbase database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download Transbase JDBC Driver

Visual Schema Tools for Industrial and Embedded Transbase Deployments

Transbase is a high-performance SQL database developed by Transaction Software, a Munich-based company, and is deployed in industrial control systems, embedded applications, and data-intensive server environments where reliability and a compact footprint are priorities. DbSchema connects to Transbase via its JDBC driver, renders the SQL schema as an interactive diagram, and provides SQL editing tools for a database typically administered through command-line interfaces or proprietary Transbase utilities.

Connect to Transbase and Visualize the Schema

DbSchema reads the Transbase catalog and displays tables, columns, data types, and relationships in the diagram canvas. For industrial Transbase deployments where the schema has grown incrementally over many years, the visual diagram provides a structured overview that is otherwise difficult to obtain from command-line tools alone.

Connecting to a Transbase server and loading the schema diagram in DbSchema

Write and Execute Transbase SQL Queries

DbSchema's SQL editor accepts Transbase's SQL dialect, executes statements against the server, and presents result sets inline. This is useful for verifying data correctness in industrial control applications, diagnosing query performance issues, and running ad-hoc analysis without deploying a separate Transbase client tool.

SQL editor running a query against a Transbase database in DbSchema

Generate Schema Documentation

DbSchema's documentation generator exports the Transbase schema as a navigable HTML report including table definitions, column metadata, constraints, and relationship diagrams. For embedded and industrial Transbase deployments with limited documentation, this report provides a durable reference for maintenance engineers and system integrators.

HTML documentation generated from a Transbase database schema in DbSchema

Connecting DbSchema to Transbase

Transbase listens on port 2024 by default. The JDBC URL format is jdbc:transbase://host:2024/dbname. Download the Transbase JDBC driver from the Transaction Software website and register it in DbSchema's driver manager. The driver class is transbase.jdbc.Driver. The Transbase server must be running and the target database must exist before connecting — Transbase does not create databases automatically on first connection.

Why DbSchema for Transbase

  • Visualize Transbase schemas in ER diagrams for industrial applications with no prior documentation.
  • Run SQL queries interactively without deploying a separate Transbase client application.
  • Generate HTML schema reports for maintenance engineers and system integrators.
  • Compare schema versions across Transbase instances to track undocumented schema drift.
  • Design schema modifications visually and apply the generated DDL to the Transbase server.