Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Question: How can I replicate data from Sybase to MS SQL Server 7?

94 views
Skip to first unread message

Fernando Flores

unread,
Jan 23, 2000, 3:00:00 AM1/23/00
to
Hello,

I would like to know if you have a document that explain me the
components/products and steps in order to replicate data from Sybase ASE
11.5.1 to MS SQL Server 7.0.

On the other hand, I am trying to replicate data from MS SQL Server 7.0 to
MS SQLServer 7.0 using Sybase Rep. Server. Do you have any information about
the Rep. Agent for MS SQL Server? and how setup this replication?

Any information would be appreciate.


Thanks on advance

Fernando Flores
DBA
GE Capital Treasury Systems


Stephen Shepherd

unread,
Jan 25, 2000, 3:00:00 AM1/25/00
to Fernando Flores
Hello Fernando,

Sybase supports replication into a non_ASE replicate database using
ASE's Component Integration Services (CIS) and a Direct Connect Gateway.

Basically, the Direct Connect Gateway communicates via ODBC to SQL Server.
ASE's CIS component allows you to define the Direct Connect as a proxy database
inside ASE. Replication Server identifies and reacts to the CIS proxy just as
if it were a normal ASE database.

Rep Server -> ASE/CIS -> Direct Connect -> SQL Server

There is already a Direct Connect version which supports SQL Server version 6.5.

SQL Server 7.0 support is due out this quarter.

HTH,
Stephen Shepherd
SYBASE

0 new messages