I have a database in which there is one table where one column has invalid data.
I also have a backup of said database of a few days before. In that backup, that column still has the valid data. But other tables in that database are already incredibly outdated.
So, a full rollback to that backup is not an option. Rather, I would like to only import that single, corrupted column from the backup into the current database.
The live database has also accumulated a few new, valid rows in that table. Obviously, we would like those to be preserved.
I can't think of a way that doesn't involve heavy, manual editing. Can this be automated?