title: Good DB Migrations for CakePHP?
body: <p>I have been trying a few migration scripts for CakePHP but I ran into problems with all of the in some form or another.</p>
  
  <p>Please advice me on a migration option for Cake that you use live and know works.</p>
  
  <p>I'd like the following "features":</p>
  
  <ul>
  <li>Support CakePHP 1.2 (e.g. CakeDCs migrations will only be an option when 1.3 is stable and my app migrated to the new codebase)</li>
  <li>Support for (or at least not halt on) Models with a different database config.</li>
  <li>Support Models in sub-folders of app/models</li>
  <li>Support Models in plugins</li>
  <li>Support tables that do not conform to Cake conventions (I have a few special tables that do not have a single primary key field and need to keep them)</li>
  <li>Plays well with automated deployment via Capistrano and Git.</li>
  </ul>
  
  <p>I do not need rails-style versioned files a git versioned schema file that is compared live to the existing schema will do. That is: I like the SchemaShell in Cake apart from it not being compatible with most of my requirements above.</p>
  
  <p>I have looked at and tested:</p>
  
  <ul>
  <li>CakePHP Schema Shell <a href="http://book.cakephp.org/view/734/Schema-management-and-migrations" rel="noreferrer">http://book.cakephp.org/view/734/Schema-management-and-migrations</a></li>
  <li>CakeDC migrations <a href="http://cakedc.com/downloads/view/cakephp_migrations_plugin" rel="noreferrer">http://cakedc.com/downloads/view/cakephp_migrations_plugin</a></li>
  <li>YAML migrations <a href="http://github.com/georgious/cakephp-yaml-migrations-and-fixtures" rel="noreferrer">http://github.com/georgious/cakephp-yaml-migrations-and-fixtures</a></li>
  <li>joelmoss migrations <a href="http://code.google.com/p/cakephp-migrations" rel="noreferrer">http://code.google.com/p/cakephp-migrations</a></li>
  </ul>