Import/Export the Design Model from Other Formats

DbSchema can import or export the design model from external formats.

Import the Design Model
Export the Design Model using Groovy Scripts

Import the model from Other Formats

Import an design model using Model / Load From External Format menu option.

Menu option to import model from external file

Select the file to import...

For each column from the import file, choose if the column contains the schema, table, column name, column data type, length, nullable, etc. This will load the data into an internal H2 database. DbSchema will parse the imported data and generate a new model.

Define the mapping between the input and the model table,column,etc.

This will load the data into an internal H2 database. DbSchema will parse the imported data and generate a new model.

Export the Model using Groovy Scripts

The most flexible method to export the design model is using Groovy scripts. You can customize them and export only the data you need.

From the Tools menu open the Automation Scripts.

Export the design model using automation scripts.

Copy the 'Model to CSV File' script.

Paste the script into an SQL Editor and change the language from 'SQL' to 'Java Groovy'. Groovy is 100% Java. If you have Java or JS knowledge, you already know Java. In the automation scripts dialog you have also a link to the DbSchema API.