Export from MySQL Workbench to a Laravel Migration
Published on by Eric L. Barnes
MySQL Workbench is a cross-platform GPL app that allows you to fully design and document your databases through the app.
Brandon Eckenrode, created a plugin that allows you to export a MySQL Workbench model to Laravel 5 migrations that follow PSR-2 coding standards. When exported, each migration is generated and saved in its own, properly named, migration file.
This works by downloading the plugin from GitHub, then open MySQL Workbench and go to the Scripting menu, Install Plugin/Module. Next select the export-laravel-5-migrations.py
file and restart the app.
When you open it back up navigate to File -> New Model and add a basic structure for a table.
Next, navigate to Tools -> Catalog -> Export Laravel 5 Migration, and a window will open with the migration ready for you to download:
You can download this from GitHub and learn about Workbench Modeling on the MySQL site.
If you are a Sequel Pro user be sure and check out a similar style plugin, Export from Sequel Pro to a Laravel Migration
Eric is the creator of Laravel News and has been covering Laravel since 2012.