在架构外观中使用DB::reconnect()？

Question

我在一个多数据库系统上工作。系统将集成客户端本地mssql服务器。

我会将凭证信息存储在我的主数据库中。我想把一些表迁移到我的客户本地数据库中。

如你所知，我们可以选择如下连接。

Schema::connection('sqlsrv')->create('products', function (Blueprint $table) {

});

但我必须动态地使用它。

此连接从config/database.php读取

'connections' => [

    'sqlite' => [
        'driver' => 'sqlite',
        'database' => env('DB_DATABASE', database_path('database.sqlite')),
        'prefix' => '',
    ],

    'mysql' => [
        'driver' => 'mysql',
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'charset' => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix' => '',
        'strict' => false,
        'engine' => null,
    ],

    'sqlsrv' => [
        'driver'   => 'sqlsrv',
        'host'     => env('SQLSRV_HOST', 'localhost'),
        'database' => env('SQLSRV_DATABASE', 'forge'),
        'username' => env('SQLSRV_USERNAME', 'forge'),
        'password' => env('SQLSRV_PASSWORD', ''),
        'collation' => 'Turkish_CI_AS',
        'charset'  => 'utf8',
        'prefix'   => env('SQLSRV_PREFIX', ''),
    ],

    'pgsql' => [
        'driver' => 'pgsql',
        'host' => env('DB_HOST', 'localhost'),
        'port' => env('DB_PORT', '5432'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'charset' => 'utf8',
        'prefix' => '',
        'schema' => 'public',
    ],

],

我在使用DB Facade时做到了这一点。

public function getConnection($connection_id)
{
    /** Bağlantı Bilgilerini Çeker */
    $connection = Connection::find($connection_id);

    try
    {
        /** Bağlantı Ayarları */
        config()->set('database.connections.sqlsrv.host', $connection->host);
        config()->set('database.connections.sqlsrv.database',  $connection->db);
        config()->set('database.connections.sqlsrv.username',  $connection->username);
        config()->set('database.connections.sqlsrv.password',  $connection->password);
        config()->set('database.connections.sqlsrv.charset',  $connection->charset);
        config()->set('database.connections.sqlsrv.collation',  $connection->collation);
        config()->set('database.connections.sqlsrv.prefix',  $connection->prefix);

        /** Ayarlar ile yeniden bağlanma */
        return DB::reconnect($connection->driver);
    }catch (\Exception $e)
    {
        throw new \Exception($e);
    }
}

在Schema Facade中有像DB::reconnect()这样的方法或解决方案吗？