Design and Manage JDataStore Databases with DbSchema

Build a clearer workflow for JDataStore: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.

DbSchema is built 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 JDataStore Features Download JDataStore JDBC Driver

What happens after you download?

Get to your first JDataStore 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 JDataStore or open a sample

Reverse engineer an existing JDataStore 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.

Get Started Free

Visual Schema Tools for Legacy Borland JDataStore Applications

JDataStore is a compact Java database engine originally developed by Borland and later maintained as part of the CodeGear toolchain. It was embedded in Delphi for .NET and JBuilder applications as a lightweight local data store, and its .jds files remain in use in legacy enterprise and desktop applications that have not yet been migrated. DbSchema connects to JDataStore via its JDBC driver, surfaces the table schemas visually, and provides documentation tools for teams that need to understand or migrate these older databases.

Download DbSchema Free See JDataStore Features

Open JDataStore Files and Inspect the Schema

DbSchema connects to a JDataStore file using the Borland JDBC driver and reads the table definitions into the diagram canvas. Column names, data types, and constraints appear in the visual schema without requiring the original JBuilder or Delphi development environment to be installed.

Opening a JDataStore .jds file in DbSchema and displaying the schema diagram

Run SQL Queries Against JDataStore

JDataStore exposes a JDBC interface that supports standard SQL. DbSchema's SQL editor lets you write and execute SELECT, INSERT, UPDATE, and DDL statements against a JDataStore file — useful for extracting data for migration or diagnosing application-level query issues without the original IDE.

SQL editor executing a query against a JDataStore database file in DbSchema

Document the JDataStore Schema for Migration Planning

For legacy applications where the JDataStore schema has never been formally documented, DbSchema's documentation generator produces an HTML report covering all tables, column types, and relationships. This documentation supports migration planning to modern databases such as PostgreSQL or SQL Server.

Schema documentation report generated from a JDataStore database in DbSchema

Connecting DbSchema to JDataStore

Use the JDBC URL jdbc:borland:dslocal:/path/to/file.jds to connect to a local JDataStore file. The driver class is com.borland.datastore.jdbc.DataStoreDriver. Locate dsjdbc.jar in the original JDataStore installation directory and register it in DbSchema's driver manager. The driver ships as part of the JDataStore runtime, which is available in archived Borland and CodeGear product distributions — the driver version must match the JDataStore file format version of the target .jds file.

Why DbSchema for JDataStore

  • Open .jds files and inspect table schemas without Borland or CodeGear tools.
  • Run SQL queries to extract data for migration to a modern relational database.
  • Generate schema documentation as a prerequisite for legacy application audits.
  • Compare JDataStore schemas across application versions to identify structural changes.
  • Design the target migration schema in DbSchema alongside the JDataStore source model.