Bug #17467 MTK does not detect and translate synonyms
Submitted: 16 Feb 2006 15:13 Modified: 14 May 2009 12:40
Reporter: Kristian Koehntopp Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S4 (Feature request)
Version:1.0.23 OS:Windows (Windows)
Assigned to: CPU Architecture:Any

[16 Feb 2006 15:13] Kristian Koehntopp 
Description:
Oracle allows multiple names for an object (Synonyms). Synonyms are currently not detected and resolved by MTK.

Synonym defintions must be translated manually into their resolved object names.

How to repeat:
Create a public synonym for an object in Oracle, try to migrate it. Watch the object being not available in the migration.

Suggested fix:
Detect synonyms, and resolve them into their base object names. Alternatively, use FEDERATED to create a link to them.
[18 Mar 2009 11:16] Susanne Ebrecht 
Verified as described.
[14 May 2009 12:40] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Migration Tool into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/