Re: HELP:replication from sql server to Oracle

Andre Grosse wrote:

> 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

It's not transparent gateway, but Microsoft's Heterogenous Subscriber. You can find this information in Sql Server's help document. But it seems the bulk replication works bad!