Migrate Routines for Laravel
Generate Laravel Migrations from existing MySQL routines: views, procedures, functions and triggers
Require this package with composer. It is recommended to only require the package for development.
composer require adrienpoupa/migrate-routines --dev
Convert the existing views into migrations
php artisan migrate:views
Convert the existing procedures into migrations
php artisan migrate:procedures
Convert the existing functions into migrations
php artisan migrate:functions
Convert the existing triggers into migrations
php artisan migrate:triggers
For all the commands, is possible to specify the database from which to retrieve the routines with the
--database option, like this:
php artisan migrate:views --database=database_name
For this package to work, your database connection should be done with a user privileged enough to run elevated queries from the information_schema and the mysql.proc tables.