Re: data replication tool

"Christoph Seidel" <christoph.seidel1_at_gmx.de> wrote

> > Maybe if you tell us what business requirement (or technical one) you
> > are trying to address...?
>
> The DB contains configuration data of a business app. Some of these data
> should be transfered from a test to a prod system - only some, not all. The
> test system is a playground, some configurations maybe not in prod state,
> some are just for testing, some are fine and shall be transfered into prod.

You do not need replication for that at all. Besides, it is a scary thought of replicating data from a test/dev system into a production system.

This in my mind requires a strict, formal and interactive process to apply the selected config parameters from the Test system to the Prod system. Nothing automated. With in-built configuration rollback (on Prod), full blown auditing and as many fail safes as possible.

Wait till you work with a billing system where someone "accidentally" gets a critical billing parameter wrong and screw up billing, causing billing deadlines not to be met...

You want to risk replicating config parameters from a test system!? <shudder>

--
Billy