Database replication across different database platforms

摘要

Database replication across different database platforms is carried out by transforming a binary log of database updates made to a first database into an SQL loader format of a second database and then processing the transformed log of updates into the second database. The transformation of the binary log includes the step of parsing the binary log into SQL statements, storing the SQL statements as a flat file, and transforming the flat file into an input file having the SQL loader format of the second database. The metadata of the flat files is stored in a separate database. As the flat files are transformed into input files of the second database, the status of the flat files is updated in the metadata database.