| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Replication question
Hannah - Thanks for the ideas. I simply must suggest to the users that they
draw up the requirements first. Oops I mentioned that in the last meeting.
Seemed to be a sensitive question, or maybe I asked it with my usual tact
and aplomb.
Thanks for clarifying that each replication product has its own conflict resolution methods. In a superficial conversation, it sounded like Sybase faces many of the same issues. Fortunately we don't have to deal with cross-platform issues. This is a new system that we are just now designing.
But your reply has provided me with more perspective on replication design decisions. Thanks.
Dennis Williams
DBA, 20% OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Thursday, June 20, 2002 8:38 AM
To: Multiple recipients of list ORACLE-L
Dennis,
Actually each replication product has its own conflict resolution algorythms. Basically, determine your replication requirements (do NOT think about conflict resolution yet). IE. Think of your sources and targets, what platforms, how many, which direction etc. Then search the available technologies: Oracle, Quest Shareplex, ITI Shadbase, Datamirror etc......
Find the product that can handle your needs and requirements (ie. If you are replicating from a mainframe to Oracle -well, some products just don't do that), then see how the product handles the conflicts and if their way is acceptable to you for your needs. I dont recall off hand but some may even give you some room to decide how youd like to handle things. I believe that Datamirror allocated an extra column for a source in a multi-source to single target situation.
Just some thoughts.
Hannah
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: johanna.doran_at_sungard.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 20 2002 - 10:38:53 CDT
 |
 |