How can I specify which database connection Laravel uses for the migration table?

Question

I'm working on an app with multiple database connections. It seems when I run php artisan migrate:install it always creates the migrations table using my default connection in app/config/database.php, which is not ideal.

Is there a way to specify a different connection for the migrations table itself?

Answer 1

Update

For anyone with a similar question, I found a better answer.

Looks like you can't specify the connection from a config file or anything, but you can when you run migrate from the command line...

php artisan migrate:install --database=NAME_OF_CONNECTION

There is one caveat: anytime you run an actual migration you must also specify the database connection with --database again or it will re-create the migrations table using the default connection.

Answer 2

Edit: Looks like you want to change where the migrations table is stored. This I believe always uses the default. You can however specify where a table is supposed to be created as below:

You can specify a connection like so:

Schema::connection('foo')->create('users', function($table)
{
    $table->increments('id');
});

From http://laravel.com/docs/schema