Replication Agent now reads operations and transactions directly from the Microsoft SQL Server transaction log instead of placing triggers on tables marked for replication. Using this log-based replication, Replication Agent now also supports replicating DDL. This new capability requires that Replication Agent use a repository (RASD) and adds a number of new configuration parameters.
Replication Agent for Microsoft SQL Server must be installed on a Windows host from which it can directly access the primary SQL Server transaction logs. Replication Agent for Microsoft SQL Server can no longer be installed on a UNIX or Linux host.
For more information regarding the support of Microsoft SQL Server 2005, see the Replication Agent Primary Database Guide and the Replication Agent Administration Guide.