Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have many websites with Development, Staging and Production servers. We have many developers for many projects. We need a solution to synchronize the developer and staging databases. After that one is worksing we can move to the live database.

That one needs to be fully automatically synchronized so that developers don't need to run that tool each and every time.

share|improve this question
1. I did not understand your question, what you want is data from Dev_server to Stagging_Server, does the same apply to the other way? Stagging_Server to Dev_server ? 2. when you finish your development you want to have the data from Stagging_Server to be loaded on Production server once, is that correct? – altmannmarcelo May 15 '13 at 10:18
You can synchronize through "SQLYog Ultimate Tool" Tools->SQLyog Database Synchronization Wizard-> (source) & (Target)->One-way-synchronization or two-way-synchronization – Md Haidar Ali Khan Feb 1 '15 at 12:31

use replication master=> slave ? be carefull of conflict

share|improve this answer
You should add more detail. Perhaps how to do the replication at a high level, or point to some documentation sources, etc. – Max Vernon Apr 15 '13 at 14:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.