Re: syncing two databases
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 google-2...@ryandesign.comwrote: 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 cake-php+unsubscr...@googlegroups.com 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
syncing two databases
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. -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: syncing two databases
Do you mean Replicationhttp://dev.mysql.com/doc/refman/5.1/en/replication.html ? -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: syncing two databases
i use mysqlTool a software which does exactly that there might be some shell tools for cake - but they usually don't support all the elements (at least not the ones I needed) - so I didnt follow that any further On 29 Mrz., 23:04, Zaky Katalan-Ezra procsh...@gmail.com wrote: Do you mean Replicationhttp://dev.mysql.com/doc/refman/5.1/en/replication.html ? -- 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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: syncing two databases
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 cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php