SQL Server 2005 provides incremental improvements to their replication, distributedoperations, and heterogeneous access. It also introduces an entirely new messagequeuing feature integrated into the database called Service Broker. The mid-tiermessage queuing solution provided by MSMQ continues as a feature external to SQLServer. Oracle Streams and SQL Server 2005 Transactional Replication are two features thatprovide server-to-server replication. Streams is superior to Transactional Replicationbecause of its broader feature set and flexibility. Most notably, Streams supports trueupdate anywhere operation with full conflict detection and resolution. TransactionalReplication is predominantly a one-way replication solution that requires datapartitioning when updates can occur in more than one location. Oracle Materialized Views and SQL Server Merge Replication both target replication ina mass deployment or disconnected configuration. Materialized Views distinguishesitself from Merge Replication by its ability to maintain a transactionally consistent stateat both source and destination.