Microsoft SQL Server target data types
The Microsoft SQL Server target for Qlik Replicate supports most Microsoft SQL Server data types. The following table shows the Microsoft SQL Server target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using.
For additional information about Qlik Replicate data types, see Replicate data types.
When replicating to Microsoft SQL Server 2019 or 2022, UTF-8 data can be transferred to VARCHAR, CHAR, and CLOB columns when the database collation is set to %collation%_UTF8 (for example, Latin1_General_100_CI_AS_SC_UTF8). When working with an earlier Microsoft SQL Server version or a different collation, use a transformation (global or table-specific) to transform the column data type to WSTRING.
See also Using the Transform tab and Defining global rules.
| Qlik Replicate Data Types | Microsoft SQL Server Data Types |
|---|---|
|
BOOLEAN |
TINYINT The default: TINYINT When the Map Replicate BOOLEAN data type to BIT (instead of TINYINT) option in the Advanced tab is selected: BIT |
|
BYTES |
VARBINARY(length) |
|
DATE |
DATE |
|
TIME |
TIME(0) |
|
DATETIME |
DATETIME2(scale) |
|
INT1 |
SMALLINT |
|
INT2 |
SMALLINT |
|
INT4 |
INT |
|
INT8 |
BIGINT |
|
NUMERIC |
NUMERIC(p,s) |
|
REAL4 |
REAL |
|
REAL8 |
FLOAT |
|
STRING |
If column is date or time then: DATETIME2 If the column is not a date or time: VARCHAR(length) |
|
UINT1 |
INT2 |
|
UINT2 |
INT4 |
|
UINT4 |
INT8 |
|
UINT8 |
NUMERIC(20) |
|
WSTRING |
NVARCHAR(length) |
|
BLOB |
VARBINARY(max) IMAGE To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
|
CLOB |
VARCHAR(max) TEXT To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |
|
NCLOB |
NVARCHAR(max) NTEXT To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. |