Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> HELP:replication from sql server to Oracle
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
![]() |
![]() |