Equivalent of Oracle Streams

• SQL-Student

  SSC Eights!

  Points: 868

  More actions

  February 28, 2010 at 10:03 am

  #221046

  Does SQL Server have an equivalent of Oracle Streams.

  Although SQL Server has things like Replication & Mirroring, they don't appear to do exactly what Oracle Streams is doing. (it gives more granular control).

  Is there a way where Oracle Streams like feature could be had on SQL Server?

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  March 2, 2010 at 2:29 am

  #1126901

  I am not familiar with Oracle Streams.

  SQL Server has features likes

  1) DML/DDL triggers

  2) Service Broker for asynchronous processing

  3) Change Data Capture

  Replication has granular control. For example, you can replicate only few columns of a table and you can filter the rows.