Thanks for the reply. I apologize for the long delay in acknowledging your reply.

One thing you mentioned is not to explicitly write to the updates table, but take a snapshot on the fly before updating and then only sending changed records.

Does that mean that each table should have some type of field added (like datetime stamp) that records the latest update to that record? Then just create the updates table on the fly based on the last update?

Or do you use the snapshot table that was created with previous update, create a second snapshot on the fly based on current data, compare changes and send updates (Have no idea how I would compare snapshots though.)?

Thanks,

Marcel