How to rename target schemata and tablenames during migration in MT

[Michael G. Zinner]

Several people have asked if it is possible to use different names for target object because they want to user different names on MySQL side. It sure is.

There are two places where the rename can be performed.


1) On the Advanced Mapping page

You can rename every object (schema, table, columns, indices) on the Advanced Mapping page. To get to that page you have to press [Advanced >>] button on the Object Mapping page and enable the following option.

[X] Enable detailed mapping definitions in next step

Click on the object name in the Target Names column and press F2 to rename it.


2) On the Manual Editing page

Another, simplier way is to change the object names on the manual editing page.

Simply select the filter [Show All Objects] there, click on the schema or table you want to rename in the Target Objects column and press F2.

After you have renamed an object, all SQL Create statements will be re-generated. You can check this by clicking the [Advanced >>] button which will displaying the SQL statements.

If you want to modify the SQL statements manually please do this after you have renamed the objects, or you manual changes will be lost due to the re-generation of the SQL statements.

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification



Edited 2 time(s). Last edit at 08/06/2005 06:23AM by Michael G. Zinner.