Guide to Migrating from Oracle to SQL Server 2005
Download
|
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2005. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant for Oracle (SSMA Oracle) is explained in depth, with a special focus on converting database objects and PL/SQL code.
Included in this document:
| • | Overview of Oracle-to-SQL Server 2005 Migration |
| • | Data Migration Architecture of SSMA for Oracle |
| • | Migrating Oracle Data Types |
| • | Emulating Oracle System Objects |
| • | Converting Nested PL/SQL Subprograms |
| • | Migrating Oracle User-Defined Functions |
| • | Migrating Oracle Triggers |
| • | Emulating Oracle Packages |
| • | Emulating Oracle Sequences |
| • | Migrating Hierarchical Queries |
| • | Emulating Oracle Exceptions |
| • | Migrating Oracle Cursors |
| • | Simulating Oracle Transactions in SQL Server 2005 |
| • | Simulating Oracle Autonomous Transactions |
| • | Migrating Oracle Collections and Records |
| • | Conclusion |
