Error While Importing Table Structure And Data Form Oracle To Mysql

[Avinash]

Hi All,

Currently we are working on Oracle to MySQL migration using SQLyog.

Below are the MySQL and SQLyog versions being used

MySQL : 6.0.11-alpha[Windows 32 bit]

MySQL Migration Tool : SQLyog-8.7.1-0 Trail Version

While importing the table structure and data we are getting 'Key column doesn't

exist in table' error and the error code is 1072. Also we noticed that in few cases

though import is successfull(for few tables) not all the columns are imported.

Attached is the sja log file.

Please let us know about the root cause for the above error.

Waiting in anticipation for your reply.

Thanks & Regards

Avinash

[peterlaursen]

OK .. we will check this. We will probably need more information but wait for us to ask this. But it looks like the oracle Database uses 'virtual columns'. This is not supported by MySQL (with the exception of the latest MariaDB release) and I think not by ODBC either.

Also you should not use MySQL 6.x. It is discontinued. Use 5.1 or 5.5 tree's instead.

[Aparna]

Hi Avinash,

In order to identify the exact issue we require the following information:

1. The version of ORACLE you are using.

2. The schema of the table that you are trying to import.

3. Please attach your import job file here(If you do not have one created then you can crate it during the import process by selecting the saving option->save job file and finally specifying the path and the file name where you want to store the job file).

Regards,

Aparna.

[Aparna]

Please find the screen shots attached here for the instructions given above.(Instructions given to create a job file).

[Avinash]

Hi Aparna,

Below are the oracle/mysql versions being used.

Oracle : 10g

MySQL : 6.0.11-alpha[Windows 32 bit]

MySQL Migration Tool : SQLyog-8.7.1-0 Trail Version

Please find attached the job profile and sample table schema.

Waiting in anticipation for your reply.

Regards

Avinash

[Avinash]

Hi Aparna,

Attached is jobprofile for the sample import.

Regards

Avinash

[Aparna]

Hi Avinash,

From the jobfile and the table structure that you have provided I can understand that you have defined unique index on many columns where as you are trying to import just a single column from that index group. In this case for SQLyog to import the data successfully you either have to select all columns or uncheck the option that reads import index from the advanced tab.

Regards,

Aparna.

[Aparna]

Hi Avinash,

Do you still have problems while importing data from oracle? If yes then please let us know the issue and we will be glad to assist you.

Regards,

Aparna.

[Author]

Posts