dbForge recognise change of column name in the schema compare?

[davidlyons24]

Hello,

I've been trying if "dbForge Schema Compare for MySQL" recognises the change of column names copying two databases and changing the column names in the first one, then I do a dbCompare and it shows me the change in blue color, so it recognises that I modified the column name, but when I click "show schema Update script" it shows me now that it will drop the column and then create a new one so it means that I'll lose the data in the column in case I execute this script!

This is the script that has been generated when I change the column name 'manga' to 'manga2' and the lenght of Int of 'eslora' column:

ALTER TABLE amarres
DROP COLUMN manga,
CHANGE COLUMN eslora eslora INT(12) DEFAULT NULL,
ADD COLUMN manga2 INT(11) DEFAULT NULL AFTER eslora;

You can see that it drops the column 'manga' I think that's a big mistake and should be 'MODIFY'

Thanks in advance,
David Lyons

[alexa]

We will change the current behavior in one of the next builds of dbForge Schema Compare for MySQL and will notify you once it's available for downloading.