Thanks for your replies guys. I am trying out all options right now, will let you know my feedback soon.
On Oct 30, 7:07 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > There are a bunch of tools for a bunch of operating systems (and a > bunch of databases). > I have only ever used MySQL, so this will concern itself with that db. > > If you need to keep track of charsets and collations you should choose > your weapon carefully. For Mac OS X I have only found Navicat (costs > money) to deal with those things fully... and that, only recently > after I begged them to implement some missing details. Most other > software have partial support or no support at all. Partial is the > worst since it will after a few updates create a real mess of settings > in your db. > > If you don't care about those things being in sync then you have a lot > more options. > mysqldiff.org is a php script that can compare real databases or dump- > files. Free. Works but is no longer maintained. > I also read about something called SQLSync a few weeks ago. I haven't > used it yet but it might be > good.http://silvercoders.com/index.php?page=sqlsync > > In addition to that you can in some cases use this script I found to > help with collation and charset > changes.http://bogdan.org.ua/2008/02/08/convert-mysql-database-from-one-encod... > > /Martin > > On Oct 30, 1:21 pm, Abhimanyu Grover <[EMAIL PROTECTED]> wrote: > > > I'm sorry this is not Cake related, but I feel its something which > > most of developers are missing. I found info about Cake migrations and > > think it would be too difficult to implement it in my team in short > > time. What tools or techniques are you using to overcome this problem? > > > I'm aware of a tool called SqlYog or something, which is capable of > > keeping database structured sync'ed from dev. machine to server, but > > its paid, and I'm looking for some open source alternative, maybe a > > simple PHP script or something. Please let me know what do you guys > > use and recommend for a small team? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
