MySQL

MySQL Supported Objects and Core Features


Supported Migration Objects

 Tables
(Click for larger view)
 Constraints
 Indexes
 Users
 Groups/Roles
 Collection data types, sequences
 User-defined Types
   

MySQL Core Features

SQL Developer Migration technology supports the following core features when migrating from MySQL:

  • Automatically converts column data types to appropriate Oracle data types.
  • Automatically resolves object name conflicts, such as conflicts with Oracle reserved words.
  • Stores database metadata in a repository where you can make changes.
  • Retrieves source database information via online capture or offline capture.
  • Provides advanced customization capabilities such as the ability to change data type mappings, delete and rename objects.
  • Generates reports about the status of the migration.
  • Generates the DDL scripts for the creation of the destination Oracle database.
  • Generates scripts for data movement.
  • Allows you to migrate objects to existing Oracle tablespaces.
  • Displays informational, error, and warning messages about the migration in a progress window.

Previous

Learn more about MySQL Migrations with
Video Demonstrations and Documentation
See this Quick Video on How to Migrate with SQL Developer Go