Method and system for replicating data to heterogeneous database and detecting synchronization error of heterogeneous database through sql packet analysis

A system for replicating data to a heterogeneous database and detecting a synchronization error through a structured query language (SQL) packet analysis, the system comprising:

• a first operating server configured to operate a source database;
• a second operating server configured to operate a heterogeneous database of separate processed replicated data;
• and
• a replication server configured to extract an SQL transmitted from a client to the source database in a network stream transmitted from a client to the first operating server, convert a data structure, and transmit the converted data structure to the second operating server,
• wherein the replication server includes:
• a sniffing module configured to capture packets transmitted between the client and the first operating server or between the client and the source database;
• a proxy module configured to collect packets while serving to relay data between the client and the first operating server;
• a packet analysis module configured to analyze the packets captured by the sniffing module and the proxy module and extract SQLs and bind values;
• an SQL sorting module configured to analyze the extracted SQLs and sort SQL queries required for synchronization and synchronization verification;
• a data standardization module configured to convert the extracted SQLs and the bind values into a column-value structure to correspond a schema of a source table;
• a data structure conversion module configured to perform a change operation of a data structure corresponding to the second operating server which is a target replication system;
• and
• a converted data application module configured to transmit the converted data to the second operating server,
• wherein the source database is synchronized with a target heterogeneous database.