i am trying to compare the data of two mysql databases using the redgate data compare tool for mysql. The tool identifies two databases with identical data as having different tables. How can i solve this?
So instead of spinning my wheels I want to take the guess work out of comparing two different databases for inconsistencies. I was wondering what rabbit hole I might run down in your opinion? What are the programs / software you guys are using to check for "diffs"?
Which brought up the question of mysqldiff vs mysqldbcompare anyway just wanted to reach and see what you guys use. Maybe you know of a standalone program? I thought of winmerge but it would require wildcards* and that's a whole other can of worms this guy isn't opening up.
What is the problem with Winmerge? I regularly use it. Export the structure or the whole database from two databases and comparing the resulting sql files usually works. Occasionally I need to put the sql file in a database to change all the prefixes when they aren't the same.
I would love to use Winmerge however trying to compare two databases with it chokes my computer because of the size of them. The computer freezes solid every single time. Now I'm only talking about less than 400mib per database and thought yea I should be golden. Maybe I will go back and shut everything off off and try again.
Yea I was on that site looking at it before I made these posts here. As like I said Winmerge just couldn't handle what I was throwing at it. Anyway long story short I ran msconfig and opened up task manager and shut down some stuff. Rebooted and Winmerge was able to open the files. I really should have done that first. It's not like I haven't been shutting stuff down since what win98? haha
795a8134c1