DBIx :: Updating a Class in Catalyst (DBIx :: Class :: Schema :: Loader)

Question

I am using Catalyst for the application, and I am ready to upgrade the production version to the next major version. In the new release, a large number of changes have been made to the database. Catalyst ORM is created using DBIx :: Class :: Schema :: Loader from the physical development database. In structures such as rails, ORM works the other way around, and migrations from one version to another are simple.

Can someone tell me if there are solutions to create an alter script that changes the old version of the database to a newer one? I tried mysqldiff, MySQL Workbench (the synchronization option is disabled), RedGate, Toad for MySQL and a number of other tools. There should be an easier way to do this in a Catalyst application or DBIx :: Class model.

Can anyone help me? thank

Rob

Answer 1

Checkout DBIx :: Class :: DeploymentHandler . This is not the easiest way to dive, but it is probably exactly what you want. There is a good, if not brief, record of some of its features here: DBIx :: Class :: DeploymentHandler Awesome .