Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unhappy Unanswered: Replicating data

    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?

  2. #2
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Re: Replicating data

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •