The following shows the replication capabilities as described for ms sql server on oracle website.
"the text inside the " " are my questions/confusion AGAINST what oracle website says"
Please clear these points, what do you think? Is this article out of date?
Replication functionality in Microsoft SQL Server or Sybase Adaptive Server has the following characteristics:
- Unidirectional "merge replication supports!!"
- Table-based, not transaction-based "in transaction replication new changes/transactions are replicated in real time!!!"
- No automatic conflict resolution (must be manual) "Really? what about merge replication"??
- Heterogeneous replication through Open Database Connectivity (ODBC)
In addition to the preceding characteristics, Microsoft SQL Server 7.0 replication provides heterogeneous replication through ODBC.
Oracle replication has richer replication functionality, which includes the following:
- Bi-directional
- Any database object can be replicated
- Automatic resynchronization
- Automatic conflict resolution
- Heterogeneous replication provided through gateways