Hi,

I am new bie to MYSQL. I have a requirement of data migration from one DB to another DB in MYSQL.Tables structure and column names are different in both source and Target.I need to Auto increment the PK in my target and some other columns data supposed to load as it is .Can any one suggest me the best practise in MYSQL for doing this migration.


Regards,
Pradeep06.