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.

Replication over the internet

6 posts in Replication Last posting was on 2007-01-26 23:38:33.0Z
Paul Man Posted on 2007-01-25 12:47:48.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
Subject: Replication over the internet
Date: Thu, 25 Jan 2007 12:47:48 -0000
Lines: 6
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45b8a62c@solutions.advantagedatabase.com>
X-Trace: 25 Jan 2007 05:44:28 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:152
Article PK: 1134010

If I set up replication to operate over the internet what ports should I
open and forward in the firewall on both sides? Does compression apply to
replication connections and is there anything special required to implement
WAN Vs LAN replication?


Mark Wilkins Posted on 2007-01-25 16:06:58.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <45b8a62c@solutions.advantagedatabase.com>
Subject: Re: Replication over the internet
Date: Thu, 25 Jan 2007 09:06:58 -0700
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45b8d49e@solutions.advantagedatabase.com>
X-Trace: 25 Jan 2007 09:02:38 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:155
Article PK: 1134016

Hi Paul,

In general, you need to open up the same port and set up compression options
just like you would for any Advantage application. The difference is that
the source server (ADS) is the client "application". Advantage Database
Server uses the Advantage Client Engine to communicate with the target
server. When you set up the subscription at the source, you choose the
target connection type (under the Advanced tab in the subscription dialog
properties if using Advantage Data Architect). This is simply choosing the
connection type that the source server will make to the target. If you
choose "Advantage Internet Server" as the connection type, then the port in
the firewall to open would be the "Internet Port" that is configured at the
target. If you leave the default settings for compression at the target
(and in the ads.ini at the source), then compression will be on for an "AIS"
style connection.

Mark Wilkins
Advantage R&D

"Paul Man" <paulman@datasoft.ie> wrote in message
news:45b8a62c@solutions.advantagedatabase.com...
> If I set up replication to operate over the internet what ports should I
> open and forward in the firewall on both sides? Does compression apply to
> replication connections and is there anything special required to
> implement WAN Vs LAN replication?
>
>


Paul Man Posted on 2007-01-26 16:12:53.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
References: <45b8a62c@solutions.advantagedatabase.com> <45b8d49e@solutions.advantagedatabase.com>
Subject: Re: Replication over the internet
Date: Fri, 26 Jan 2007 16:12:53 -0000
Lines: 37
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45ba279a@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2007 09:08:58 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:156
Article PK: 1134013

thanks.
If we have a vpn over the internet then I'd assume compression would be the
best option...

"Mark Wilkins" <mark@no.email> wrote in message
news:45b8d49e@solutions.advantagedatabase.com...
> Hi Paul,
>
> In general, you need to open up the same port and set up compression
> options just like you would for any Advantage application. The difference
> is that the source server (ADS) is the client "application". Advantage
> Database Server uses the Advantage Client Engine to communicate with the
> target server. When you set up the subscription at the source, you choose
> the target connection type (under the Advanced tab in the subscription
> dialog properties if using Advantage Data Architect). This is simply
> choosing the connection type that the source server will make to the
> target. If you choose "Advantage Internet Server" as the connection type,
> then the port in the firewall to open would be the "Internet Port" that is
> configured at the target. If you leave the default settings for
> compression at the target (and in the ads.ini at the source), then
> compression will be on for an "AIS" style connection.
>
> Mark Wilkins
> Advantage R&D
>
> "Paul Man" <paulman@datasoft.ie> wrote in message
> news:45b8a62c@solutions.advantagedatabase.com...
>> If I set up replication to operate over the internet what ports should I
>> open and forward in the firewall on both sides? Does compression apply to
>> replication connections and is there anything special required to
>> implement WAN Vs LAN replication?
>>
>>
>
>


Mark Wilkins Posted on 2007-01-26 17:15:35.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <45b8a62c@solutions.advantagedatabase.com> <45b8d49e@solutions.advantagedatabase.com> <45ba279a@solutions.advantagedatabase.com>
Subject: Re: Replication over the internet
Date: Fri, 26 Jan 2007 10:15:35 -0700
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45ba3632@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2007 10:11:14 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:158
Article PK: 1134015

Probably so. It depends on a lot of factors, but I think that most of the
time using compression would help in that situation. If, however, the
tables being replicated do not have large memo or blob data, then it is
possible that leaving compression off might actually be better. Replication
does not involve reading large batches of records like a "normal" user
application does; that type of operation almost always benefits from
compression in a low bandwidth situation. For the most part, replication
involves running SQL update statements against the target. If the tables
consist mostly of fixed width data, then compression may not help.

Mark Wilkins
Advantage R&D

"Paul Man" <paulman@datasoft.ie> wrote in message
news:45ba279a@solutions.advantagedatabase.com...
> thanks.
> If we have a vpn over the internet then I'd assume compression would be
> the best option...
>


Paul Man Posted on 2007-01-26 18:30:30.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
References: <45b8a62c@solutions.advantagedatabase.com> <45b8d49e@solutions.advantagedatabase.com>
Subject: Re: Replication over the internet
Date: Fri, 26 Jan 2007 18:30:30 -0000
Lines: 40
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45ba47d3@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2007 11:26:27 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:159
Article PK: 1134017

Does the firewall need an open forwarded port on both sides or just the
publishing server? Is the replication push and pull or pull only? I.e. when
chanes are published do they wait there until the subscriber looks for them
or does the publishing server push them out to the subscriber?

Paul

"Mark Wilkins" <mark@no.email> wrote in message
news:45b8d49e@solutions.advantagedatabase.com...
> Hi Paul,
>
> In general, you need to open up the same port and set up compression
> options just like you would for any Advantage application. The difference
> is that the source server (ADS) is the client "application". Advantage
> Database Server uses the Advantage Client Engine to communicate with the
> target server. When you set up the subscription at the source, you choose
> the target connection type (under the Advanced tab in the subscription
> dialog properties if using Advantage Data Architect). This is simply
> choosing the connection type that the source server will make to the
> target. If you choose "Advantage Internet Server" as the connection type,
> then the port in the firewall to open would be the "Internet Port" that is
> configured at the target. If you leave the default settings for
> compression at the target (and in the ads.ini at the source), then
> compression will be on for an "AIS" style connection.
>
> Mark Wilkins
> Advantage R&D
>
> "Paul Man" <paulman@datasoft.ie> wrote in message
> news:45b8a62c@solutions.advantagedatabase.com...
>> If I set up replication to operate over the internet what ports should I
>> open and forward in the firewall on both sides? Does compression apply to
>> replication connections and is there anything special required to
>> implement WAN Vs LAN replication?
>>
>>
>
>


Mark Wilkins Posted on 2007-01-26 23:38:33.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.Replication
References: <45b8a62c@solutions.advantagedatabase.com> <45b8d49e@solutions.advantagedatabase.com> <45ba47d3@solutions.advantagedatabase.com>
Subject: Re: Replication over the internet
Date: Fri, 26 Jan 2007 16:38:33 -0700
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <45ba8ff5@solutions.advantagedatabase.com>
X-Trace: 26 Jan 2007 16:34:13 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Replication:160
Article PK: 1134018

Hi Paul,

It is a push only. The subscriber never contacts the publisher. I think it
is generally only necessary to open the port at the subscriber.

Mark

"Paul Man" <paulman@datasoft.ie> wrote in message
news:45ba47d3@solutions.advantagedatabase.com...
> Does the firewall need an open forwarded port on both sides or just the
> publishing server? Is the replication push and pull or pull only? I.e.
> when chanes are published do they wait there until the subscriber looks
> for them or does the publishing server push them out to the subscriber?
>
> Paul
>