Re: syncing two databases

[Shinya Koizumi]

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 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
> 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

Re: syncing two databases

[Ryan Schmidt]

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

Re: syncing two databases

[euromark]

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  wrote:
> Do you mean 
> Replication
> ?

-- 
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

[Zaky Katalan-Ezra]

Do you mean Replication
?

-- 
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

[cake-learner]

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