MySQL Database Refactoring Tool

Renaming MySQL tables

When manually renaming database tables using the ALTER TABLE statement, you run the risk of breaking database dependencies. And the consequences of the seemingly simple changes can be disastrous. Ensuring that all references to the renamed table reflect its new name can take much time and effort.

With the help of dbForge Refactoring tool, you can quickly and easily rename database tables, including the temporary ones, and the tool will automatically correct all references to the renamed objects.

Renaming columns referenced by other columns using foreign keys

When renaming a column, you always need to worry about references that use foreign keys - if you manually rename a column, these dependencies will be lost or you will have to find all foreign keys, delete them, then rename the column and recreate the keys.

The dbForge database refactoring tool for MySQL saves you the trouble. The application will find all foreign keys and will apply the new column name throughout the entire database.

Renaming objects with code

To rename an object that contains code, for example, a stored routine, you need to be twice as careful as you were in the previous situations. If you rename your stored routine and make a mistake in the code, the procedure or function will be lost and you will have to recreate it from memory.

dbForge Studio for MySQL refactoring tool uses an algorithm, that is different from the one available in all MySQL administration tools:

• 1. A temporary stored routine is created. It contains the code of the procedure before renaming.
• 2. All objects that use this routine are deleted.
• 3. All objects that use this stored routine are recreated, but the routine is renamed.
• 4. The routine with a new name and new code is created.
• 5. The temporary stored routine is deleted.
In case the fifth step fails, the script execution stops and the original code can be restored from the temporary object.