Hello,

We would like to let you know that we have released dbForge Studio Beta for MySQL, v6.0 where the Database Refactoring functionality is implemented: http://www.devart.com/dbforge/mysql/studio/download.html

It is well known that the refactoring of a database is not an easy task and every developer or administrator, sooner or later, encounters it.

You should expect problems when refactoring a MySQL database in the following cases:

1) When renaming the table column referenced by the column of another table via foreign key.
2) When renaming the table column or the table itself from which data is fetched in a view.
3) When renaming objects with code.

All the above cases were handled by us during developing this functionality and tested on real databases.

In our application, Refactoring can be invoked from the popup menu of each object in Databse Explorer as well as from the visual object editor when changing the name of already existing object.

In the new version, the Refactoring functionality is being the key feature that has collected the most user votes.

According to our data, the database refactoring functionality is not implemented in any existing tool for MySQL administering.

While implementing the new feature, we had to totally redesign the following existing functionality: schema comparison, database backup, script generating, code completion and formatting.

As a result, the new release was delayed for 2-3 months.

We thank all the users who were taking part in the voting for this functionality and, as always, we are looking forward to new feedbacks or suggestions.

Best regards,
Devart Team
http://www.devart.com