Oracle Migration Tools Statement of Direction

Updated May 2008

Introduction

Oracle provides a variety of tools that enable customers to easily migrate from third party databases to the Oracle platform. These tools are available today for download from the Oracle Technology Network free of charge.

Status Today

• Oracle SQL Developer
  SQL Developer allows you to migrate your existing Microsoft SQL Server, Microsoft Access, Sybase Adaptive Server, or MySQL databases to any Oracle database in a simple point-and-click process. Tightly integrated with SQL Developer, the migration functionality migrates all schema objects, triggers, stored procedures and data.
  
• Oracle Migration Workbench (10.1.0.4.0 )
  The original stand-alone Oracle Migration Workbench (OMWB) allows you to migrate your existing Informix Dynamic Server, IBM DB2/400 and IBM DB2 UDB database to any Oracle database. This tool migrates all schema objects, triggers, stored procedures and data.

Background to the Re-launch of the Oracle Migration Tools

The OMWB was re-developed and enhanced as an extension to Oracle SQL Developer, thus providing a single environment for the complete lifecycle of the migration project. The extension also provides reports on the migration process.

The initial release of the Migration Workbench in Oracle SQL Developer, in August 2007, supported Microsoft Access, Microsoft SQL Server, including SQL Server 2005, and MySQL. The latest release, Oracle SQL Developer 1.5, also supports Sybase Adaptive Server. The remaining platforms, Informix and IBM DB2, currently still supported by OMWB, will continue to be supported on the original, standalone OMWB (10.1.0.4.0) release.

Using the Migration Workbench in SQL Developer, users can:

• Explore third party databases within SQL Developer. Supported databases:
  • Microsoft Access versions 97, 2000, 2002/XP and 2003
  • Microsoft SQL Server 7, 2000 and 2005
  • MySQL versions 3, 4 and 5.0
  • Sybase Adaptive Server 12 and 15
• Take advantage of different ways to migrate:
• Simple mode: Provides a wizard to carry out a full migration with minimal user interaction.
• Expert mode: Provides fine-grained control over the migration process. This allows users to select objects to migrate. It also allows users to spread the workload among a migration team.
• Least privilege migration - The ability to migrate objects from source to target without the need for DBA privileges. The workbench will migrate objects it has privileges to view so it does not require any special privileges to run.
• Capture a snapshot of the third party database. This provides users with a copy of the third party database that they can browse and modify. This is the static target that will be used in the migration. For safety and security, the third party database is never updated or altered.
• Convert schema objects (tables, views, indexes...) including stored procedures.
• Copy data from the third party database to the newly migrated Oracle database.
• Use SQL Developer to browse, edit and update the newly migrated schema objects and schema data.
• Utilize advanced parsing technology for translation of single SQL statements, SQL scripts and procedural SQL.
• Run supplied reports, from planning and estimation of the migration process, through to execution and completion of the full migration.
• Parallel Online data move - The ability to move the data using a number of parallel connections for increased throughput.
• Offline data move script generation - Generates scripts to allow for export of source data and import to target database of offline data move.
• Language Translation Features - Supports translation of stored programs, procedures, functions, triggers, constraints and views defined in Transact SQL or Microsoft Access SQL.
• Translation scratch editor - An interactive editing facility for Transact SQL and Microsoft Access SQL allowing for instant translation to PL/SQL or SQL. This editor supports both single-statement translation and translation of complex SQL scripts.
• Translation difference viewer - Inline difference viewer for examining translated SQL. This viewer provides color coded side-by-side comparison of translated SQL to display semantic similarities between the source and translated code.

Plans for the Future of Oracle Migration Tools

• In the ongoing work to extend the functionality offered by the Migration Workbench in SQL Developer, support for migration from IBM DB2/400 and IBM DB2 UDB is under development. The standalone OMWB (10.1.0.4.0) release will remain in place until all currently supported platforms are supported through the SQL Developer. At that time the original, standalone OMWB will be desupported.
• The Application Migration Assistant (AMA) will be made available as an extension to SQL Developer.
• The functionality currently provided by the Database Migration Verifier (DMV) will become a feature of the Migration Workbench in SQL Developer. Currently the DMV is a command line tool. This functionality will be a feature of SQL Developer providing the user with a graphical view of the verification status.

Focus areas on OTN (Collateral and Information)

Current support channels for migration customers continue to be offered:

• Migration Technology Center on OTN is the main entry point on OTN for all your migration requirements.
  • Oracle SQL Developer Migration Workbench, focuses specifically on the latest Migration Workbench technology, providing links to articles and demonstrations
  • OMWB for Migrations from Informix, and DB2 Migration
• Migration Solutions Directory on OTN provides a quick and easy way to search for the migration solutions that are best suited to your particular migration.
• Migration Maps provide a set of step-by-step instructions to guide you through the recommended process for the migration of an existing third-party database to Oracle.
• Oracle Migration Knowledge Base offers a collection of technical articles to help you resolve any migration issue.
• Discussion Forums on OTN, monitored by developers
• Oracle Migration Workbench Forum
• Oracle SQL Developer Forum

Support

Oracle SQL Developer is a free product that is supported through Oracle Support for all customers with Oracle Database Support contracts. Customers encountering any issues are encouraged to log a Technical Assistance Report using MetaLink.

Conclusion

This document shows Oracle's ongoing commitment to support its customers. Oracle's migration tools are being redeveloped to work within the easy to install, lightweight, extensible SQL Developer platform. Working within this framework provides an integrated solution for migration experts and provides extensibility and cross platform capability. SQL Developer works under Windows, Mac OS X and Linux.

Continue to use the Forums specified above for all your feedback.

THE FOLLOWING IS INTENDED TO OUTLINE OUR GENERAL PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATION PURPOSES ONLY, AND MAY NOT BE INCORPORATED INTO ANY CONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANY MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN MAKING PURCHASING DECISION. THE DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR FUNCTIONALITY DESCRIBED FOR ORACLE'S PRODUCTS REMAINS AT THE SOLE DISCRETION OF ORACLE.