Design and Manage Gupta SQLBase Databases Visually with DbSchema

DbSchema lets you design, manage, and document Gupta SQLBase 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 Gupta SQLBase 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 Gupta SQLBase JDBC Driver

Visual Schema Tools for a Legacy Enterprise PC/LAN Database

Gupta SQLBase is a relational database that powered client-server enterprise applications through the 1990s, developed by Gupta Technologies and later maintained by Centura Software. It was widely deployed on PC/LAN networks and remains in production at organizations that have not yet migrated away from legacy Centura-based applications. DbSchema connects to SQLBase via its JDBC driver, renders the schema visually, and generates documentation for teams responsible for maintaining or migrating SQLBase-backed systems.

Connect to SQLBase and Load the Schema

DbSchema uses the SQLBase JDBC driver to read the database catalog and display table definitions, column types, and relationships in the diagram canvas. For applications where no schema diagram has ever been produced, this provides an immediate visual overview of the database structure.

Connecting to a Gupta SQLBase server and loading the schema diagram in DbSchema

Run SQL Queries Against SQLBase

DbSchema's SQL editor executes queries against the connected SQLBase instance. Use it to inspect data, validate migration scripts, or test DDL constructs to understand how SQLBase handles specific data types and constraints before replicating the schema in a modern database.

SQL editor executing a query against a Gupta SQLBase database in DbSchema

Document the SQLBase Schema

For long-running SQLBase applications where the original design documentation has been lost, DbSchema's documentation generator produces a current-state HTML report covering all tables, columns, and relationships. This report is an essential prerequisite for planning a migration to PostgreSQL, SQL Server, or another modern target.

Schema documentation report generated from a Gupta SQLBase database in DbSchema

Connecting DbSchema to Gupta SQLBase

Use the SQLBase JDBC driver from Centura Software or a compatible third-party driver. The JDBC URL format is jdbc:sqlbase:dbname. Register the driver JAR in DbSchema's driver manager under Settings > Drivers. The SQLBase server must be running and the database name must be registered in the server configuration before connecting. Network access to the SQLBase server requires the server's host to be reachable from the machine running DbSchema on the configured port.

Why DbSchema for Gupta SQLBase

  • Reverse-engineer SQLBase schemas into visual ER diagrams for legacy applications.
  • Run SQL queries and inspect data without a Centura-era client application installed.
  • Generate current-state schema documentation as a migration planning artifact.
  • Compare SQLBase schemas across server instances to track undocumented structural changes.
  • Design the target migration schema in DbSchema alongside the SQLBase source for side-by-side planning.