What is the best approach for upgrading a production database?

Question

symfony

I'm confused, both ConsoleCommand and Migrations work fine.
In fact, to update the database prod, you need security and confidence that the script will pass as it should.
Both options are transactional and can use DQL, which is quite convenient.
The upgrade is often single and after execution the code will be deleted, so it is worth adding more speed and clarity of what needs to be done.
Here I am leaning towards the console command. it can also be reused later for other scripts and there is immediately access to services, in migrations a little differently, and also because after deleting the migration, its name will be in the database migration table, which we do not need. Perhaps I missed something about migrations and in some cases it is still worth using them, right?

So what and when to use?
What is better and why?