Laravel: how to migrate and process data from old DB?

Question

MySQL

Good afternoon,
There is an old site with a bunch of different data. I recently wrote a new engine for it in Laravel. The site is constantly working, the database is constantly used, the data is very important. During the transfer, the site can be disabled, but for a couple of hours at night.
The only question is how to transfer the base.
The new database has a different structure than the old one. Just changing the names of tables or fields will not work, you need to write a script for processing.
You need to get all the data from the old database and push it into the correct tables and fields in the new one. What is the best way to do this?

Answer 1

Well, if Laravel has the ability to connect to several databases at the same time, then connect and take something from one database, process and write to another
$users = DB::connection('foo')->select(...);