Striim 4.0.4 documentation

Table of Contents

MS SQL Reader data type support and correspondence

MSSQL type

MS SQL Reader TQL type

MSJet TQL type

notes

bigint

long

integer

binary

byte[]

byte[]

not included in before array for UPDATE or data array for DELETE operations: see cautionary note below

bit

string

boolean

char

string

string

date

string

string

datetime

string

string

datetime2

string

string

datetimeoffset

string

string

decimal

string

string

float

double

string

image

byte[]

byte[]

not included in before array for UPDATE or data array for DELETE operations: see cautionary note below

int

integer

integer

money

string

string

nchar

string

string

ntext

string

string

not included in before array for UPDATE or data array for DELETE operations: see cautionary note below

numeric

string

string

nvarchar

string

string

nvarchar(max)

string

string

included in before array for UPDATE operations only if value is changed by the update

real

float

string

smalldatetime

string

string

smallint

short

short

smallmoney

string

string

sqlvariant

unsupported

unsupported

Columns of this type will have value null in WAEvent

text

string

string

not included in before array for UPDATE or data array for DELETE operations: see cautionary note below

time

string

string

timestamp

byte[]

byte[]

tinyint

short

short

udt

string

string

uniqueidentifier

string

string

varbinary

byte[]

byte

not included in before array for UPDATE or data array for DELETE operations: see cautionary note below

varbinary(max)

byte[]

byte[]

not included in before array for UPDATE or data array for DELETE operations: see cautionary note below

varchar

string

string

varchar(max)

string

string

included in before array for UPDATE operations only if value is changed by the update

xml

string

unsupported

MS SQL Reader: included in before array for UPDATE operations only if value is changed by the update

MSJet: columns of this type type will have value null in in WAEvent

Caution

When all tables being read have primary keys and none of those primary key columns is of type binary, image, ntext, text, varbinary, or varbinary(max), you will not encounter the following issue.

When replicating MSSQLReader or MSJet output using DatabaseWriter, if one or more of a table's primary key columns is of type binary, image, ntext, text, varbinary, or varbinary(max), or if a table has no primary key and one more columns of those types, UPDATE or DELETE operations may erroneously be replicated to more than one row. This may result in additional errors when subsequent operations try to update or delete the missing or incorrectly updated rows.