Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> HELP:replication from sql server to Oracle

HELP:replication from sql server to Oracle

From: GengBo <bgeng_at_szdhd.sz.lucent.com>
Date: Tue, 11 Sep 2001 13:20:57 +0800
Message-ID: <3B9D9F39.3F20504C@szdhd.sz.lucent.com>

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.

Could any expert give me some suggestion? Thanks a lot.

Bob


Received on Tue Sep 11 2001 - 00:20:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US