PDA

View Full Version : Windows Based Diff Tool

flint
01-04-02, 11:43
Anyone know of a good windows based diff tool that can compare two different mysql database for missing tables, columns, etc.? No need for data comparison.

Thanks
rwilkerson
02-11-02, 13:32
Just trying to keep this alive. Maybe someone will have a suggestion...
achorozy
02-11-02, 13:50
There is a GUI product coded WINDIFF that you can download, search on Google (http://www.google.com), or if you like to use Unix commands here is a bundle of Unix tools for Win32

GNU utilities for Win32 (http://unxutils.sourceforge.net/)

You can then use diff.exe
rwilkerson
02-11-02, 14:12
Yeah, I have WinMerge - a very good diff tool, but good for flat files. It doesn't compare database schemas. Toad does this nicely, but is also pretty costly. Be nice to find something cheaper, if not free.

I think that's what flint was looking for and I know that's what I'd like to find. <grin>

Thanks.
achorozy
02-11-02, 14:22
Sorry about that prior post, really has no use to this question. However there is a Perl program called MySQLDiff.pl

MySQLDiff (http://adamspiers.org/computing/mysqldiff/)

This not only compares to schemas, but generates the ALTER script. It uses the MYSQLDUMP utility with the -d flag to produce the schema for a database.
rwilkerson
02-11-02, 14:30
That sounds a lot more like what we're looking for, thanks. Do you know if it is functional in a Windows environment? The examples seemed very linux/unix-centric, but I'm not very familiar with either.

Anyway, thanks for the suggestion. It looks like it'll do exactly what I'm looking for if I can get it to work in windows.
achorozy
02-11-02, 14:56
I use it in a Windows envirnomnet. The INSTALL file has the following commands to do to install


perl Makefile.PL
make
make test
make install


For Windows use NMake instead of Make, which can be found at

Win32 NMake (ftp://ftp.microsoft.com/softlib/mslfiles/nmake15.exe)
rwilkerson
02-11-02, 14:59
Outstanding. Thanks again.