Re: Different Hosts, Different Schemas, Migration Help Needed
Posted by: Juan Rene Ramirez Monarrez
Date: October 31, 2013 09:53AM

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!

Options: ReplyQuote

Written By
Re: Different Hosts, Different Schemas, Migration Help Needed
October 31, 2013 09:53AM

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.