MySQL Workbench Manual  /  ...  /  Migrating from supported databases

10.2.2 Migrating from supported databases

When a supported RDBMS product is being migrated, the MySQL Workbench Migration Wizard will automatically convert as much information as it can, but you may still be required to manually edit the automatically migrated schema for difficult cases, or when the default mapping is not as desired.

Generally speaking, only table information and its data are automatically converted to MySQL. Code objects such as views, stored procedures, and triggers, are not. But supported RDBMS products will be retrieved and displayed in the wizard. You can then manually convert them, or save them for converting at a later time.

The following RDBMS products and versions are currently tested and supported by the MySQL Workbench Migration Wizard, although other RDBMS products can also be migrated with Section 10.2.3, “Migrating from unsupported (generic) databases”

  • Microsoft SQL Server 2000, 2005, 2008, 2012

  • Microsoft Access 2007 and greater

  • MySQL Server 4.1 and greater as the source, and MySQL Server 5.1 and greater as the target

  • PostgreSQL 8.0 and greater

  • SQL Anywhere

  • SQLite

  • Sybase Adaptive Server Enterprise 15.x and greater

Download this Manual
PDF (US Ltr) - 14.7Mb
PDF (A4) - 14.7Mb
EPUB - 12.8Mb
HTML Download (TGZ) - 12.7Mb
HTML Download (Zip) - 12.8Mb
User Comments
Sign Up Login You must be logged in to post a comment.