dbTalk Databases Forums  

Help with replication

sybase.public.sqlanywhere.replication sybase.public.sqlanywhere.replication


Discuss Help with replication in the sybase.public.sqlanywhere.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Manuel Rodriguez
 
Posts: n/a

Default 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
versa.

He is using ASA 9.0.2.3044. I have never done any replication so please
tell
me the easiest way to do it.



Reply With Quote
  #2  
Old   
krisztian pinter
 
Posts: n/a

Default 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:

Quote:
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
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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.