Limitations

When using a Microsoft Azure SQL Database as a target in a Replicate task, The following imitations apply:

When Use BCP for loading tables is selected in the Advanced tab (the default), unlimited LOB columns are not supported in Batch optimized apply change processing mode. You can work around this limitation by limiting LOB column size in the task settings, clearing the Use BCP for loading tables option or switching to Transactional apply mode.
When the Use BCP for loading tables option is enabled in the Advanced tab, triggers are not executed.
When both the Batch optimized apply and Limit LOB size to options are enabled, BLOB columns on the target will be truncated to a quarter of the size specified in the Limit LOB size to field.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!