IBM DB2

DB2 Supported Objects and Core Features


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.

 
Previous

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


In-Memory Replay Banner