Laravel/lumen 5.2 generate migration tables from existing database

Question

Is possible to generate migration schema from existing database in lumen/laravel 5.2 ? is there any package?

I connect lumen to magento database, now I need to use eloquent. I dont have time to make migration model for every table.

You don't need to create migrations to use eloquent with existing tables, unless I misunderstood your question — Fabio Antunes, Apr 27 '16 at 11:25
Then try this, might help you https://github.com/Xethron/migrations-generator — Fabio Antunes, Apr 27 '16 at 11:57
Nevermind doesn't work with lumen https://github.com/Xethron/migrations-generator/issues/65 — Fabio Antunes, Apr 27 '16 at 11:58

score 8 · Answer 1 · answered Apr 27 '16 at 12:05

8

You can dump database first with mysqldump tool to the sql file and then in your migration you can do somethink like this:

public function up()
{
    $path = 'path_to_sql/dump.sql';
    DB::unprepared(file_get_contents($path));
}

answered Apr 27 '16 at 12:05

Filip Koblański

score 1 · Answer 2 · answered Apr 19 '19 at 15:28

Some easy way I found:

Install the last version of Laravel and create a project named 'migratedb'
Set the env database to the one you want to migrate
Install the Xethron library to create migrations, https://github.com/Xethron/migrations-generator and follow the instructions
Install the Iseed library to create reverse migrations, https://github.com/orangehill/iseed and follow the intstructions
Copy the content from database/migrations and database/seeds from Laravel 'migratedb' to your Lumen project

2 Answers2