Server Fault is a question and answer site for system and network administrators. 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

Is it possible to setup some kind of smart replication, so that these columns are automatically updated if they are changed in another database ..

Like : rows are automatiically added, some columns are automatically synced, but other columns are not

share|improve this question
Let's say you have a four-column table. You want (for example) to sync only two of them. Is this what you want? – Khaled Nov 23 '10 at 7:47

Do you want to perform an action on the same database server rather than a remote DB? If so, the device you want are triggers:

share|improve this answer

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.