Bulk Data Transfer failure in a changed Target Schema
Hi,
my goal is to transfer data from an Access DB to A MySQL DB (Obviously!!!).
During "Manual Edit" step, I change the Target Schema of a table ->
1. I drop some columns;
2. I alter the data type of some columns;
3. I drop all indexs and constraints.
I've tried that on a single table, only for testing the process.
After applying changes, my target schema of table is as I want.(OK)
During "Schema Creation" step, the sql script reflect changes I've applied.(OK)
During "Data Mapping" step, message log dialog show the SELECT used to retrive data to transfer in target table....
!!! in this SELECT there are the columns I've dropped (KO!!!!)
So, the "Bulk Transfer" step fails because INSERT refers to some columns not existing in target table!!
THANK YOU for any help
Subject
Views
Written By
Posted
Bulk Data Transfer failure in a changed Target Schema
3015
January 03, 2006 07:08AM
1776
January 03, 2006 09:41AM
1879
January 03, 2006 10:01AM
1825
January 04, 2006 06:09AM
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.