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 2007-02-22 11:47:23.0Z
Jim Gabriel Posted on 2007-02-16 20:53:53.0Z
From: "Jim Gabriel" <nospam@gmail.com>
Newsgroups: Advantage.Replication
Subject: newbie questions
Date: Fri, 16 Feb 2007 12:53:53 -0800
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 71.104.97.138
Message-ID: <45d618e6@solutions.advantagedatabase.com>
X-Trace: 16 Feb 2007 13:49:42 -0700, 71.104.97.138
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!71.104.97.138
Xref: solutions.advantagedatabase.com Advantage.Replication:176
Article PK: 1134034

I'm really new to this concept of 'replication'. I do have a couple of
questions...

1) Is the data is COMPLETELY replicated in all places? If so, if the
database were 700meg and another client app were to connect to the main
database, would ALL that data be replicated local on that client's machine?

2) When does the process of synchronizing happen?

3) Would 'replicaion' help client apps to work locally when the master
database over the internet is unavailable?

4) If the data is replicated in mulitple places, I suppose stored procedures
(AEPs) and triggers would also be replicated at the client's site.

5) This dispersed data sounds like a synchronizing nightmare. Is it really
or does this 'replication' product make it a dream?

6) What additional licensing is required for all connected clients above the
server license?

Jim


Joachim Duerr (ADS) Posted on 2007-02-22 11:47:23.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: newbie questions
Newsgroups: Advantage.Replication
References: <45d618e6@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
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: 130.214.79.11
Message-ID: <45dd82cb@solutions.advantagedatabase.com>
Date: 22 Feb 2007 04:47:23 -0700
X-Trace: 22 Feb 2007 04:47:23 -0700, 130.214.79.11
Lines: 50
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.Replication:181
Article PK: 1134038


Jim Gabriel wrote in <45d618e6@solutions.advantagedatabase.com>:

> 1) Is the data is COMPLETELY replicated in all places? If so, if the
> database were 700meg and another client app were to connect to the
> main database, would ALL that data be replicated local on that
> client's machine?

no. just the data changes since you set up a subscription for that
client.

> 2) When does the process of synchronizing happen?

It's a replication, not an synchronisation!!! (sorry for shouting...but
that's a very, very important difference).

Replication happens in the background...
- immediately after data changes if the other server is available
- when you call ProcessReplicationQueue
- after some time if the replication queue grows and the subscribed
server was not available

> 3) Would 'replicaion' help client apps to work locally when the
> master database over the internet is unavailable?

yes. The client app can always work on a local installed ADS server,
independant if the master database is available or not.

> 4) If the data is replicated in mulitple places, I suppose stored
> procedures (AEPs) and triggers would also be replicated at the
> client's site.

no.

> 5) This dispersed data sounds like a synchronizing nightmare. Is it
> really or does this 'replication' product make it a dream?

again: it's not a synchronisation!!! Replication works well so far if
you use it in the way it was designed.

> 6) What additional licensing is required for all connected clients
> above the server license?

every subsription needs a server license, every publisher needs the
replication license. Ask your sales rep for more details and prizing.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com