This is really a question of requirements and possibilities. I am presuming that you have looked over the High Availability and Replication documentation and you are looking for something more flexible.
In Streams, there are no explicit constraints for table design or structure. Yes, you can have different PKs in tables of two databases. That being sai