Data Replication
- Data Replication 9.8.0 HotFix 2
- All Products
DB2 Source Datatype | MemSQL Target Datatype | Comments |
---|---|---|
BIGINT | BIGINT | - |
BLOB | BLOB | Data Replication does not extract LOB data from compressed rows. 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. |
CHARACTER( n ) | CHAR( n ) | - |
CHARACTER FOR BIT DATA( n ) | BINARY( n ) | - |
CLOB | LONGTEXT | Data Replication does not extract LOB data from compressed rows. 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 | DATE | - |
DBCLOB | LONGTEXT | Data Replication does not extract LOB data from compressed rows. 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. |
DECFLOAT | VARCHAR(45) | - |
DECIMAL( p ,s ) |
| - |
DOUBLE | DOUBLE | - |
FLOAT | DOUBLE | - |
GRAPHIC( n ) | CHAR( n' )
| - |
INTEGER | INT | - |
LONG VARCHAR( n ) |
| Data Replication does not extract LONG VARCHAR data from compressed rows. |
LONG VARCHAR FOR BIT DATA( n ) | BLOB( n ) | - |
LONG VARGRAPHIC( n ) | VARCHAR( n' )
| Data Replication does not extract LONG VARGRAPHIC data from compressed rows. |
REAL | FLOAT | - |
SMALLINT | SMALLINT | - |
TIME | TIME | - |
TIMESTAMP( n ) |
| - |
VARCHAR( n ) |
| - |
VARCHAR FOR BIT DATA( n ) |
| - |
VARGRAPHIC( n ) | VARCHAR( n' )
| - |