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