Maybe for now I just set up a a file with sql command to propagate changes to the live database when pushing code to live.
On Tue, Mar 29, 2011 at 4:06 PM, Ryan Schmidt <[email protected]>wrote: > > 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 > -- 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
