dbForge for MySQL refactoring trouble

[Beval]

I am interested in using dbForge 6.2 for MySQL primarily for the purpose of refactoring InnoDB databases.

Renaming table names seems to work fine; dependencies (such as views and stored procedures) are updated with the new names as required.

However, renaming datacolumn names seems to be non-working. Not a single experiment worked out. No dependencies in views, triggers or stored procedures were ever identified correctly. In fact, most of the time the operation either crashed dbForge or caused the application to freeze (requiring a termination of its process).

Is this a known issue or am I doing something wrong?

[alexa]

Could you please provide us the CREATE definitions of the objects and describe the steps to reproduce this issue step by step? Screenshots would be also of help.

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

[Beval]

Unfortunately I cannot submit any database schema information.

However, I can tell you the datacolumn refactoring tool surprisingly started to work when I copied the schema from a database schema which had both lower and UPPER case letters in its schema name (in this schema, the tool still doesn't work), to a schema on the same server with all lower case letters in its name.

Perhaps this could be the cause of the bug? If so, this is problematic for users with mixed case schema names.

[alexa]

In order to determine the problems, please try generating script changes with the 'Script Changes' button available in Table Editor and execute the resulting script manually.

[Beval]

When I do this, the program asks "Do you wish to start refactoring to make appropriate modifications in the dependent objects?". The script, which is presented into a new window ("Preview Changes - Rename", simply renames the datacolumn and affects no dependencies.

[alexa]

Thank you for the reply.

We will investigate this issue when developing future product builds.

[alexa]

We would like to let you know that we have released a new version 6.3 of dbForge Studio for MySQL where the issue you reported is fixed http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.