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?

hi,

I do not understand why you duplicate the data.
Do you can share the information in both db federating this.

For example,
in the db A you are the following tables:
ta1, ta2 and ta3
and in the db B
tb1

Federating both db you can:

select * from ta1 join tb1.....

Abel.