Affordable database replication!

• Real-time data replication for Oracle to Oracle, MySQL & Microsoft® SQL Server databases
• Shares, migrates, synchronizes and consolidates data in real-time
• Enable offloading of real-time reporting

• Offloads processing workloads from critical database servers
• integrates diverse platforms, operating systems and databases
• Provides powerful conflict detection and resolution process

Complete Solutions

Dbvisit Replicate is powerful, affordable software. It is simple to install and configure, and comes with all the tools and utilities you can expect for easy management, including conflict detection and resolution. Plus it provides data replication from Oracle to Oracle, MySQL and Microsoft SQL Server.

• Wizard driven, step-by-step guided installation process
• Powerful conflict detection, notification and resolution
• Automatic network configuration optimizer and management of log files

• Real-time status monitoring
• CDC/Audit enabling real time loading of data warehouses
• SNMP integration and email notification
• Flexible architecture

Continuity

In addition to the conflict detection and resolution processes built into Dbvisit Replication, our software ensures all committed records are securely delivered to your target database even in the event of an outage. This saves you the inconvenience of dealing with system interruptions, hardware unavailability and restoration delays.

• Automatic recovery of errors and network issues
• Encryption of data sent across the network
• Takes care of existing database triggers to avoid double firing
• Conflict resolution business rules can be created with user defined PL/SQL stored procedures

Dbvisit Replicate videos

Watch a Dbvisit Replicate Oracle data replication intro and architecture video:

Dbvisit Replicate architecture

The Dbvisit Replicate architecture is very simple and efficient and consists of the following processes:

• MINE process which converts Oracle redo logs into parsed logs called PLOGS
• APPLY process which converts the PLOG data into native SQL statements
• FETCHER (optional) which can offload the MINE process to an intermediary server
• PLOG which is a platform independent binary file specific to Dbvisit Replicate and is streamed real-time between the MINE and APPLY process

• Full 1-way (master to slave) and 2-way replication (master to master)
• 3-tier architecture which includes the offloading of the mine process to another server (using the Fetcher process)
• Automatic setup of network transportation parameters depending on WAN or LAN network
• Network encryption and security
• Full ASM support
• CDC/Audit to capture changes in source system to enable real time loading of data warehousing or BI. This loads a Dbvisit Replicate created staging table with old and new values plus all the auditing information such as transaction id, changed date, logon user, operation, machine name etc.
• Oracle RAC support
• Easy to use intuitive setup wizard
• Notifications and full alerting when thresholds or errors occur
• SNMP integration to allow for integration with existing monitoring infrastructure
• Full support provided. Automatic packing of log and trace files to easily send to support services

Supported and non supported data types

Dbvisit Replicate Online user manual

Technical Specifications 

Oracle Databases	9.2 to 11gR2
Oracle Editions	Enterprise / Standard (both including RAC, Standard One and Oracle XE)
Source Databases	Oracle
Target Databases	Oracle / MySQL (InnoDB) / Microsoft SQL Server
Storage	Oracle flash recovery area / ASM & OMF file systems
Operating Systems	Microsoft: Windows 2003 – 2008 (32 & 64bit) Linux: Intel (32 & 64bit) SunOS: Intel (32 & 64bit) SunOS: Sparc AIX HPUX: Itanium
System Requirements	100MB on source and targets server 200MB on Oracle Database repository 1G-2G recommended memory allocation 10G disk allocation for text*, redo & parsed log (*if traces enabled)

 

Dbvisit Replicate Comparison

FUNCTIONALITY	Dbvisit Replicate	Oracle GoldenGate	Oracle Streams
OPTIMISTIC COMMIT	Yes Does not wait for commit before mining or applying	No Waits for commit before mining	No Waits for commit before applying
STANDARD EDITION SUPPORT
MySQL & SQL SERVER TARGET
ORACLE CROSS PLATFORM
LOB SUPPORT
SETUP WIZARD
OFFLOAD / DOWNSTREAM MINE
CONFLICT RESOLUTION
SCALABLE / ROBUST
COST EFFECTIVE
DEFAULT SCRIPTED DEPLOYMENT

• Simple to install and manage
• Affordable with long term savings
• Distributes information in real-time across multiple applications
• Powerful features
• Save up to 80% on Oracle Licensing
• Facilitates real-time business reporting

The Replication Effect

Dbvisit Replicate generates a knock-on effect throughout your business. At the data layer it shares, migrates and offloads data processing workloads to alternative databases and server platforms. This impacts the infrastructure layer by minimizing downtime, delivering operational cost efficiencies, facilitating realtime business reporting and continues on to improve your users overall working experience and impact your business bottom line.

Peace of mind

Dbvisit Replicate is backed by DbvisitProtect, providing support services designed to ensure your software continues to operate flawlessly with all Oracle updates and upgrades and new versions of your operating system.

Additionally, you can combine Dbvisit Replicate with Dbvisit Standby to provide a disaster recovery layer for your database environment. This delivers users and management business continuity, security and confidence in your data systems.

DOWNLOAD A FREE TRIAL OF DBVISIT REPLICATE >

WATCH TUTORIALS >

About this Software

• This downloadable software is fully functional, commercial enterprise software for Early Adopters. It includes a 30-day evaluation license
• A commercial license key is needed to activate the software to change it from an evaluation version to a fully licensed version
• No re-install or upgrade is required to activate the software

To upgrade your version of Dbvisit Replicate

• Download the latest version of the software
• Existing license keys are automatically applied to the latest software

Please note

• Oracle Databases or servers will not be restarted during the installation
• This software is compatible with Oracle 9.2, 10g and 11g databases
• This software supports single instance and RAC databases