Skip Headers
Oracle® Migration Workbench User's Guide
Release 10.1.0 for Microsoft Windows 98/2000/NT/XP and Linux x86
Part No. B15857-01
  Go To Index
Index

Next
Next
 

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience
Documentation Accessibility
Structure
Related Documents
Terminology
Conventions
Online Documentation Requirements
Online Support

1 Introduction

Overview
How Migration Workbench Works
Migration Workbench
Plug-in
Workbench Repository
Using Migration Workbench in the Migration Process
Capturing the Source Database
Accessing the Destination Database
Creating and Customizing the Oracle Model
Migrating from the Source Database to the Oracle Database
Benefits of Migration Workbench
Supported Third-party Databases

2 Preparing a Migration Plan

Task 1: Determining the Requirements of the Migration Project
Task 2: Estimating Workload Using Migration Workbench
Task 3: Analyzing Operational Requirements
Task 4: Analyzing the Application
Task 5: Planning the Migration Project

3 Before You Migrate

Configuring Migration Workbench
Creating a Database User for the Workbench Repository
Configuring the Plug-in
Before Migrating From Microsoft SQL Server
Before Migrating From Sybase Adaptive Server
Configuring Sybase Adaptive Server on Windows
Configuring Sybase Adaptive Server on Linux x86
Before Migrating From Microsoft Access
Creating Microsoft Access XML Files
Before Migrating From Informix Dynamic Server
Before Migrating From MySQL
Before Migrating From IBM DB2/400
Before Migrating From IBM DB2 UDB
Determining Connection Information for an Oracle Database

4 Capturing a Source Database

Overview
Starting Migration Workbench on Windows
Starting Migration Workbench on Linux x86
Creating Offline Capture Files
Creating Microsoft SQL Server or Sybase Adaptive Server Offline Capture Files
Creating Informix Dynamic Server Offline Capture Files
Using the Capture Wizard
Capturing Informix ESQL/C Source Files
Customizing the Source Model
Customizing Data Type Mappings

5 Creating and Customizing the Oracle Model

Overview
Creating the Oracle Model
Correcting Errors in the Oracle Model
Customizing the Oracle Model
Modifying the Properties of a Schema Object
Working with Tablespaces
Creating a Tablespace
Renaming a Tablespace
Using Existing Tablespaces
Changing the Default User Password

6 Migrating the Database

Overview
Using the Migration Wizard
Creating the Schema Online
Creating the Schema Offline
Transferring the Data Online
Transferring the Data Offline
Generating Data Unload Scripts and SQL*Loader Control Files
Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
Creating Data Files From Microsoft Access
Creating Data Files From Informix Dynamic Server
Creating Data Files From MySQL
Creating Data Files From IBM DB2/400
Creating Data Files From IBM DB2 UDB
Populating the Destination Database Using the Data Files
Migrating Informix ESQL/C Source Files

7 Testing the Oracle Database

Overview
Testing Methodology
Testing the Oracle Database
Guidelines for Creating Tests
Example of a Unit Test Case

8 Deploying the Oracle Database

Rollout Strategies
Phased Approach
Big Bang Approach
Parallel Approach
Deploying the Destination Database

9 Using Reports

Overview
Generating Reports
Viewing and Using Reports
Viewing the Database Summary Report
Using the Database Summary Report
Viewing the Database Detailed Report
Using the Database Detailed Report
Viewing the Database Errors and Warnings Report
Using the Database Errors and Warnings Report
Accessing the Log Window and Log File

10 Troubleshooting

Troubleshooting the Workbench Repository
Connecting to a Workbench Repository
Re-creating a Corrupt Default Repository
Re-creating a Corrupt Repository for an Oracle Database
Troubleshooting Microsoft Access
Removing Microsoft Access Security
Erroneous Relations within Microsoft Access 95
Defining Primary Keys on a Table
Migrating Table Data Using Microsoft Access ODBC Data Source
Incorrect Boolean Values When Migrating Data
Error Messages for Microsoft Access
Troubleshooting Microsoft SQL Server and Sybase Adaptive Server
Stored Procedure Collections
Schema Objects Without Owners
Offline Capture Script Characters
Migrating Table Data and Column Defaults Containing Empty Strings
Error Messages
General Error Messages
Microsoft Access
Microsoft SQL Server and Sybase Adaptive Server
MySQL

A Parser Reference Information

Parser Reference Information for Microsoft SQL Server and Sybase Adaptive Server

Glossary

Index