I have two applications writing to two databases, which are modeleddifferently and the new one used by the new app has a larger number of attributes. Both db's are needed to continue working but they should be able to provide a single data view - a record from one should exist in the other with more or less attributes depending on the db. Essentially 2 db's are being used but must provide a single view. I will need to replicate data across both db's in real time.
If I insert a record into one db I need to be able to see a corresponding record in the other db and vica - versa.
I have thought of using triggers but that will just create a loop.
Does anyone have any ideas as to how I would go about doing this?