After digging into this it became obvious that you almost have to design replication as an application consideration, it's that integral in the database.

Thank you for your response.