Hi,
I want to know about if anyone is working with Replication Server and
DBRemote toghether.

I want to use RS to replicate with connected sites (ASE Servers) and
DBremote to replicate with disconnected ones (ASA Servers).

According with Sybase Support I must put an intermediate ASA server with Rep
Agent for ASA working as gateway between disconnected sites and the central
site.

We are thinking in the following products:
* Central Server: ASE 11.9.2 y Replication Server (UnixWare 7.1)
* Intermediate Server: ASA with a consolidated DB, and using dbremote.
* Remote Sites disconnected: ASA replicating with dbremote, via intermediate
server.
* Remote Sites connected: ASE replicating in direct mode with Central
Server.


Thanks for any suggestion or experience.


Gabriel Mautino.
sgabriel@arcride.edu.ar

This is a very standard configuration, looks something like this:


ASE <-> RS <-> ASA <- 100's of asa -> ASA

You must use and licence the Rep Agent for ASA to replicate between RS and
ASA.  DBRemote is used between ASA and ASA.

You can also use this picture:
RS <-> ASE <- 100's of asa -> ASA

In this case, you would use SSRemote to replicate FROM ASE to ASA.
An added complication is the requirement of using SSQueue so that ASE can
also replicate with RS.

This solution is limited based on SQLRemote publications.  It really depends
on what you are doing and why you are trying to do.


--
David Fishburn
Sybase
Please only post to the newsgroup



Gabriel Mautino <sgabriel@arcride.edu.ar> wrote in message
news:5mLpgGDX$GA.177@forums.sybase.com...
> Hi,
> I want to know about if anyone is working with Replication Server and
> DBRemote toghether.
>
> I want to use RS to replicate with connected sites (ASE Servers) and
> DBremote to replicate with disconnected ones (ASA Servers).
>
> According with Sybase Support I must put an intermediate ASA server with
Rep
> Agent for ASA working as gateway between disconnected sites and the
central
> site.
>
> We are thinking in the following products:
> * Central Server: ASE 11.9.2 y Replication Server (UnixWare 7.1)
> * Intermediate Server: ASA with a consolidated DB, and using dbremote.
> * Remote Sites disconnected: ASA replicating with dbremote, via
intermediate
> server.
> * Remote Sites connected: ASE replicating in direct mode with Central
> Server.
>
>
> Thanks for any suggestion or experience.
>
>
> Gabriel Mautino.
> sgabriel@arcride.edu.ar
>
>
>
>

Thanks for your reply.

Aditionals questions:
* What is SSQueue? An aditional product that enable ASE to replicate with RS
and SQL Remote?
* We have ASE 11.9.2 for UnixWare and I can't find a executable file for
dbremote. Is dbremote available for all ASE platforms?

Thanks.

Gabriel Mautino


David Fishburn escribi� en mensaje <84sKUGEX$GA.223@forums.sybase.com>...
>This is a very standard configuration, looks something like this:
>
>
>ASE <-> RS <-> ASA <- 100's of asa -> ASA
>
>You must use and licence the Rep Agent for ASA to replicate between RS and
>ASA.  DBRemote is used between ASA and ASA.
>
>You can also use this picture:
>RS <-> ASE <- 100's of asa -> ASA
>
>In this case, you would use SSRemote to replicate FROM ASE to ASA.
>An added complication is the requirement of using SSQueue so that ASE can
>also replicate with RS.
>
>This solution is limited based on SQLRemote publications.  It really
depends
>on what you are doing and why you are trying to do.
>
>
>--
>David Fishburn
>Sybase
>Please only post to the newsgroup
>
>
>
>Gabriel Mautino <sgabriel@arcride.edu.ar> wrote in message
>news:5mLpgGDX$GA.177@forums.sybase.com...
>> Hi,
>> I want to know about if anyone is working with Replication Server and
>> DBRemote toghether.
>>
>> I want to use RS to replicate with connected sites (ASE Servers) and
>> DBremote to replicate with disconnected ones (ASA Servers).
>>
>> According with Sybase Support I must put an intermediate ASA server with
>Rep
>> Agent for ASA working as gateway between disconnected sites and the
>central
>> site.
>>
>> We are thinking in the following products:
>> * Central Server: ASE 11.9.2 y Replication Server (UnixWare 7.1)
>> * Intermediate Server: ASA with a consolidated DB, and using dbremote.
>> * Remote Sites disconnected: ASA replicating with dbremote, via
>intermediate
>> server.
>> * Remote Sites connected: ASE replicating in direct mode with Central
>> Server.
>>
>>
>> Thanks for any suggestion or experience.
>>
>>
>> Gabriel Mautino.
>> sgabriel@arcride.edu.ar
>>
>>
>>
>>
>
>

