free case study: ShahidNadeem's unbiased review of Oracle GoldenGate

For small databases that are less than a terabyte, GoldenGate handles the migration well. You don't need much input so long as the processes don't upend. As soon as there's a problem, then, obviously, you need to diagnose it. It all depends on the scenario, on the size of the databases, whether you're doing schema replication, or table...