| 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 them 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.
Both databases are opened read-write.
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.