Data Integration and Real-time Replication for Heterogeneous Databases: Connecting MySQL to Oracle, DB2, SQL Server, and Others

Products & Services
Location: Ballroom H Level: Novice

HiT Software provides DBMoto™, a powerful data replication engine that synchronizes data among heterogeneous databases for migration and bi-directional real-time updates. In this session, DBMoto’s architect, Marco Sandrini, will walk attendees through a technical review and customer implementation example of mirroring between MySQL and other major databases. DBMoto’s functionality includes support for remote replication, fast CSV loading, replication grouping, recovery, and visual error-checking. Used today by enterprises worldwide, DBMoto gives MySQL database administrators a quick and programming-free solution for large-scale database replication requirements.

Session Details:

  • Data Replication “Mirroring” – heterogeneous database benefits and considerations
  • Architectural examples
  • Demonstration: Oracle to MySQL example – multi-threaded processing and performance tuning
    • Remote replication, installing on a remote system to avoid impact on source or target databases
    • Fast loading via CSV (20 times faster than standard inserts)
    • Log-based mirroring – usage of binary logs in replications
    • Replication grouping. Advantages of multi-connections in parallel and single connections in a series, and the impact on performance versus resources.
    • Advanced scripting options in Mirroring
    • Recovery features
    • Error Management. DBMoto’s GUI interface for easy, visual error checking and resolution.
  • Q&A
Photo of Marco Sandrini

Marco Sandrini

HiT Software, Inc.

Marco Sandrini has lead HiT Software’s Data Integration team as Manager/Lead Software Developer for nearly a decade. He is responsible for the creation of DBMoto, HiT’s proven data replication product for large-scale data integration and synchronization projects. Marco is also responsible for the development of Allora™, HiT Software’s bi-directional XML-RDBMS transformation solution. Marco’s expertise as project lead, programmer and software designer spans data access, connectivity and security products.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.