American Journal of Applied Sciences

DATABASE REPLICATION IN HETEROGENOUS PLATFORM

Hendro Nindito, Evaristus Didik Madyatmadja and Albert Verasius Dian Sano

DOI : 10.3844/ajassp.2014.1450.1455

American Journal of Applied Sciences

Volume 11, Issue 8

Pages 1450-1455

Abstract

The application of diverse database technologies in enterprises today is increasingly a common practice. To provide high availability and survavibality of real-time information, a database replication technology that has capability to replicate databases under heterogenous platforms is required. The purpose of this research is to find the technology with such capability. In this research, the data source is stored in MSSQL database server running on Windows. The data will be replicated to MySQL running on Linux as the destination. The method applied in this research is prototyping in which the processes of development and testing can be done interactively and repeatedly. The key result of this research is that the replication technology applied, which is called Oracle GoldenGate, can successfully manage to do its task in replicating data in real-time and heterogeneous platforms.

Copyright

© 2014 Hendro Nindito, Evaristus Didik Madyatmadja and Albert Verasius Dian Sano. This is an open access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.