I would like to replicate data from ASE 15.0.3 ESD#4 to IQ
12.7. ESD#10 with Replication Server 12.6 ESD#5.
How can I do it? Please simple example with one table. Is it
necessary to migrate anything (ASE,IQ,RS) to newer version?
Subject: How to set up replication from ASE to IQ?
X-Mailer: WebNews to Mail Gateway v1.1t
Date: 1 Feb 2012 00:54:28 -0800
X-Trace: forums-1-dub 1328086468 172.20.134.41 (1 Feb 2012 00:54:28 -0800)
X-Original-Trace: 1 Feb 2012 00:54:28 -0800, 172.20.134.41
Xref: forums-1-dub sybase.public.rep-server:9138
Article PK: 870302
Subject: Re: How to set up replication from ASE to IQ?
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
Date: 1 Feb 2012 20:25:16 -0800
X-Trace: forums-1-dub 1328156716 10.22.241.152 (1 Feb 2012 20:25:16 -0800)
X-Original-Trace: 1 Feb 2012 20:25:16 -0800, vip152.sybase.com
Xref: forums-1-dub sybase.public.rep-server:9140
Article PK: 870305
You can replicate to staging ASE database and from there load data to IQ
periodically. Direct replication is possible after altering function strings
however it is not recommended as IQ being DW product , row by row
replication will not be good for performance. Better solution is to upgrade.
Sybase introduced RTL ( Real Time Loading ) edition with RS 15.5 to support
direct replication to IQ . You need to have ASE and RS at version 15.5 or
later to make use of RTL. You can use real-time loading to replicate into
Sybase IQ version 12.7 ESD #3 and later