Laravel has multiple databases in the migration folder.

[bhargavraviya]

In the migration folder, only single databases were handled, like MySQL and other databases (AWS RDS), but now different architecture databases are used at the same time, so migration problems arise.

My idea is database/migrations, folders, or it helps to manage multi-database migrations and virtual structures.

[henzeb]

I think it's a good idea. I'd suggest that each connection has a folder. So if you have a connection 'production' and a connection 'static-data' for data that almost never changes, we'd have migrate check the following folders for migrations and executes them per connection.

• databases/migrations/production
• database/migrations/static-data

Of course, the ones in the migrations root go to your default connection, for backward compatibility.

[JurianArie]

You can add migrations for multiple databases using https://laravel.com/docs/10.x/migrations#setting-the-migration-connection

[henzeb]

yes, but can we separate them in folders? I mean it's not really visible what migration goes where. Having them structured makes much more sense.

[bhargavraviya]

@JurianArie

The above question is for two types of databases MySQL and MongoDB

database/migrations/mysql 
database/migrations/mongodb

it working like
MySQL table in the migration log diff?
MongoDB table in the migration log diff?

how to manage this type of structure?

[JurianArie]

You can tell the migrate command to look at multiple paths:

framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php

Line 28 in 5a7f2b4

{--path=* : The path(s) to the migrations files to be executed}

[henzeb]

Yes, but it should do that automatically with the subfolders of those paths (or the default ones), which it is not doing right now.

[JurianArie]

@henzeb feel free to create a PR. I got it working by replacing glob with allFiles but I don't know if there are edge-cases.

framework/src/Illuminate/Database/Migrations/Migrator.php

Line 557 in 5a7f2b4

return str_ends_with($path, '.php') ? [$path] : $this->files->glob($path.'/*_*.php');

$this->files->allFiles($path)