Hello The latest version of SQLyog at http://www.webyog.com/sqlyog/download.html contains a very powerful diff tool and it is free. Try it out.
Insane ----- Original Message ----- From: "Daevid Vincent" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 6:58 AM Subject: Is there a SQL/diff program out there? > I searched google, but didn't find anything. > > SYNOPSIS: > > Wondering if anyone knows of, or has built, or is interested in building > a program that will take two .sql schema dumps (one new and one old) and > create the ALTER / CREATE TABLE syntax to make the old one look like the > new one. It should work in such a way that it doesn't matter if the > table's schema are in the same order or not. > > REASON: > > We do a lot of development on our dev server and this involves creating > new fields in the databases and even new tables. We have to manually go > through using a script and update all the 'live' databases then so they > jive with our dev environment. It's quite tedious to remember all that's > changed and manually make the 'alter table' syntax ourselves. > > I'm surprised this isn't a more common tool request and it doesn't exist > already -- at least none that I can find. There are ten million mySQL > graphical clients out there, you'd think one of them would have such a > useful feature. > > Is this something that people would want/use? If so, I'll build it. I > just didn't want to spend the time/energy if it existed already > somewhere. > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php