A guest blog by Dr. Robin Bloor , Bloor Research
Database replication is simple, right? You pick the tables to replicate, copy them and then apply new transactions to them (from a log file) to keep them up-to-date.
Actually, it’s not so simple. In fact most databases don’t do it well at all. We need to distinguish between data copying and sophisticated replication, because copying actually is simple.
But why would anyone want to replicate data? I think there are three reasons: