Chapter 10 Database Migration Wizard

Table of Contents

10.1 General installation requirements
10.1.1 ODBC Libraries
10.1.2 ODBC Drivers
10.2 Migration Overview
10.2.1 A visual guide to performing a database migration
10.2.2 Migrating from supported databases
10.2.3 Migrating from unsupported (generic) databases
10.3 Conceptual DBMS equivalents
10.4 Microsoft SQL Server migration
10.4.1 Preparations
10.4.2 Drivers
10.4.3 Connection Setup
10.4.4 Microsoft SQL Server Type Mapping
10.5 PostgreSQL migration
10.5.1 Preparations
10.5.2 Drivers
10.5.3 Connection Setup
10.5.4 PostgreSQL Type Mapping
10.6 MySQL migration
10.7 Using the MySQL Workbench Migration Wizard
10.7.1 Connecting to the databases
10.7.2 Schemata Retrieval and Selection
10.7.3 Reverse Engineering
10.7.4 Object Selection
10.7.5 Migration
10.7.6 Manual Editing
10.7.7 Target Creation Options
10.7.8 Schema Creation
10.7.9 Create Target Results
10.7.10 Data Migration Setup
10.7.11 Bulk Data Transfer
10.7.12 Migration Report
10.8 MySQL Workbench Migration Wizard FAQ

MySQL Workbench provides the ability to migrate ODBC compliant databases to MySQL.

This is not an exhaustive list. The following sections discuss these and additional migration capabilities.

Set up may be the most challenging aspect of using the MySQL Workbench Migration Wizard. There is the installation section, which describes setting up ODBC requirements for Linux, Mac OS X, and Microsoft Windows, and the Database Product Specific Notes section that references setup conditions for each RDBMS.