There is no simple way for dbFront to connect field names before and after rename. There is no common Id or any other marker.
So currently dbFront assumes that a single column deleted and a single column added equals a rename.
Therefore, you need to rename a single column at a time and refresh dbFront so that it can capture the changes before renaming the next column.
The process would be:
- Open dbFront and view the table you are changing.
- Change the column name,
- Refresh dbFront (F5) which would force it to capture and see the column name change.
- Change the next column name,
- Refresh dbFront (F5) and repeat...
An easy way to verify the changes is to open the Database Preference and view a diff/compare of the latest backup history. It should clearly show all of the renamed fields. You can also scan the backup for anything that might have been missed.