Data Replication Features

Do-it-yourself Data Replication

Real-time data replication and change data capture
made easy

DBMoto software provides all functionality in easy GUI and wizard-based screens; no stored procedures to develop; and no proprietary syntax to learn.

Database Support

  • Support for multiple relational databases as sources and targets.
  • Support for cloud databases such as Amazon RDS and Google Cloud SQL.
  • Support for data replication to Apache Hadoop data storage and processing environments.
  • Replicates data to Apache Kafka and to structured files.
  • Support for analytic/columnar data storage solutions as targets including SAP HANA, IBM PureData System (Netezza), HP Vertica and Actian Vectorwise.
  • Support for database cluster environments, such as Oracle RAC and Microsoft Cluster Server.
  • Open APIs to integrate DBMoto into corporate architectures, or into third party solutions.

Replication Support

  • Supported replication modes:
    • Refresh (snapshot): Reads data set, applies administrator-defined mapping rules, and writes the entire result to the target database.
    • Mirroring (change data capture): One-way replication using CDC from source to target in real-time, based on transaction log management whenever possible.
    • Synchronization (real-time bidirectional mirroring with conflict resolution): Uses DBMoto’s CDC-based; transaction log management and custom conflict resolution strategies to keep multiple databases bi-directionally synchronized.
  • “Multi-Server Synchronization” to synchronize changes bi-directionally between source and multiple targets, with built-in conflict resolution.
  • Automatic creation of target tables.
  • Extensive log reporting and accessibility.
  • Powerful visual tools for information on replication performance, status and errors.
  • DBMoto Verifier™ tool to easily compare and reconcile replication results for accuracy and auditing.
  • Support for extended data types.
  • Built-in transformation functions, with custom functions definable at any time.

User Support

  • User-friendly graphical interface with wizards for fast, easy configuration and setup.
  • Configuration and management of entire replication process through one or many DBMoto Management Center console(s) on Microsoft Windows platform.
  • Customizable via Microsoft C# and VB.NET scripting and event-driven environment.
  • Extensive security including user and certificate authentication via TCP/IP and HTTP.
  • No programming needed on source or target database platforms.
  • Source and target table access via standard .NET data provider protocol.
  • Remote administration of DBMoto Replicator through the
    DBMoto Management Center Console:
    • Identify and connect to multiple source and target databases.
    • Create target tables.
    • Manage and control access to replication configurations.
    • Sets up replication processes and groups them for efficient execution.
    • Store replication mapping and rules in a metadata database.
    • Monitor replication processes, compares results and analyzes issues.
    • Access real-time information on replication status.
    • Record replication activity, performance and errors into logs, to quickly spot and manage errors.

System Requirements

  • Microsoft Windows Server 2016/2012/2008
  • NET Framework 4.0 or higher

Learn More About DBMoto

Learn More

See Supported Databases

Learn More
You Can't Make Good Business Decisions Today with Yesterday's Data
Ten Tips for Change Data Capture
McDougall Energy
WordPress Video Lightbox