| krisztian pinter 2005-10-27, 7:41 am |
| On 25 Oct 2005 17:52:41 -0700, Manuel Rodriguez =
< ManuelRodriguez24@ya
hoo.com> wrote:
> I have a customer who has to stores. Let's call them A and B. He want=
s
> to be able to replicate the whole database in store A to store B and =
=
> vice
> versa.
you need to give a lot more details.
you said you don't need to filter any data, so the full data should be
replicated. ok.
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.
|