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-encodingcollation-into-another.html /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 -~----------~----~----~----~------~----~------~--~---
