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 the MS SQL Server.
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 2012 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.
-
Requests cannot scan databases.
-
Transaction username is unavailable.
-
Connect CDC does not support replication requests that contain tables from more than one MS SQL Server database.