MS SQL Server

Microsoft SQL Server Supported Objects and Core Features


Supported Migration Objects

 Tables

Click for larger view
 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.

Previous


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


In-Memory Replay Banner