Skip to Content
DocsDatabase EngineeringImport and Export

Import & Export

Import and Export allow you to move database schemas between Qubase and other database tools.

Whether you are migrating an existing project, sharing a database design with your team, or creating backups, Qubase provides flexible import and export capabilities.


Before you begin

Before importing or exporting a database schema, ensure that you have:

  • Created a Workspace
  • Created a Project
  • Opened a Database Schema

[!NOTE] Supported formats depend on your Qubase edition and project configuration.


Import database models

Importing allows you to continue working with existing database designs inside Qubase.

Supported import sources may include:

  • SQL files
  • DBML files
  • Existing database connections
  • Previously exported Qubase projects

After importing, the database model becomes editable on the ERD Canvas.


Import workflow

Choose Import Source Upload File or Connect Database Validate Content Generate Database Model Open in ERD Canvas

Import process

To import a database model:

  1. Open Database Engineering.
  2. Select Import.
  3. Choose the import source.
  4. Upload the file or select an existing database connection.
  5. Validate the imported structure.
  6. Complete the import.

The imported schema is added to your project.


Export database models

Exporting allows you to share or deploy your database design.

Supported export formats may include:

  • SQL
  • DBML
  • JSON
  • Project Backup

The available formats depend on your project configuration.


Export workflow

Database Schema Select Export Format Generate Output Download or Share

Export process

To export a database model:

  1. Open a Database Schema.
  2. Select Export.
  3. Choose the desired format.
  4. Review the generated output.
  5. Download the exported file.

Supported formats

FormatPurpose
SQLDeploy to a database server
DBMLShare database models with DBML-compatible tools
JSONIntegrate with external applications
Project BackupArchive an entire database project

Validation

Before importing or exporting, Qubase validates the database model.

Validation may include:

  • Invalid SQL syntax
  • Unsupported DBML features
  • Duplicate table names
  • Missing relationships
  • Incomplete database objects

Validation helps ensure that imported and exported data remains consistent.


Best practices

  • Validate imported schemas before editing.
  • Review exported SQL before deployment.
  • Keep backup copies of important projects.
  • Export the latest version after major schema changes.
  • Use version control for exported database scripts.

[!TIP] Export database models regularly to simplify collaboration, backups, and deployment workflows.


Related guides

Last updated on