cviebrock / sequel-pro-laravel-export

A Sequel Pro / Sequel Ace bundle to generate Laravel migration files from existing tables.
MIT License
921 stars 56 forks source link
database-schema laravel-migration sequel-ace sequel-pro sequelpro

Laravel Migration Exporter for Sequel Pro and Sequel Ace

A bundle for Sequel Pro and Sequel Ace that lets you generate Laravel migration files from existing tables.

Installation

  1. Download the latest release and unzip the appropriate file, depending on whether you are using Sequel Pro or Sequel Ace.
  2. Double-click on the bundle package to install the bundle.
  3. Launch Sequel Pro or Ace!

Installation from Source

  1. Clone the repository
  2. Run ./build.sh to create Sequel Pro and Sequel Ace versions of the bundle
  3. Use the appropriate bundle in the build directory

Usage

Connect to a database, and select a table in the left-hand column. From the application menu, choose Bundles › Export › Export to Laravel Migration, or use the keyboard shortcut ⌃⌥⌘M (that's CTRL + OPTION + CMD + M).

The resulting Laravel migration file will be saved in a new directory called SequelProLaravelExport on your desktop. You can then move this file into your Laravel project (usually /database/migrations) and then run artisan migrate.

Sequel Ace Usage

The Sequel Ace bundle will only work with version 3.0.0 and later of Sequel Ace.

You will also need to give Sequel Ace permission to write to the Desktop folder via the application's preferences:

Caveats

Auto-generated migration files will likely need manual adjustments. Be sure to look at the code before running artisan migrate!

Bugs, Suggestions and Contributions

Thanks to everyone who has contributed to this project!

Please use Github issues for reporting bugs, and making comments or suggestions.

See CONTRIBUTING.md for how to contribute changes.

Copyright and License

sequel-pro-laravel-export was written by Colin Viebrock and is released under the MIT License.

Copyright (c) 2016 Colin Viebrock