Data Replication
- Data Replication 9.7.0
- All Products
Microsoft SQL Server Source Datatype | MySQL Target Datatype | Comments |
---|---|---|
BIGINT | BIGINT | - |
BINARY( n ) |
| - |
BIT | TINYINT | - |
CHAR( n ) |
| - |
DATE | DATE | - |
DATETIME | DATETIME | - |
DATETIME2 | DATETIME | - |
DATETIMEOFFSET | DATETIME | - |
DECIMAL( p ,s ) |
| - |
FLOAT( p ) |
| - |
GEOGRAPHY | BLOB | - |
GEOMETRY | BLOB | - |
HIERARCHYID | BLOB | - |
IMAGE | BLOB | 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 | INT | - |
MONEY | DECIMAL(19,4) | - |
NCHAR( n ) |
| - |
NTEXT | TEXT | 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 | DATETIME | - |
SMALLINT | SMALLINT | - |
SMALLMONEY | DECIMAL(10,4) | - |
SQL_VARIANT | TEXT | - |
SYSNAME( n ) |
| - |
TEXT | TEXT | 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 | TIME | - |
TIME(0) | TIME | - |
TIME(1) | TIME | - |
TIME(2) | TIME | - |
TIME(3) | TIME | - |
TIME(4) | TIME | - |
TIME(5) | TIME | - |
TIME(6) | TIME | - |
TIMESTAMP | BIGINT | - |
TINYINT | SMALLINT | - |
UNIQUEIDENTIFIER | BINARY(16) | - |
VARBINARY( n ) |
| - |
VARCHAR( n ) |
| - |
XML | TEXT | - |