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

0 votes
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?
Dec 10, 2018 in Database by DataKing99
• 8,130 points
100 views

1 answer to this question.

0 votes

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.
answered Dec 10, 2018 by darklord
• 6,170 points

Related Questions In Database

0 votes
1 answer

How to display the queries executed by a particular user in MySQL?

From the version 5.1.7 onward, MySQL allows ...READ MORE

answered Mar 7 in Database by Mishti
• 480 points
48 views
0 votes
1 answer

What is the ORDER BY statement in MySQL?

This statement is used to sort the ...READ MORE

answered Nov 23, 2018 in Database by darklord
• 6,170 points
37 views
0 votes
1 answer

What are the various MySQL Workbench editions?

MySQL Workbench is mainly available in three ...READ MORE

answered Dec 6, 2018 in Database by CodingByHeart77
• 3,690 points
52 views
0 votes
1 answer

What is MySQL Workbench?

MySQL Workbench is a designing or a ...READ MORE

answered Nov 29, 2018 in Database by darklord
• 6,170 points
26 views
0 votes
1 answer
0 votes
1 answer

What are the advanced MySQL Wokrbench capabilities?

Advanced MySQL Capabilities Provides an extension system that ...READ MORE

answered Dec 10, 2018 in Database by darklord
• 6,170 points
46 views
0 votes
1 answer

What are the ways of Data Import and Export in MySQL Workbench?

There are majorly three ways to export ...READ MORE

answered Dec 14, 2018 in Database by DataKing99
• 8,130 points
222 views
0 votes
1 answer

What are the ways to get the count of records in a table

To count the number of records in ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,170 points
96 views
0 votes
1 answer

What are the different types of keys used in the database?

There are mainly 5 types of Keys, ...READ MORE

answered Nov 19, 2018 in Database by darklord
• 6,170 points
108 views