yes today it is a not so regular day for technoreaders, yes i have started working on one small script (project) ”Mysql Database structure comparison“. New thing about this project is it open to everyone while its development only. I have never done such thing in past.
So you can checkout and have a look at the code, and also you can contribute.. if you want.
svn checkout http://mysql-database-structure-compare.googlecode.com/svn/trunk/ mysql-database-structure-compare-read-only
First of all this script is not intended to handle any kind of data comparison. It is purely and only for comparison of its table structure.
Development will be divided into two phase. In phase one we will just show the difference and in phase two we will also give user a query to make both the database in sync.
Comparison will be divided into steps given below.
- Connection to both the servers
- Selection of both the database
- checking number of tables present
- comparing tables
- comparing table fields