For both products, remember that replication uses extra disk space and presumes you have adhered to its limitations on object names.
Replication also requires special system privileges.
Replication isn't rocket science, especially if you make use of the convenient administrative tools the database vendor supplies, but it can be a bit treacherous and fraught with pitfalls for the unwary. The push buttons and list boxes the tools present you with give no hint as to the rules, restrictions, limitations and conditions that replication presumes you're familiar with. As you design your scheme, consider using an intermediate database server as a distribution buffer to ease the workload on the master s erver and the network. The terminology database vendors use to describe replication is interesting. Oracle Corp. uses the term snapshot to identify a query-based slave copy of a table in the master database.