title: DBIx::Class upgrade in Catalyst (DBIx::Class::Schema::Loader)
body: <p>I am using Catalyst for an application and am getting ready to upgrade the production version to the next major release. In the new release a lot of changes have been made to the database. The ORM in Catalyst is created with DBIx::Class::Schema::Loader from the physical development database. In frameworks like rails the ORM works the other way around and migrations from one version to the next are simple. </p>
  
  <p>Can anyone tell me whether there are solutions for creating an alter script that changes an old version of the database to a newer? I tried mysqldiff, MySQL Workbench (synchronize option is broken), RedGate, Toad for MySQL and a number of other tools. There has to be an easier way to do this in a Catalyst application or DBIx::Class model for that matter. </p>
  
  <p>Can anyone help me? Thx</p>
  
  <p>Rob</p>