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,100 points
74 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,140 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
22 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,140 points
19 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,680 points
36 views
+1 vote
1 answer

What are the data types in MySQL?

The Data Types of MySQL are as ...READ MORE

answered Dec 12, 2018 in Database by DataKing99
• 8,100 points
38 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,140 points
14 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,140 points
35 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,100 points
66 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,140 points
39 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,140 points
42 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.