What are the steps performed by Migration Wizard while migrating a database to MySQL

Question

Hi!!

I am new to Workbench, and I'm facing difficulties while migrating databases.

Can someone tell me what ar3 the steps while migrating databases?

Answer 1

The following are the steps  performed by Migration Wizard while migrating a database to MySQL:

• Initially, it connects to the source RDBMS and retrieves a list of available databases.
• Performs Reverse engineering of the selected database into an internal representation specific to the source RDBMS. So, with this step, all the objects are renamed based on the type of object name mapping method that is chosen.
• Then, it automatically starts migrating the source RDBMS objects into MySQL specific objects.
• After that, it allows us to review the changes so that we can edit and correct errors in the migrated objects.
• Then it creates the migrated objects in the target MySQL server. You can always go back to the previous step and correct the errors if any occur.
• Finally, the data of the migrated tables are copied from the source RDBMS to MySQL.