I am a...
I want to...
Microsoft SQL Server Supported Objects and Core Features
Supported Migration Objects
Click for larger view
Constraints, Primary and Foreign Keys
Stored Procedures and Functions
SQL Server Identity Columns
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.
Learn more about SQL Server Migrations with
Video Demonstrations and Documentation
See this Quick Video on How to Migrate with SQL Developer
E-mail this page
Learn About Oracle Cloud Computing
Get a Free Trial
Learn About DaaS
Learn About SaaS
Learn About PaaS
Learn About IaaS
Learn About Private Cloud
Learn About Managed Cloud
Learn About Java
Download Java for Consumers
Download Java for Developers
Java Resources for Developers
Java Cloud Service
Customers and Events
Explore and Read Customer Stories
All Oracle Events
Social Media Channels
Services and Store
Log In to My Oracle Support
Training and Certification
Become a Partner
Find a Partner Solution
Purchase from the Oracle Store
Contact and Chat
Hardware and Software, Engineered to Work Together
Oracle RSS Feed