laravel 4 multiple DB connection

Question

Playing around with laravel 4 and was wondering if there is a way to run migrations on different connections, so if I have as default:

'sqlsrv' => array(
    'driver'   => 'sqlsrv',
    'host'     => '192.168.1.11\SQLEXPRESS',
    'database' => 'database1',
    'username' => 'sa',
    'password' => 'password',
    'prefix'   => '',
    ),

But I want a different migration to go here:

'sqlsrv2' => array(
    'driver'   => 'sqlsrv',
    'host'     => '192.168.1.11\SQLEXPRESS',
    'database' => 'database2',
    'username' => 'sa',
    'password' => 'password',
    'prefix'   => '',
    ),

I have no doubt there is a way to do it, but I'm not finding it in the docs. :)

Besides specifying your connection directly into the migration like Schema::connection('foo')->create... your other option is to extend the Migration and specify it there. I agree it sucks that you can't specify the connection during the migrate command. — Geo
– Geo, Commented Nov 18, 2015 at 21:57

Deinumite · Accepted Answer · 2013-09-19 18:28:04Z

4

From the docs at http://laravel.com/docs/schema#creating-and-dropping-tables

To specify which connection the schema operation should take place on, use the Schema::connection method:

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

answered Sep 19, 2013 at 18:28

Deinumite

4,0293 gold badges28 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tattooedgeek Over a year ago

Holy crap I looked at that 10 times and it just now makes sense.. Thanks man.

forgandenny · Accepted Answer · 2013-10-04 11:52:26Z

2

It worked with

php artisan migrate --env=local --database=my_connection_name

but it has ignored

Schema::connection('my_connection_name').

answered Oct 4, 2013 at 11:52

forgandenny

212 bronze badges

Collectives™ on Stack Overflow

laravel 4 multiple DB connection

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related