Implementation Till Mid Evaluation!

This is the first screen that appears when "Synchronize" tab is pressed. Here the user has to enter host name, username , password, port, and database name of the source and target databases which are to be synchronized.



When "Go" is pressed this screen is shown. Here firstly there is information for the user that red box with 'S' on it is an indication that there is structural difference, blue box with 'T' is for type difference and green box with 'D' is for data difference between source and target databases.
Theses colored boxes are shown infront of the table names to show the three type of difference between source table and target table. These boxes infront of the table name are clickable.



When the green box in front of the table 'Course' is clicked the color of the box changes to grey and the details as what difference is there is shown with a check box below the table. Like in the screen shot it is shown that '1 row to be updated and 1 row to be inserted in "course" table.'



Tables that are present in the source and not in the target are shown with a "+" sign and tables that are present in the target and not in the source are shown with "_" sign.

Now the user can select the changes with the check box and apply the selected changes with the button "Apply Selected Changes".

Button "Synchronize databases" will synchronize the target database with the source database. Whereas "Apply Selected Changes" will only apply those changes which have been already selected by the user by pressing the colored boxes in front of the table name and then by checking the check box.