While our main MySQL database administrator is on leave for several weeks, our programmers made a copy of a CRM database to conduct series of testing. Now with the database guy is back, he want to check if the developers made some changes on the database so he can update its documentation. To accurately check for the changes, he have to compare the original database against the copied test database. If you are on a situation like this, you can automate the comparison using a free tool called Mysql Structure Compare.The purpose of this tool is to allow the user to compare two MySql databases and have the differences between a "source database" and a "target database" output in SQL.
Mysql Structure Compare is a portable app so there is no need for the installation, simply download and run it. Specify the remote host IP, the databases names to be compared, and the login details for your remote mysql server and their connection ports. If all are set, just hit the "Compare Databases" button to start the comparison. This app supports Linux, Windows XP, Windows Vista, Windows Server 2003/2008, and Windows 7.
Download MySQL Structure Compare via [rubyforge.org]
For More MySQL Tools, subscribe now.
0 comments:
Post a Comment