At work I’ve been maintaining a number of development areas and needed a way to compare database changes so that I didn’t overwrite a clients changes with my new/updated data from developing a new feature.
There seemed to be many ways of comparing the schema of two databases, but nothing to compare the changes in data (unless I was looking in the wrong places). I decided to write something that would help me out and have released it publicly.
You provide the connection details of two databases (server, username, password, name), select the tables you would like to compare and hit “Compare”. The resulting page is a list of all schema and data changes.
There are plans to style the application (at the moment its simple blocks and tables) and more importantly, allow you to select which differences you would like to apply before creating a .sql diff file.
If its something you’re interested in, trying check out the google code page for the project. Its currently in beta with better performance, stability and functionality to come!
3 Comments
hi, you can use third party tool for that, although its not free it does a terrific job of comparing\migrating data.
Nob Hill’s Compare – http://www.nobhillsoft.com/NHDBCompare.aspx
Yeah, I did find the Nob Hill software, as well as a number of other shareware/commercial products. The aim with phpMyDiff is to create a free alternative, that is, when I get round to writing the export diff functionality.
I for one wouldn’t want to pay $99 for infrequently comparing database changes.
Hi,
Thanks a lot for this tool, just what I needed.
Generating sql code would be fantastic.