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

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.

Verified as described.

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/

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.