Data Replication
- Data Replication 9.8.0 HotFix 2
- All Products
Oracle Source Datatype | Microsoft SQL Server Target Datatype | Comments |
---|---|---|
BINARY_DOUBLE | FLOAT | - |
BINARY_FLOAT | FLOAT | - |
BLOB | IMAGE | If the global.lob_truncation_size runtime parameter is set to 64000 bytes or less, InitialSync handles BLOB data as RAW data to improve performance. Oracle piecewise operations are supported only for inline LOBs. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
CHAR( n ) | CHAR( n ) | - |
CLOB | TEXT | Oracle piecewise operations are supported only for inline LOBs. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
DATE | DATETIME2(0) | - |
FLOAT | NUMERIC(38,15) | - |
LONG | TEXT | Oracle piecewise operations are supported only for inline LOBs. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
LONG RAW | IMAGE | Oracle piecewise operations are supported only for inline LOBs. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
NCHAR( n ) | NCHAR( n' )
| - |
NCLOB | NTEXT | Oracle piecewise operations are supported only for inline LOBs. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
NUMBER( p ,s ) |
| - |
NVARCHAR( n ) | NVARCHAR( n' )
| - |
NVARCHAR2( n ) |
| - |
RAW( n ) |
| Oracle piecewise operations are supported only for inline LOBs. |
TIMESTAMP(0) | DATETIME2(0) | - |
TIMESTAMP(1) | DATETIME2(1) | - |
TIMESTAMP(2) | DATETIME2(2) | - |
TIMESTAMP(3) | DATETIME2(3) | - |
TIMESTAMP(4) | DATETIME2(4) | - |
TIMESTAMP(5) | DATETIME2(5) | - |
TIMESTAMP(6) | DATETIME2(6) | - |
TIMESTAMP(7) | DATETIME2(7) | - |
TIMESTAMP(8) | DATETIME2(7) | - |
TIMESTAMP(9) | DATETIME2(7) | - |
VARCHAR( n ) | VARCHAR( n ) | - |
VARCHAR2( n ) |
| Oracle piecewise operations are supported only for inline LOBs. |
XMLTYPE | XML | - |