| Changes in this topic | Description |
|---|---|
| Updated in version 6.0.04.02 | Support was discontinued for SQL Server 2012 (32 or 64 bit) and R2. |
The following list describes the constraints or limitations of using MS SQL Server CDC:
-
By default, MS SQL Server CDC only captures Large objects (LOB) data to a maximum size of 65536 bytes. When you replicate LOB data with CDC, you cannot exceed this size. If a LOB data value is encountered that is larger than this size, the source table operation fails. If LOB data values exceed this size, you can increase the limit by configuring the max text repl size parameter in MS SQL Server. For details on how to configure this parameter, see Server configuration.
Note: LOB column types include TEXT, NTEXT, IMAGE, XML, VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX). -
A MS SQL Server database can not be replicated using multiple models.
-
Only available on the Enterprise, Developer editions of MS SQL Server 2014 or higher.
-
Does not support bi-directional replication.
-
You cannot truncate tables that are being captured by CDC.
-
You cannot use CDC if you are using CDC for some other application on the same server.
-
Transactional integrity will be limited to the database level.
-
Transaction username is unavailable.
-
Connect CDC does not support replication requests that contain tables from more than one MS SQL Server database.