How to rename target schemata and tablenames during migration in MT
Posted by: Michael G. Zinner
Date: August 06, 2005 05:26AM

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.


Michael Zinner, Team Lead, Developer Tools

Are you MySQL certified?

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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.