Post reply

Replication config. & architecture

  • March 20, 2005 at 10:08 am

    #87823

    Hi all, Haven't found any discussion threads on my problem.. if I'v missed one please point me to it. thx.

    ----------

    We need to replicate changes (1 table in each db: ErrorLog) from mulitple databases to a central database (1 table: ErrorLog). The source data (ErrorLog) contains error information specific to that db instance. The destination table contains ALL data, from ALL sources.

    1) Need to insert servername, sourcedatabase AT DESTINATION.

    e.g.

    SourceTable on Server1 DB1 entry: ErrorLog

    234443 "gpf error" "client app failure"

    SourceTable on Server1 DB2 entry: ErrorLog

    34554 "login failed" "user not found"

    becomes 2 entries in Destination Table & db:

    Server1 DB1 23443 "gpf error" "client app failure"

    Server1 DB2 34554 "login failed" "user not found"

    ----------------------------------------------------

    Hope this is clear enough. I was planning on using Merge replication.

    TIA !!

    Joe

  • March 21, 2005 at 9:41 am

    #548039

    I believe I have found a way to solve the problem I describe above.  However, if anyone has an opinion   please feel free.

    Tenative solution:  Create a view that incorporates the servername and sourcedatabase in addition to the underlying data.  Then, replicate THAT view.  

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply