I have a Source and a Destination with the exact same structures. The
information in the Source Table for a given Key (example Customer) replaces
all of the information in the Destination Table for the Key.

Is it more effective to create a task to delete all the records for the
customer in the Destination Table and then Insert all the records in the
Source Table - or - create a task to Insert/Update/Delete the Destination
Table from the Source Table?

thanks

The answer I guess is "It depends". Your answer may be different to other
people's answer. Both methods will work but I would be inclined to follow
the UPDATE/INSERT/DELETE path. I cannot really think of a compelling
argument one way or the other. Give it a try and let us know how you get
on.

Allan

"cleo" <cleo (AT) misinformation (DOT) net> wrote