How to use Automigrate to merge two tables into one

[pingsutw]

Your Question

I have two tables in the database, and I want to run a migration to merge those two tables into one.
For now, I read two tables into memory and then insert each row into the third table.
I want to know if there is a best practice to do that.

Expected answer

It would be great if anyone can share an example