Microsoft SQL Server

Microsoft SQL Server Supported Objects and Core Features

Supported Migration Objects

  • Tables
  • Views
  • Constraints, Primary and Foreign Keys
  • Indexes
  • Stored Procedures and Functions
  • Triggers
  • SQL Server Identity Columns
  • Temporary Objects
  • Defaults
  • Users
  • User-defined Types

SQL Server Migration Core Features

SQL Developer supports the following core features when migrating from Microsoft SQL Server:

  • Automatically converts column data types to appropriate Oracle data types.
  • Automatically resolves object name conflicts, such as conflicts with Oracle reserved words.
  • Parses and transforms T-SQL stored procedures, functions, triggers, and views to Oracle PL/SQL.
  • 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
  • Displays informational, error, and warning messages about the migration in a progress window.

See this Quick Video on How to Migrate with SQL Developer (10:00)