Trying to work with MySQL Workbench on some schema changes. I must say I’m fairly disappointed in how it handles the forward engineering / sync with database when I change a column name. Should it alter the column? Of course not, it does a drop on the column and an add of a new column. It’s ok that all the data is lost, we needed to rename the column to better follow convention! You had to expect data loss, right?
Yes, that was annoying, so I’ll have to fix that in the schema upgrade script by hand. Oh wait, there are more failures. The upgrade script generated fails every time because the column it wants to delete and add a new one is a foreign key, and that’s an incredibly impossible concept to understand.
Sorry, just venting my frustration with this tool that I had hoped was ready for primetime usage. I guess not. Alternative suggestions anyone? Or shall I just do it manually?



