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
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.
© 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.