How to write migrations from a dump in yii?

Question

Oracle

Good afternoon. An interesting problem has arisen. It is necessary to set yii migration bases on the dump. What I mean: there is a database dump, it contains about 4000 lines of requests for creating tables, procedures, and so on. and 1500 lines of queries, which make the project settings in some tables. At the moment, this dump is constantly updated and applied immediately after the schema is created. There was a task to shove this file on migrations. What is the best and most convenient way to do this? Maybe there is some kind of software that will help work with migrations?

Answer 1

Here https://github.com/schmunk42/database-command and here stackoverflow.com/questions/13605767/generating-mi... You can probably finish it for yourself. If you need to prepare migrations one-time, you can import the dump and set such a thing on the database.

Answer 2

What a masochism, to divide a large dump (considering that there are triggers and procedures) into php migrations, if you can do without them.