When using a Microsoft SQL Server source endpoint in a Replicate task, the following imitations apply:
- If you are using a Microsoft SQL Server source database in a replication task, the Microsoft SQL Server Replication Publisher definitions for the database that was used in the task are not removed when you remove a task. A Microsoft SQL Server system administrator must delete these definitions from Microsoft SQL Server.
- Sparse tables are not supported.
- Replicating data from indexed views is not supported.
- Renaming tables using
sp_renameis not supported (e.g.
sp_rename 'Sales.SalesRegion', 'SalesReg;)
- Renaming columns using
sp_renameis not supported (e.g.
sp_rename 'Sales.Sales.Region', 'RegID', 'COLUMN';)
- TRUNCATE events will not be captured.
Replication of computed columns is supported in Full Load replication tasks only. During change processing, INSERTs to computed columns will appear as NULL on the target and UPDATEs will be ignored.
- Microsoft SQL Server partition switching is not supported.
- When using the WRITETEXT and UPDATETEXT utilities, Qlik Replicate does not capture events applied on the source database.
The following DML pattern is not supported:
select <*> into <new_table> from <existing_table>
- Column-level encryption is not supported.
- The following limitations apply when accessing the backup transaction logs:
- Encrypted backups are not supported.
- Backups stored at a URL or on Windows Azure are not supported.
The following limitations apply when accessing the backup transaction logs at file level:
- The backup transaction logs must reside in a shared folder with the appropriate permissions and access rights.
- Active transaction logs are accessed through the Microsoft SQL Server API (and not at file-level).
- The Qlik Replicate and Microsoft SQL Server machines must reside in the same domain.
- Compressed backup transaction logs are not supported on Windows Server 2008.
- Transparent Data Encryption (TDE) is not supported. Note that when accessing the backup transaction logs using SQL Server’s native functionality (i.e. not using file-level access), TDE encryption is supported.
- Unix platforms are not supported.
- Reading the backup logs from multiple stripes is not supported.
- The File Stream and Full Text features are not supported when the endpoint's Replicate has file-level access to the backup log files option is enabled.
For more information on configuring Qlik Replicate to access the backup transaction logs at file-level access, see Setting advanced connection properties.
- Microsoft SQL Server backup to multiple disks (i.e. MIRROR TO DISK) is not supported.
- When inserting a value into SQL Server spatial data types (GEOGRAPHY and GEOMETRY), one can either ignore the SRID (Spatial Reference System Identifier) property - in which case the default SRID will be used (0 for GEOMETRY and 4326 for GEOGRAPHY) - or specify a different number. When replicating tables with spatial data types, Qlik Replicate replaces the SRID that was inserted by user with the default SRID.
- Replication of GEOGRAPHY and GEOMETRY data types is only supported in limited LOB mode.
- If your database is not set up for MS-REPLICATION or MS-CDC, you can still capture tables that do not have a Primary Key, but bear in mind that in such a setup only INSERT/DELETE DML events will be captured. UPDATE events will be ignored.
- Columnstore indexes are not supported.
- Memory-optimized tables (using In-Memory OLTP) are not supported.
- Temporal tables are not supported
- Delayed durability is not supported
- Table change tracking is not supported
- Due to an ODBC limitation, no more than 16 columns can be part of a Primary Key.
- Masked data will be created in the target without masking.
- OpenLDAP is not supported
- The UTF8 collations for VARCHAR, CHAR, and CLOB, introduced with Microsoft SQL Server 2019 are not supported.
Replicating directly from a secondary Microsoft SQL Server database is not supported. Consequently, the Replicate Microsoft SQL Server endpoint must be configured to connect to the primary database or the AlwaysOn Listener.
Replication from databases configured to use ADR (Accelerated Database Recovery) is not supported.
Non-supported Microsoft SQL Server security features
Tables that use the following Microsoft SQL Server security features are not supported:
- Always Encrypted
- Row-Level Security