Master Frontbase with DbSchema: Database Design Simplified

DbSchema is a Frontbase management tool that provides a powerful graphical interface for visually interacting with the database. DbSchema features the design model, which allows schema design in teams and deployment into multiple databases. Users can document the database schema, explore and query the data, generate random data, build reports and more.

Download DbSchema Editions
DbSchema Database Designer
Database Schema Design Tool

Design Complex Frontbase Databases

After connecting to the database, DbSchema will reverse engineer the Frontbase database structure in its model and visualize it graphically. You will interact with the schema using layouts (diagrams). The layouts can handle large databases with more than 10.000 tables. The graphical interaction will help to improve the database design.

Design the schema in a Team. Deploy the schema on multiple Frontbase servers.

The DbSchema model refers to the representation of a database schema within the DbSchema application.
DbSchema model is using its copy of schema structure, independent from the Frontbase database.
This is a separation between schema design and the database, with numerous advantages:

  1. Manage Multiple Databases

    Compare and deploy the database schema on multiple Frontbase databases. Incremental changes can be applied.

  2. Model File

    Save the design model including the schema structure to model file, as XML text. The model file can be open from any computer, without Frontbase connectivity.

  3. Design in Team

    The model file can be stored in GIT and shared in a team. Each team member can modify it and commit model changes in GIT. Database administrators can deploy the schema changes on testing or production databases.

  1. Generate Migration Scripts

    Generate migration scripts from one version of the schema to another by comparing two different model files with two versions of the same schema.

  2. Design Offline

    Schema can be designed offline, without database connectivity.

Read More
DbSchema Project File

Design Frontbase Schema Visually. Generate HTML5 Documentation

In DbSchema, layouts refer to the visual arrangements and configurations of various components within the application's workspace. Layouts help users organize their work by defining the positioning and visibility of elements such as database diagrams, SQL editors, query results, and other tool windows. DbSchema offers different predefined layouts, such as Design, Query, and Reports, which can be customized and saved based on individual preferences and project requirements. These layouts allow users to switch between different views and focus on specific tasks or aspects of their database work.

Create multiple layouts (diagrams) with the same or different tables. Edit tables and columns directly in the diagram. The layouts will be saved to the model file. Add comments to each table or column and generate Frontbase interactive HTML5 or PDF documentation as diagram image with comments.

Read More

Frontbase Schema Documentation

Relational Data Editor: Easy Visualize Data

An amazingly simple Frontbase data editor and editor that offers simultaneous views of data from multiple tables, and features numerous filters, data sorting mechanisms, and much more. The editor can explore data from multiple tables simultaneously using foreign keys or virtual foreign keys between tables. If the schema is missing foreign keys you can create virtual foreign keys that will be part of the DbSchema model.

Read more

Database Data Editor

Discover the Tools for Frontbase

Download DbSchema Purchase
DbSchema Video Presentation

Free Trial

Free download & evaluate DbSchema for 15 days.

Technical Support

Every user will benefit from full technical support.

All Databases Included

With a one license you can connect to every SQL, NoSQL or Cloud database

Money Back Guarantee

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

Satisfied Customers