The invention relates to a
system and method for
synchronizing discrepant data of a common domain between databases. The method includes the steps that the discrepant data are read, related configuration information of a data table is inquired according to discrepant
data information, and a first search condition is generated according to the related configuration information; whether the discrepant data exist or not is searched for at the common domain of the two databases according to the first search condition, and accordingly search results are recorded; baseline information of the discrepant data is inquired according to the discrepant
data information, and a second search condition is generated according to the baseline information; a stored
record of the discrepant data is searched for in a baseline
library according to the second search condition, a needed
SQL statement is formed according to the second search condition and the searched stored
record of the discrepant data in the baseline
library, and the data of a non-baseline
library are modified through the formed
SQL statement by using the
record of the baseline library as the baseline. By the adoption of the
system and method, data synchronous
processing effectiveness is guaranteed, data synchronous accuracy is improved, and mistakes and hidden risks caused by negligence of operators are reduced.