> * What is SSQueue? An aditional product that enable ASE to replicate with
RS
> and SQL Remote?

You specifically indicated that the ASE box must ALSO replicate with Rep
Server.  I am assuming the other database is either another ASE database or
DB2 or Oracle or something OTHER than ASA.

Because of this, SSQueue was created.
By default SSRemote wants to scan the ASE transaction log and replicate
transactions.
BUT
The Rep Agent for ASE also wants to scan the transaction log to replicate
the changes to the other databases.

So, who gets to scan the log, RAASE or SSRemote?

The answer is, The Rep Agent for ASE gets to.  You setup SSQueue as another
replicate database receiving all the same changes that the other database
would receive.  It takes care of populating the SSRemote tables
(sr_transaction), so that SSRemote can also replicate what it needs to.

This means you must run either:
a)  ssremote -c "..." -r   AND ssremote -c "..." -s
b) ssremote -c "..." -r -s
Specifically avoiding the log scanning phase -i.

> * We have ASE 11.9.2 for UnixWare and I can't find a executable file for
> dbremote. Is dbremote available for all ASE platforms?

The exe is called SSRemote (for SQL Server).
It is a separate product that must be ordered, please contact Sybase
1-800-8-SYBASE

--
David Fishburn
Sybase
Please only post to the newsgroup



Gabriel Mautino <sgabriel@arcride.edu.ar> wrote in message
news:P3EdQzEX$GA.177@forums.sybase.com...
> Thanks for your reply.
>
> Aditionals questions:
> * What is SSQueue? An aditional product that enable ASE to replicate with
RS
> and SQL Remote?
> * We have ASE 11.9.2 for UnixWare and I can't find a executable file for
> dbremote. Is dbremote available for all ASE platforms?
>
> Thanks.
>
> Gabriel Mautino
>
>
> David Fishburn escribi� en mensaje <84sKUGEX$GA.223@forums.sybase.com>...
> >This is a very standard configuration, looks something like this:
> >
> >
> >ASE <-> RS <-> ASA <- 100's of asa -> ASA
> >
> >You must use and licence the Rep Agent for ASA to replicate between RS
and
> >ASA.  DBRemote is used between ASA and ASA.
> >
> >You can also use this picture:
> >RS <-> ASE <- 100's of asa -> ASA
> >
> >In this case, you would use SSRemote to replicate FROM ASE to ASA.
> >An added complication is the requirement of using SSQueue so that ASE can
> >also replicate with RS.
> >
> >This solution is limited based on SQLRemote publications.  It really
> depends
> >on what you are doing and why you are trying to do.
> >
> >
> >--
> >David Fishburn
> >Sybase
> >Please only post to the newsgroup
> >
> >
> >
> >Gabriel Mautino <sgabriel@arcride.edu.ar> wrote in message
> >news:5mLpgGDX$GA.177@forums.sybase.com...
> >> Hi,
> >> I want to know about if anyone is working with Replication Server and
> >> DBRemote toghether.
> >>
> >> I want to use RS to replicate with connected sites (ASE Servers) and
> >> DBremote to replicate with disconnected ones (ASA Servers).
> >>
> >> According with Sybase Support I must put an intermediate ASA server
with
> >Rep
> >> Agent for ASA working as gateway between disconnected sites and the
> >central
> >> site.
> >>
> >> We are thinking in the following products:
> >> * Central Server: ASE 11.9.2 y Replication Server (UnixWare 7.1)
> >> * Intermediate Server: ASA with a consolidated DB, and using dbremote.
> >> * Remote Sites disconnected: ASA replicating with dbremote, via
> >intermediate
> >> server.
> >> * Remote Sites connected: ASE replicating in direct mode with Central
> >> Server.
> >>
> >>
> >> Thanks for any suggestion or experience.
> >>
> >>
> >> Gabriel Mautino.
> >> sgabriel@arcride.edu.ar
> >>
> >>
> >>
> >>
> >
> >
>
>