Mysql db struct comparison – open source project

Posted on by




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 details

svn checkout http://mysql-database-structure-compare.googlecode.com/svn/trunk/ mysql-database-structure-compare-read-only

Project URL

http://code.google.com/p/mysql-database-structure-compare/

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
This is what is planned so far. as time goes on we will also make improvements.
Note:
here we will treat one database as a master and other as a slave. so suggested changes will only target slave database. Also this is my first time with Code.Google.com so if you find any mistakes please inform.

 

  • Gerard

    http://www.comparesqltables.com

    Something like that ?

  • http://www.technoreaders.com/ Jigish Thakar

    no in case of comparesqltables you ll have to go through all the tables, to check the diffrences..
    where as this one will give you all the difference in one go

    and next version will also give you the sql to make things in sync