Supported Migration Objects

• Tables
• Views
• Indexes
• Users
• Constraints

IBM DB2 LUW Core Features

SQL Developer supports the following core features when migrating from IBM DB2 LUW:

• 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.
• Parses and transforms Views to Oracle PL/SQL Views
• 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.