MySQL Forums
Forum List  »  Microsoft Access

Bulk Data Transfer failure in a changed Target Schema
Posted by: Giorgio Corito
Date: January 03, 2006 07:08AM

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

Options: ReplyQuote

Written By
Bulk Data Transfer failure in a changed Target Schema
January 03, 2006 07:08AM

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.