Re: HELP:replication from sql server to Oracle

GengBo wrote:

> All,
>
> I'm trying to replicate from sql server to oracle, and issues come up:
> 1: DATETIME data type is converted to short DATE , such as
> "mm/dd/yy h,m,s" will be "mm/dd/yy", after replication;
> 2: Clustered primary key can't be replicate to oracle , I checked the error
> that's because the sql statement generated by sql server including CLUSTERED
>
> key word which oracle doesn't support;
> 3: Sql server only push the first column to oracle as primary key for
> Non-clustered
> primary key in it. Such as PK(col1,col2,col3) will be PK(col1) in oracle
> after replication.
>

how du you replicate? with transparent gateway? i'm also looking for such a possibility, but so far i can see, i can't download a trialversion of this gateway from oracle.

-- 
Andre Grosse