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.

How to set up replication from ASE to IQ?

2 posts in General Discussion Last posting was on 2012-02-02 04:25:16.0Z
vlastislav.weiner Posted on 2012-02-01 08:54:28.0Z
Sender: 1cd.4f28fc76.1804289383@sybase.com
From: vlastislav.weiner@anywhere.cz
Newsgroups: sybase.public.rep-server
Subject: How to set up replication from ASE to IQ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f28fdc4.20e.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
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
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9138
Article PK: 870302

Hi,

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?


Manish Negandhi [TeamSybase] Posted on 2012-02-02 04:25:16.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.rep-server
References: <4f28fdc4.20e.1681692777@sybase.com>
Subject: Re: How to set up replication from ASE to IQ?
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f2a102c@forums-1-dub>
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
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
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



-HTH

Manish Negandhi
[TeamSybase]

<vlastislav.weiner@anywhere.cz> wrote in message
news:4f28fdc4.20e.1681692777@sybase.com...
> Hi,
>
> 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?