Oracle Openworld Directory Index

Agenda
Why Migrate?
Complete Migration Process
Database Architecture
RDBMS Similarites
Migration Issues
Oracle’s Migration Strategy

Oracle Migration Workbench
Supported Databases
New Features

Capture/Create
Customize
Migrate

Referencable Clients
Oracle9iAS Migration Kit for ASP
Migrate Microsoft IIS/ASP applications to J2EE and the Oracle9i Platform
Migrate from IIS (4.0, 5.0) and Windows (NT and 2000)
Migrate to Oracle9iAS 1.0.2.2 or higher
Why Migrate?
Performance, Scalability, Reliability
Moving to J2EE
“It's easy to use, which makes it particularly attractive for those who want to break into e-commerce on a shoestring, and particularly attractive as well for those who just want to break in.” - The Register (Hacking IIS -- how sweet it is)
Gartner recommends migration from IIS
Migration Strategy
Version 1.0 - Embrace
Deploy IIS/ASP applications to the Oracle9i Platform
Version 2.0 - Improve
Improve Microsoft Technology support
Improve Oracle Technology support
Version 3.0 - Replace
ASP to JSP





Fill Out a Survey and Get a Chance to Win a Compaq iPAQ!

We want to know what you think!

Fill out the survey that was handed out at the beginning of the session for a chance to win a Compaq iPAQ. Remember to include your name and email in the available section and we will enter your name into two daily drawings to win an iPAQ
Reference Material
Online Help
Oracle Technology Network
http://otn.oracle.com/tech/migration
Reference Guides and FAQ
Quick Tour and Online Demo
Discussions Forums
Migration Workbench Helpdesk
infomwb_ww@oracle.com
Summary
Oracle9i is the No. 1 platform for the enterprise
Oracle provides a complete migration solution
Tools
Methodology
Services


________

Gartner now has a big three database market
Oracle, Microsoft and IBM
Corporate Direction – Database Consolidation
IBM / Informix
Separate Servers (5) - Separate Features
Reliability / Scalability / Performance
Sybase
Customer confidence dwindling
Separate Servers - Separate Features
Reliability / Scalability / Performance
Security / Manageability / Platform Independence



Project Based Migrations
Complete Business Project
Rigorous Project Methodology
Planning/Analysis
Execution/Migration
Both Application & Data
Testing/Evaluation
Implementation

Similar Schema Objects (tables, views)
Similar Data types
Referential Integrity
Check Constraints / Rules
Transaction Support
Triggers and Stored Sub Programs
SQL Access to System Catalogs

Data Access
SQL Syntax Differences
Some application code may need changes e.g., ESQL/C
Application/Sub Program Issues
Temporary Tables
Transaction Handling and Control
SPL Issues
Resultsets from Stored Sub Programs
Dynamic SPL
Error Handling
SQL Issues
DDL/DML


Provide cost effective migration solutions to the Oracle platform
Migrate entire application(s) & database(s)
Minimize migration effort by using proven tools & methodology
Tune applications for optimum performance
Provide enhanced functionality to applications using the Oracle platform

Intuitive user interface, supported by migration wizards
Supports complete database migration
Schema & Data
Triggers & Stored Procedures
Embedded SQL
Informix ESQL/C -> Oracle Pro*C
Ability to customize data types
Customization supported prior to generation
Capture / Create / Migrate


OMWB Plugin Version(s)
Informix Dynamic Server 7.3
Microsoft Access 2.0,95,97,2000
Microsoft SQL Server 6.5, 7.0, 2000
Sybase Adaptive Server 11, 12
MySQL 3.22, 3.23
DB2/400 (Beta) V4R3


Informix ESQL/C support
Weak Ref Cursor Support
Parser Intelligence
Disconnected Source Model Load
Oracle9i Support

Load the Source Model
ODBC/JDBC driver used to extract schema information
Schema information loaded into the Workbench Repository
No data transferred
Create the Oracle Model
Data type mappings
Parser

Source Model customization
Modify data type mappings
Delete objects
Edit text (stored procedures, triggers & views)
Edit parse options
Oracle Model customization
Delete/rename objects
Edit creation options
Tablespaces
Users
Tables and indexes
Edit text (stored procedures, triggers & views)

Creation of the users and their tables
Data migration
Through the Migration Workbench
JDBC/ODBC
Offline data loading
UNLOAD/SQL*Loader
Creation of remaining schema objects

“The quick conversion of the database gave us a tremendous head start in setting up a test database and making our programmers effective in a very short time frame.”


Migrate Microsoft IIS/ASP applications to J2EE and the Oracle9i Platform
Migrate from IIS (4.0, 5.0) and Windows (NT and 2000)
Migrate to Oracle9iAS 1.0.2.2 or higher

Performance, Scalability, Reliability
Moving to J2EE
“It's easy to use, which makes it particularly attractive for those who want to break into e-commerce on a shoestring, and particularly attractive as well for those who just want to break in.” - The Register (Hacking IIS -- how sweet it is)
Gartner recommends migration from IIS

Version 1.0 - Embrace
Deploy IIS/ASP applications to the Oracle9i Platform
Version 2.0 - Improve
Improve Microsoft Technology support
Improve Oracle Technology support
Version 3.0 - Replace
ASP to JSP