Editing Data while Migration
Posted by: Patrick Stalder
Date: October 12, 2010 02:54AM


I want to migrate Data from a Webserver to a newer one, but there is another datamodell so i need to edit the data an do changes while migrating (e.g if statements). I want to do stuff like:
If the oldtable.Userlevel is higher than 100 -> write newtabel.Admin = 1

and i want to map single attributes to different tables:

oldtable1.username -> newtable1.username
oldtable1.gender -> newtable43.gender

Is this even possible with the MySQL migration Toolkit? And if yes, how?

Please help, thanks!

Options: ReplyQuote

Written By
Editing Data while Migration
October 12, 2010 02:54AM
October 17, 2010 10:03PM

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.