Data Replication
- Data Replication 9.8.0 HotFix 2
- All Products
Microsoft SQL Server Source Datatype | DB2 Target Datatype | Comments |
---|---|---|
BIGINT | BIGINT | - |
BINARY( n ) |
| - |
BIT | SMALLINT | - |
CHAR( n ) |
| - |
DATE | DATE | - |
DATETIME | TIMESTAMP | - |
DATETIME2 | TIMESTAMP | - |
DATETIMEOFFSET | TIMESTAMP | - |
DECIMAL( p ,s ) |
| - |
FLOAT( p ) |
| - |
GEOGRAPHY | BLOB | - |
GEOMETRY | BLOB | - |
HIERARCHYID | BLOB | - |
IMAGE | BLOB(1G) | 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. |
INT | INTEGER | - |
MONEY | DECIMAL(19,4) | - |
NCHAR( n ) |
| - |
NTEXT | CLOB(1G) | 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. |
NUMERIC( p ,s ) |
| - |
NVARCHAR( n ) |
| - |
REAL | REAL | - |
SMALLDATETIME | TIMESTAMP | - |
SMALLINT | SMALLINT | - |
SMALLMONEY | DECIMAL(10,4) | - |
SQL_VARIANT | CLOB | - |
SYSNAME( n ) | VARGRAPHIC( n ) | - |
TEXT | CLOB(1G) | 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. |
TIME | TIMESTAMP | - |
TIME(0) | TIME | - |
TIME(1) | TIMESTAMP | - |
TIME(2) | TIMESTAMP | - |
TIME(3) | TIMESTAMP | - |
TIME(4) | TIMESTAMP | - |
TIME(5) | TIMESTAMP | - |
TIME(6) | TIMESTAMP | - |
TIMESTAMP | BIGINT | - |
TINYINT | DECIMAL(3,0) | - |
UNIQUEIDENTIFIER( n ) | CHAR FOR BIT DATA( n' )
| - |
VARBINARY( n ) |
| - |
VARCHAR( n ) |
| - |
XML | CLOB | - |