Here is the target setup:

Multiple LOCAL MSDE DB with one REMOTE Master Oracle DB (Internet) through multiples FireWalls.

The LOCAL MSDE DB are there for OLTP, the master Oracle DB gets all those Trx and contains all the configuration (Static Data) info.

So replication wyse, TRXs from MSDE need to be propagated up and configuration need to be propagated from Oracle down to MSDE.

Anyone with actual experience implementing this ? I'd like to know the best working setup for this and have an idea of the effort required.

Thanks!