MySQL Workbench

Skipper fully supports import of the MySQL Workbench native format. It is possible to import the model workbench file to Skipper and automatically generate the schema files for your preferred ORM framework. Export formats are supported for Doctrine, Doctrine2, Propel or Cake PHP.

MySQL Workbench support

Using MySQL Workbench you can directly administer the database. But Skipper allows you to take full advantage of ORM oriented design. You can design the project, directly edit ORM specific properties, export schemas straight to your framework format and import existing schemas. Skipper supports import of the MySQL Workbench database schemas to help you transfer your existing projects more easily.

MySQL Workbench - Sakila example database schema
Diagram of Sakila example imported to Skipper from MySQL Workbench

Read the comparison study if you are more interested about differences between the Skipper and MySQL Workbench. Main focus of this comparison lies in the ORM framework support and ORM oriented design.

Export from MySQL Workbench

You do not have to do anything extra. All that you need to do is just save your model the usual way in MySQL Workbench, and everything else will be taken care of by Skipper.

Import from MySQL Workbench

To import MySQL Workbench model to Skipper open the Skipper Main Menu, select Create or import new and then select Import external model.

Skipper External model import function

This launches wizard which will guide you through the necessary options like:

  • What application are you importing from (in this case MySQL Workbench).
  • What ORM Framework and MVC Framework do you want to use for the exported schema.

Your database schema will now be converted to ORM model. The tables, columns, relations and properties defined in the model will become entities, fields and associations for your ORM schema.

Skipper will automatically prepare set of ORM specific properties for each element, and you only need to choose which will be used to fully benefit from the ORM approach.

Export to annotations, XML, YML

Once the model is imported from MySQL Workbench to Skipper, you can easily export it to ORM framework you have defined during import (Doctrine, Doctrine2, Propel or CakePHP). You can now export your model in the regular way as any other Skipper project.

Sakila Doctrine2 PHP export
Sakila Doctrine2 XML export
Sakila Doctrine2 YML export

MySQL Workbench ERD

The Skipper visual representation is different from the MySQl Workbench, but most of the visual model properties itself are imported. Skipper keeps visual settings like locations and spacing of the entities, colors and of course the actual entities, their fields and associations.

Example of .mwb file import

Here is a step by step tutorial how to import the MySQL model file for editing and its subsequent export to XML, YML or annotations.

Open the Skipper main menu and continue as follows:

In Skipper menu open Create or import new, then select Import External Model
In Skipper import external model function select import from MySQL Workbench
Select ORM framework in Skipper import from MySQL Workbench wizard

Select MVC framework in Skipper import from MySQL Workbench wizard
Select file to import and your project path
Skipper import of the MySQL Workbench diagram result

Your MySQL Workbench model is now loaded as an Skipper project ready to be modified or exported to schema files.

Doctrine2 project Sakila imported form MySQL Workbench shown in the Skipper visual model

Video Tutorial

Import from MySQL Workbench