Chapter 9 Database Migration Wizard

Table of Contents

9.1 General installation requirements
9.1.1 ODBC Libraries
9.1.2 ODBC Drivers
9.2 Migration Overview
9.2.1 A visual guide to performing a database migration
9.2.2 Migrating from supported databases
9.2.3 Migrating from unsupported (generic) databases
9.3 Conceptual DBMS equivalents
9.4 Microsoft Access Migration
9.5 Microsoft SQL Server migration
9.5.1 Preparations
9.5.2 Drivers
9.5.3 Connection Setup
9.5.4 Microsoft SQL Server Type Mapping
9.6 PostgreSQL migration
9.6.1 Preparations
9.6.2 Drivers
9.6.3 Connection Setup
9.6.4 PostgreSQL Type Mapping
9.7 MySQL migration
9.8 Using the MySQL Workbench Migration Wizard
9.8.1 Connecting to the databases
9.8.2 Schemata Retrieval and Selection
9.8.3 Reverse Engineering
9.8.4 Object Selection
9.8.5 Migration
9.8.6 Manual Editing
9.8.7 Target Creation Options
9.8.8 Schema Creation
9.8.9 Create Target Results
9.8.10 Data Transfer and Migration Setup
9.8.11 Bulk Data Transfer
9.8.12 Migration Report
9.9 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, OS X, and Microsoft Windows, and the Database Product Specific Notes section that references setup conditions for each RDBMS.