Oracle SQL Developer Supplementary Information for Microsoft SQL Server and Sybase Adaptive Server Migrations provides detailed information about migrating a database from Microsoft SQL Server 7.0, 2000, or 2005 to Oracle, or from Sybase Adaptive Server 12 or 15. It is a useful guide regardless of the conversion tool you are using to perform the migration, but the recommended tool for such migrations is Oracle SQL Developer (SQL Developer). This reference guide describes several differences between Microsoft SQL Server or Sybase Adaptive Server and Oracle, and outlines how those differences are handled by SQL Developer during the conversion process.

Intended Audience

This guide is intended for anyone who is involved in converting a Microsoft SQL Server or Sybase Adaptive Server database to Oracle using Oracle SQL Developer.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

What You Should Already Know

You should be familiar with relational database concepts and with the operating system environments under which you are running Oracle and Microsoft SQL Server or Sybase Adaptive Server.

Related Documents

For more information, see these Oracle SQL Developer resources:

Oracle error message documentation is only available in HTML. If you only have access to the Oracle Documentation CD, you can browse the error messages by range. Once you find the specific range, use your browser's "find in page" feature to locate the specific message. When connected to the Internet, you can search for a specific error message using the error message search feature of the Oracle online documentation.

To download free release notes, installation documentation, white papers, or other collateral, go to the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at

If you already have a user name and password for OTN, then you can go directly to the documentation section of the OTN Web site at


The following text conventions are used in this document:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.