This has been asked for many many times on this list, not sure why mySQL AB doesn't just release a command line tool like a 'mysql diff' and also a 'mysql lint'. The lint one should be totally trivial for them to do, as they already have a SQL parser! I can't tell you how many times our daily build was broken by a missing semi-colon or some other SQL syntax error. We run all commits through "php -l" and ruby's checker, but mysql is the only one we have to sweat over.
While I'm glad that pretty GUI tools like Upscene's exist, that doesn't do us any good on a linux build system where it does an "svn checkout", runs automated BVT tests, compiles code, uploads to a daily build directory, etc. We need command line tools that run on linux. :( > -----Original Message----- > From: John Comerford [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 27, 2007 9:49 PM > To: mysql@lists.mysql.com > Subject: DB Schema Comparison Utility ? > > Hi Folks, > > I am new to MySQL. We have a development environment where we have > three systems > > 1) Developement Database on Machine A > 2) Test Databasae on Machine B > 3) Live Database on Machine C > > So we make changes to the Developement Database, then move > them to test > then to live. My question is, is there a way of > automatically migrating > the changes from Dev to Test, Test to Live ? > > I have worked with a DB which had an admin function wherein you could > connect two databases and it would run a comparison between the two > databases and produce a file of schema differences which you could > import to make the two DB schema's the same. Is there something like > this for MySQL ? > > TIA, > John > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]