On Mar 29, 2011, at 11:29, cake-learner wrote: > Is there any way to sync tables schema between two databases? > I have already set up a script to push source code to live whenever > it's ready, but > i want to know there is a way to sync tables to make sure any changes > on database > will be updated to live database as well. I know there are a couple of > ways to do it and saw > that desktop application to do it, but i want to know if there are > ways that more people follow.
I think the CakePHP way is to use the Migrations plugin. https://github.com/CakeDC/migrations This is not automated of course. It requires you to think about changes you make to the database and recording each properly. Database migration is a complicated topic. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
