How to get rid of or change Schema name in Bulk Transfer
Hi,
I am trying to merge tables in multiple Oracle (8.1.7.4) Schemas (under the same SID) ONLINE to a single MySQL schema (database) using MySQL Migration Toolkit. I can edit the CREATE TABLE statements to alter (or get rid of) the original schema names in the "Manual Editing" step that allows me to successfully create all the tables in one MySQL schema! However, the toolkit is trying to transfer the data to the old schemas in the "Bulk Transfer" step, and I could not edit the INSERT scripts to use the new common schema as the destination. An example is:
INSERT INTO `reserve`.`authentication`(`username`, `password`, `first_login`, `name`, `email`, `pwd_expires`)
I want to get rid of `reserve`. as below -
INSERT INTO `authentication`(`username`, `password`, `first_login`, `name`, `email`, `pwd_expires`)
Or I want to have -
INSERT INTO `abc`.`authentication`(`username`, `password`, `first_login`, `name`, `email`, `pwd_expires`)
Where `abc` is my new common schema.
Any hint will be much appreciated.
Thanks.