Some type of resolving mechanism similar to kbmMW’s resolver component for mapping fields and handling the generating of the SQL needed to update the remote server. They have a generic resolver which can be adapted easily depending on the database you are working with. They also have a number of specific ones written for specific database vendors.