Database synching is something we really need when we are having a local database server for development and a remote database for demoing purposes. even though we write ER diagrams by analyzing the customer requirements, naturally requirements are born to change so we have to change our object model as well as the database structure accordingly in our local environment and then we often need to re synchronize the local and the remote server.

We use SqlYog for all our Mysql Based projects, and it provide a handy set of tools for such needs.

This is very easy process

1. Open SQLyog powertools and select “Database Synchronization Wizard”
2. Tic “Start a new job” and hit next
3. You need to give the source database connection info and the Target Database connection info.
   This step is vital, you need to identify which is the target and the which is the source..  source is for coping the data and target will be edited to match the source
4. Next you have an option to select whether this is a one way synching or two way,  oftenly we use the first option
5. Rest of the steps are easy to understand,  you can either generate the script file or sync the databases at this point by selecting the tables you want to sync
6.