MySQL Forums
Forum List  »  Microsoft Access

Re: Bulk Data Transfer failure in a changed Target Schema
Posted by: Sebastien Caisse
Date: January 03, 2006 09:41AM

I've never been able do "drop" columns during migration... Perhaps you mean that you've edited the CREATE statements (since the tables created would indeed work out). As such, the schema you've created is OK, however the migration toolkit is totally unaware of the changes you've made (since it assumes editing of the selct statement doesn't affect the rows itself, but does other more trivial things duch as say, adding comments).

My suggestion (which is what I ended up doing during my migration) was to rename the rows I didn't need to "xxRow" and then manually drop them myself (and then optimize the tables just in case).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Bulk Data Transfer failure in a changed Target Schema
1628
January 03, 2006 09:41AM


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.