Re: Different Hosts, Different Schemas, Migration Help Needed

[Juan Rene Ramirez Monarrez]

You can use the Migration Wizard in MySQL Workbench.

Follow the wizard steps and when you reach the "Manual Editing" step there's a combo box at the top right corner labeled as "View".

In that combo select "All Objects" and you will get a table with with the details of the source object names and the target object names.

Select the row containing the schema you will migrate, once selected click on the target name and the field will become editable, set the name you want and continue with the wizard.

The migration will end creating the schema on the target host with the new name.

Hope this is helpful!