Use one Laravel migrations table per database

by

Article on usage of multiple database usage in Laravel –
https://stackcoder.in/posts/laravel-7x-multiple-database-connections-migrations-relationships-querying

Use the --database parameter with the migrate command and store the migrations for each database in separate directories.

You could have separate directories in app/database/migrations for each of your database (in your case db1 and db2) and store the appropriate migrations in each directory. Then you could run the migrations like this:

artisan migrate --database="db1" --path="app/database/migrations/db1"
artisan migrate --database="db2" --path="app/database/migrations/db2"

This way your migrations table will be independent for each database.

If you want to go the extra mile and automate the process you could create your custom command that will run all the migrations at once. You can create the command like this (use make:console for Laravel 5.0 up to 5.2 or make:command for Laravel 5.2+):

artisan command:make MigrateAllCommand --command=migrate:all

This will create a new file app/commands/MigrateAllCommand.php. Your command’s fire method would look something like this:

public function fire()
{
    foreach (Config::get('database.connections') as $name => $details)
    {
        $this->info('Running migration for "' . $name . '"');
        $this->call('migrate', array('--database' => $name, '--path' => 'app/database/migrations/' . $name));
    }
}

This will work provided the name of the database configuration key is the same as the migration directory name. You can then just call it like this:

artisan migrate:all

You can check the Laravel Command Docs for more info.

More Related Contents:

  1. Laravel requires the Mcrypt PHP extension
  2. Laravel orderBy on a relationship
  3. Laravel blank white screen
  4. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  5. Access query string values from Laravel
  6. MVC (Laravel) where to add logic
  7. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  8. Composer killed while updating
  9. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  10. What is the syntax for sorting an Eloquent collection by multiple columns?
  11. Laravel named route for resource controller
  12. belongsToMany relationship in Laravel across multiple databases
  13. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  14. file_put_contents(meta/services.json): failed to open stream: Permission denied
  15. Laravel merge relationships
  16. PHP Composer update “cannot allocate memory” error (using Laravel 4)
  17. Update without touching timestamps (Laravel)
  18. Laravel change input value
  19. How can I install mcrypt under PHP7? Laravel needs it
  20. Composer running out of memory on every project, Mac OS X
  21. Laravel Eager Loading – Load only specific columns
  22. Find or Create with Eloquent
  23. Laravel catch Eloquent “Unique” field error
  24. Unresolvable dependency resolving [Parameter #0 [ $name ]]
  25. PHP7 Constructor class name
  26. Laravel Many to many self referencing table only works one way
  27. Laravel Form methods VS traditional coding
  28. How Can I Remove “public/index.php” in the Laravel Url generated? [duplicate]
  29. Laravel quick start guide route not working
  30. Symfony\Component\HttpKernel\Exception\NotFoundHttpException Laravel

Leave a Comment