Multimaster Bi-directional Streams PLUS one way Stream to third DB.
I am sure I will be embarrassed by having missed a simple trick for this.
We have been running a bi-directional multimaster Streams between a database in the USA and one in Malaysia for over two years. Now I need to stream the same schema from the OLTP database in the US to a data warehouse instance also in the US. What I encountered was that only the transactions occurring in the US OLTP database were being applied to the US DW instance. Changes made in the Malaysian OLTP instance were applied to the US OLTP but NOT "forwarded" to the
0