If you do not proactively set up a mechanism to store old data (via logs, cache, or triggers), old data is often not automatically saved when updating SQL.