Migrate is putting map tables in legacy database
Read up on the documentation on Map Tables under the heading Map Tables on that page. If you define legacy as the connection to make the map tables on -- then that's where they will go.


  When you construct the MigrateSQLMap object, add a fourth argument to
  tell it explicitly the connection on which to create the mapping
  tables.