Monday, August 4, 2008

MySQL Schema\Data Comparison?

In my previous post  I spoke about our company's intent to step into the MySQL market. I described the rational and the general idea behind it.

Few weeks have passed and we are soon to be ready with our Data Comparison tool . (do not download yet since right now it only supports SQL Server) so I thought I'll be thinking aloud here specifically about that.


tools are extremely useful. If you are a developer or a DBA who is working with more than a single copy of the database (and that's. everybody) - you need it. And while there are endless companies who offer solutions for that in other areas, including one recent solution coming out from Microsoft themselves - surprisingly, there aren't much solutions in the MySQL world.
Why is that?
(Well, I'm not speaking rhetorically here. I really want to know. Do provide me your opinions)


Speaking with some MySQL people, I have learned that many use a comparison feature that exists in some other product - like the TOAD editor. Which tools are you using? Are you happy with them? What are their main weaknesses?
I'm actually quite excited about what we got coming up our sleeves. It does exactly what it says it is, its simple and easy to use, and it does both schema and data in one shot. (and its MySQL version will be offered for free) But of course,  we do want to know what else out there.
So do let us know!
Jonathan