Migration overwrite $connection property don't work

[4m1n0s]

• Laravel Version: 6.10.0
• PHP Version: 7.2.18
• Database Driver & Version: Mysql - 5.7

Description:

I overwrite $connection property in migration, but still migrate on the default database connection

as its described on the "abstract class Migration"

abstract class Migration
{
    /**
     * The name of the database connection to use.
     *
     * @var string|null
     */
    protected $connection;

The migration file i used

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateProjectsTable extends Migration
{
    protected $connection = 'pgsql';
    
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('projects', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('projects');
    }
}

Note: the default connection i use on .env is mysql

[crynobone]

If the connection name is hardcoded you can use:

Schema::connection('pgsql')->table(...)

[driesvints]

Please see the answer above.

[4m1n0s]

Yes i know this is a solution, but by the concept presented in the $connection property comment is not working...

    /**
     * The name of the database connection to use.
     *
     * @var string|null
     */
    protected $connection;

[iraklisg]

Indeed the $connection property does not work in Laravel Framework 8.46.0.

The Schema::connection('...') works as expected

@iAmine Is there a way to make $connection property work?

[4m1n0s]

@iraklisg Yes, you can check the pull request i have made.

extend the Migrator class and make the needed changes.

[JohnnyWalkerDigital]

I am also having this issue. The documentation states this is the way to set your migration connection. Laravel v8.60.0 (PHP v7.4.11)