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.
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.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at
Oracle customers have access to electronic support through My Oracle Support. For information, visit
http://www.oracle.com/support/contact.html or visit
http://www.oracle.com/accessibility/support.html if you are hearing impaired.
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.
For more information, see these Oracle SQL Developer resources:
Oracle SQL Developer Online Help
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:
|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 type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.|