Equivalent of Oracle Streams

  • 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?

  • 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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply