Help with replication - 10-25-2005 , 07:52 PM
I have a customer who has to stores. Let's call them A and B. He wants
to be able to replicate the whole database in store A to store B and vice
He is using ASA 22.214.171.12444. I have never done any replication so please
me the easiest way to do it.
Re: Help with replication - 10-26-2005 , 02:40 AM
On 25 Oct 2005 17:52:41 -0700, Manuel Rodriguez
<ManuelRodriguez24 (AT) yahoo (DOT) com> wrote:
you said you don't need to filter any data, so the full data should be
other point: you can strictly separate the origin of all data? you can
make sure there will be no conflicts, that is, a value modified by
two sites concurrently? if there can be concurrent modifications, what
you can do to resolve? you need conflict resolution policies for all
possible parallel modifications.
also, it is possible that you will need to modify the database a bit.
a replicated environment is not that straightforward. for example,
you need to decide if trigger generated modifications should or should
not replicate. that's a one time decision, and both ways can introduce
problems if care is not taken.
unique key generation is another issue. in fact, any unique contsraint
is an issue.
so we need those details.