For data synchronization I was able do the following tasks :

• Accessed data from source and target databases.
• Mapped the matching and non-matching tables in the source and target databases.
• Saved the data difference.

I yet have to apply the data difference on the target database. For all the work I have done till now source and target databases resides on the same server.

Problem that hindered my work was that data could not be retrieved by $_REQUEST and $_POST if require_once is there in the file. Therefore, the code written so far is hard coded for values of servers.

I have mailed the first patch to my mentor and am waiting for suggestions for the work done till now.

Coding and testing the corresponding queries required to apply the data difference between the target and source databases. Start to code GUI 2.