Get a Visual Reference for a Legacy SQLBase System

Connect DbSchema to Gupta SQLBase and turn the live schema into an editable visual model: explore relationships in interactive ER diagrams, plan changes on the canvas, and generate reviewed SQL scripts for deployment.

The workflow is designed for visual modeling, schema documentation, and deployment โ€” keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

DbSchema Database Designer

Download DbSchema See Gupta SQLBase Features Download Gupta SQLBase JDBC Driver ยท All drivers

What happens after you download?

Get to your first Gupta SQLBase schema diagram in minutes. No account, no credit card.

1
Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

2
Connect to Gupta SQLBase or open a sample

Reverse engineer an existing Gupta SQLBase database or open a sample model to explore tables, relationships, and indexes.

3
Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

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.

None of this requires a paid license: reverse engineering, the ER diagram, and the SQL editor all live in the free Community edition. A long-running migration project benefits from Pro's offline design model and Git versioning, which keep a historical record of how the SQLBase schema looked at each stage of the project.

Download DbSchema Free See Gupta SQLBase Features

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

Reaching a Legacy SQLBase Server from DbSchema

Getting DbSchema talking to an older SQLBase installation takes a short setup:

  1. Install DbSchema.
  2. Obtain the SQLBase JDBC driver from Centura Software, or a compatible third-party driver.
  3. Register the driver JAR in DbSchema's driver manager under Settings > Drivers.
  4. Create a new connection using the database name, which forms the URL jdbc:sqlbase:dbname.
  5. Connect โ€” the existing tables and relationships appear on the diagram canvas without further setup.

The SQLBase server must be running and the database name must be registered in the server configuration before connecting. Network access requires the server's host to be reachable from the machine running DbSchema on the configured port.

How DbSchema Helps With a Gupta SQLBase Legacy

  • 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.

Get the schema diagram that decades-old SQLBase application never had โ€” download DbSchema for free and start your migration planning with a clear structural reference.

Teams working with Gupta SQLBase often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases