开发者

Can anyone clear up some concerns about replication differences between Oracle and MS SQL Server?

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 resolut开发者_开发问答ion (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


Is marketing material about direct competitor accurate, up to date and unbiased? Use your brain, user287745...

SQL Server 7.0 is rather old. Since then 4 (four) more major editions have shipped (2000, 2005, 2008 and R2). If you want to read about SQL Server Replication, you better read on the MSDN site. SQL Server Replication.


Outdated. Really. or worse, whoever wrote that at oracle... left information out on purpose.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