Unsupported Software Features

These features are not supported for Sybase replication.

  • Microsoft SQL Server clusters

  • Microsoft SQL Server virtual computed columns

  • Replication Server warm standby (for non-Adaptive Server Enterprise databases)

  • Replication Server rs_subcomp utility (for non-Adaptive Server Enterprise databases)

  • Database level materialization
    Note: Direct load type of automatic materialization and bulk materialization (database level/manual) are supported.

  • Some Microsoft SQL Server 2008 features

Replication Agent does not support these Microsoft SQL Server 2008 features.

  • Column sets

  • MERGE SQL statements

  • Procedures with table-valued parameters

  • Sparse columns

  • Transparent data encryption (TDE)

A table or stored procedure that uses these features cannot be marked, even by using pdb_setreptable with the force keyword.
Parent topic: Microsoft SQL Server-Specific Considerations