Hey guys check it out! This guy just solved distributed databases.

This works until one of the DBs is down, or someone queries two if them at the same time. Without rollback you get the TSB fiasco.

Not sure why this would turn you off to an organization as this is a very common problem.

My money is on your suggestion being what most organizations actually do, though perhaps with a workflow process to manage it.

Legacy systems are hard.