Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Newbie questions :)

2 posts in Replication Last posting was on 2006-03-06 09:28:29.0Z
Corinna Posted on 2006-03-04 20:32:16.0Z
Reply-To: "Corinna" <nutmegkat@gmail.com>
From: "Corinna" <nutmegkat@gmail.com>
Newsgroups: Advantage.Replication
Subject: Newbie questions :)
Date: Sat, 4 Mar 2006 14:32:16 -0600
Lines: 22
Organization: DataLogic Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 64.219.153.57
Message-ID: <4409f88d@solutions.advantagedatabase.com>
X-Trace: 4 Mar 2006 13:29:01 -0700, 64.219.153.57
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.219.153.57
Xref: solutions.advantagedatabase.com Advantage.Replication:90
Article PK: 1133949

I'm waiting to receive the appropriate licenses to begin developing with
replication, so I don't have any practical experiences yet. But I *do* have
questions :)

Our scenario is that there will be an office server and mobile laptops,
which then come back to the office and automagically commit their changes
using replication.

1) What happens if someone in the office changes a record while the laptop
is away, and then that user comes back? Will this automatically merge
correctly, will the laptop overwirte the record, or will the laptop's record
not get written?

2) What happens if two laptops change the same record, and then they come
back to the office?

3) Will there be scalability issues along these lines as the number of
mobile users grows?

-Corinna


Joachim Duerr (ADS Support) Posted on 2006-03-06 09:28:29.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Newbie questions :)
Newsgroups: Advantage.Replication
References: <4409f88d@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.17.6.5
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <440c00bd@solutions.advantagedatabase.com>
Date: 6 Mar 2006 02:28:29 -0700
X-Trace: 6 Mar 2006 02:28:29 -0700, 195.2.185.25
Lines: 27
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Replication:91
Article PK: 1133948


Corinna wrote in <4409f88d@solutions.advantagedatabase.com>:

> 1) What happens if someone in the office changes a record while the
> laptop is away, and then that user comes back? Will this
> automatically merge correctly, will the laptop overwirte the record,
> or will the laptop's record not get written?

Since it is a push replication you need to specify all your laptops on
the office server as subscriptions. Then the server will push the
changes to the Laptop as soon as it's available.

> 2) What happens if two laptops change the same record, and then they
> come back to the office?

ON CONFLICT TRIGGER

> 3) Will there be scalability issues along these lines as the number
> of mobile users grows?

yes, for sure. But they should not affect the overall performance to
much since you seem to have a hierarchical structure.

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de