Synchronization of recurring records in incompatible databases

A computer program, resident on a computer readable medium, for synchronizing at least a first and a second database, wherein the manner of storing a set of recurring date bearing instances differs between the first and second databases, and at least the first database uses a recurring record to store the set of recurring date bearing instances, comprising instructions for:

• processing a plurality of non-recurring records in the second database to identify a set of non-recurring records storing the set of recurring date bearing instances in the second database;
• performing a comparison of the set of non-recurring records of the first second database to a recurring record of the first database;
• and
• completing synchronization based on the outcome of the comparison.

A computer implemented method of synchronizing at least a first and a second database, wherein records in the first and second databases include a key field, the method comprising:

• performing a first comparison of the content of the key field of the records of the first database with the content of the key field of the records of the second database;
• selecting a plurality of groups of records of the first and second databases based on the outcome of the first comparison;
• performing a second comparison of the records in one of the plurality of groups of records to determine a correspondence between a record of the first database in the one of the plurality of groups and a record of the second database in the one of the plurality of groups;
• performing a third comparison of the records in the determined correspondence;
• and
• completing the synchronization based on the outcome of the third comparison.

A computer program, resident on a computer readable medium, for synchronizing at least a first and a second database, wherein records in the first and second databases include a key field, comprising instructions for:

• performing a first comparison of the content of the key field of the records of the first database with the content of the key field of the records of the second database;
• selecting a plurality of groups of records of the first and second databases based on the outcome of the first comparison;
• performing a second comparison of the records in one of the plurality of groups of records to determine a correspondence between a record of the first database in the one of the plurality of groups and a record of the second database in the one of the plurality of groups;
• performing a third comparison of the records in the determined correspondence;
• and
• completing the synchronization based on the outcome of the third comparison.