Replication Agent 15.5 supports Microsoft SQL Server 2008, at the same level of functionality as supported for Microsoft SQL Server 2005, for both DDL and DML replication. On initialization, Replication Agent can now identify the release version of the Microsoft SQL Server primary database and load the appropriate system schemas into RASD.
See Chapter 2, “Replication Agent for Microsoft SQL Server” in the Replication Agent 15.5 Primary Database Guide.
Support for Microsoft SQL Server 2008 is limited to the same features that are supported for Microsoft SQL Server 2005. Replication Agent does not support the new features of Microsoft SQL Server 2008, such as:
New date types including date, time, datetime2, datetimeoffset, hierarchiyid, geometry and geography
FILESTREAM data
Transparent Data Encryption (TDE)
Procedures with table-valued parameters (TVPs)
Sparse column and column set
Large user-defined types
MERGE SQL statement
