What is the difference between UPSERT and Database Diff Processor?

There is no functional difference between the UPSERT option in a Database Table Destination and the Database Diff Processor write strategy. We have retained the Database Diff Processor to ensure backward compatibility for users who have been using it.