MySQL Bugs: #43663: Migration Toolkit does not migrate column and table level comments from Oracle

Bug #43663	Migration Toolkit does not migrate column and table level comments from Oracle
Submitted:	16 Mar 2009 6:51	Modified:	11 May 2012 13:42
Reporter:	Valeriy Kravchuk	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	1.1.17	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
MySQL supports comments for both columns and table, but Migration Toolkit does not migrate column and table level comments from Oracle. This is a serious problem while migrating huge schemas from Oracle.

How to repeat:
In Oracle:

SQL> connect scott/tiger
Connected.
SQL> create table tc (c1 int);

Table created.

SQL> comment on table tc is 'table comment';

Comment created.

SQL> comment on column tc.c1 is 'column comment';

Comment created.

Then start migration process. Try whatever options but you will get the following script:

-- ----------------------------------------------------------------------
-- MySQL Migration Toolkit
-- SQL Create Script
-- ----------------------------------------------------------------------

SET FOREIGN_KEY_CHECKS = 0;

CREATE DATABASE IF NOT EXISTS `scott`
  CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `scott`;
-- -------------------------------------
-- Tables

DROP TABLE IF EXISTS `scott`.`tc`;
CREATE TABLE `scott`.`tc` (
  `c1` DECIMAL(22, 0) NULL
)
ENGINE = INNODB;

SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------------------------------------------------
-- EOF

So, comments are lost.

Suggested fix:
Check Oracle's data dictionary for comments on tables and columns and generate proper clauses for CREATE TABLE in MySQL.

Does anyone know if this will be added into the toolkit anytime soon?

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 fix this anymore in MySQL Migration Toolkit. But we will take this here as feature request for the new implementation.

More informations about MySQL Workbench you will find here:

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

When will the MySQL Migration Toolkit functionality appear in MySQL Workbench?