Definition: Source Database - Database that contains the data that needs to be replicated. Target Database - Database that receives the replicated data. |
|---|
Dbvisit Replicate reads (mines) Oracle redo logs in real time at the source database, converts the transactions to SQL commands and executes them (applies) them at the target database.
Dbvisit Replicate is very efficient, has very low system overhead and can handle large transaction volumes without compromising the performance of the source database. Dbvisit Replicate uses its own mining engine and does not use Oracle components or API's.
Both databases are normal database opened read-write mode. 
Only the source database has to be on Oracle; the target database can be Oracle, SQL Server or MySQL.
For 2-way replication or master-to-master both both source and target databases have to be Oracle.