MS-SQL CDC - V5.1 – Extending support for data types
v Following ‘Data type’ related issues have been worked on within V5.1 context.
v These extensions have been added as “on demand” / “ad-hoc” features into version 5.1 update patches.
v Consequently – they are currently available on a selective basis – for specific purposes only.
v The items listed below will be included in the next release as fully supported capabilities.
v Note that the following applies for both MS-SQL 2000 and MS-SQL 2005 CDC.

Summary:

Data Type....Extension / Enhancement
+-----------+------------------------------------------+
|BIT........| Multiple columns of BIT type contained in|
|...........| a table definition are now supported.... |
+-----------+------------------------------------------+
|TIMESTAMP. | Support is provided for TIMESTAMP data...|
|...........| type.....................................|
|...........| TIMESTAMP is CDC-ed as a BINARY (8) type,|
|...........| in compliance with its MS-SQL handling...|
+-----------+------------------------------------------+
|VARBINARY. | Limitations regarding presence of........|
|...........| VARBINARY type columns have been removed.|
+-----------+------------------------------------------+
|LOB........| Restrictions regarding LOB columns of ...|
|...........| type text / ntext / image have been......|
|...........| removed..................................|
|...........| Columns of those types can now be freely |
|...........| presented in CDC-ed tables’ definition...|
|...........| although – they are excluded from the CDC|
|...........| processing itself. ......................|
+-----------+------------------------------------------+