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 CanvasImport process
To import a database model:
- Open Database Engineering.
- Select Import.
- Choose the import source.
- Upload the file or select an existing database connection.
- Validate the imported structure.
- 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 ShareExport process
To export a database model:
- Open a Database Schema.
- Select Export.
- Choose the desired format.
- Review the generated output.
- Download the exported file.
Supported formats
| Format | Purpose |
|---|---|
| SQL | Deploy to a database server |
| DBML | Share database models with DBML-compatible tools |
| JSON | Integrate with external applications |
| Project Backup | Archive 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.