Index

A B C D E F G I L M N O P R S T U V W X

A

accessing

destination database, 1.3.2

log window and file, 9.4

advantages

of migrating, 1.4

ALTER TABLE

parser error messages, A.1

altering tablespaces

see renaming tablespaces

analyzing

applications, 2.4

operational requirements, 2.3

applications

analyzing, 2.4

architecture

of Migration Workbench, 1.2

B

before migrating

configuring, 3.2

IBM DB2 UDB, 3.2.7

IBM DB2/400, 3.2.6

Informix Dynamic Server, 3.2.4

Microsoft Access, 3.2.3

Microsoft SQL Server, 3.2.1

MySQL, 3.2.5

Sybase Adaptive Server, 3.2.2

BEGIN TRAN

parser error messages, A.1

benefits

of migrating, 1.4

big bang approach

to deploying, 8.1.2

C

Capture wizard

using, 4.5

capturing, 4

Capture wizard, 4.5

Informix Dynamic Server, 4.4.2

Informix ESQL/C, 4.6

Microsoft Access, 3.2.3.1

Microsoft SQL Server, 4.4.1

offline, 4.1

offline capture files, 4.4

online, 4.1

overview, 4.1

source database, 1.3.1

Sybase Adaptive Server, 4.4.1

Case..End

parser error messages, A.1

choosing

plug-ins, 4.2, 4.3

Workbench repository, 4.2, 4.3

column defaults

containing empty string data, 10.3.4

components

of Migration Workbench, 1.2

configuring, 3.2.1

IBM DB2 UDB, 3.2.7

IBM DB2/400, 3.2.6

Informix Dynamic Server, 3.2.4

Microsoft Access, 3.2.3

Microsoft SQL Server, 3.2.1

Migration Workbench, 3.1

MySQL, 3.2.5

Sybase Adaptive Server, 3.2.2

third-party databases, 3.2

connecting

to Oracle, 3.3

connection information

for Oracle database, 3.3

CREATE INDEX

parser error messages, A.1

CREATE TABLE

parser error messages, A.1

CREATE VIEW

parser error messages, A.1

creating

database user, 3.1.1

offline capture files, 4.4.1

online schema, 6.1

Oracle Model, 5

schema offline, 6.1, 6.4

schema online, 6.1, 6.3

Source Model, 4

tablespaces using Migration Workbench, 5.4.2.1

tablespaces using Oracle Enterprise Manager, 5.4.2.1

creating data files

IBM DB2 UDB, 6.6.7

IBM DB2/400, 6.6.6

Informix Dynamic Server, 6.6.4

Microsoft Access, 6.6.3

Microsoft SQL Server, 6.6.2

MySQL, 6.6.5

Sybase Adaptive Server, 6.6.2

creating tablespaces, 5.4.2.1

CURSOR ..NAME

parser error messages, A.1

customizing

data type mappings, 4.8

D

data files

creating for IBM DB2 UDB, 6.6.7

creating for IBM DB2/400, 6.6.6

creating for Informix Dynamic Server, 6.6.4

creating for Microsoft Access, 6.6.3

creating for Microsoft SQL Server, 6.6.2

creating for MySQL, 6.6.5

creating for Sybase Adaptive Server, 6.6.2

Data Type Mappings

customizing, 4.8

databases

connection information, 3.3

creating users, 3.1.1

deploying, 8.2

deployment strategies, 8.1

supported, 1.5

delimiter characters

default settings, 10.3.3

editing, 10.3.3

deploying

big bang approach, 8.1.2

Oracle database, 8.2

parallel approach, 8.1.3

phased approach, 8.1.1

destination database

accessing, 1.3.2

destination databases

deploying, 8.2

Detailed reports

using, 9.3.4

viewing, 9.3.3

determining project requirements, 2.1

documentation

introduction to, 1.1

DROP PROCEDURE

parser error messages, A.1

DROP TABLE

parser error messages, A.1

DROP VIEW

parser error messages, A.1

E

empty string data, 10.3.4

Error and Warnings reports

using, 9.3.6

viewing, 9.3.5

error messages

parser reference, A.1

errors

parse exceptions, 5.3

estimating

migration project, 2.5

workload, 2.2

F

features

Migration Workbench, 1.4

of migrating, 1.4

FETCH

parser error messages, A.1

files

accessing, 9.4

creating IBM DB2 UDB data files, 6.6.7

creating IBM DB2/400 data files, 6.6.6

creating Informix Dynamic Server data files, 6.6.4

creating Microsoft Access data files, 6.6.3

creating Microsoft SQL Server data files, 6.6.2

creating MySQL data files, 6.6.5

creating Sybase Adaptive Server data files, 6.6.2

offline capture, 4.4

XML, 4.5

forms

Microsoft Access, 6.2

FULL OUTER JOIN

parser error messages, A.1

G

generating

migration scripts, 6.4

reports, 9.2

SQL*Loader scripts, 6.6.1

global variables

parser error messages, A.1

GRANT

parser error messages, A.1

graphical user interface, 1.2.1

I

IBM DB2 UDB

configuring, 3.2.7

creating data files, 6.6.7

IBM DB2/400

configuring, 3.2.6

creating data files, 6.6.6

identifying

application requirements, 2.4

migration plan, 2.5

Informix Dynamic Server

capturing, 4.4.2

configuring, 3.2.4

creating data files, 6.6.4

Informix ESQL/C, 4.6

migrating source files, 6.7

INSENSITIVE CURSOR

parser error messages, A.1

installable component

Migration Workbench, 1.2.1

plug-in, 1.2.2

installing

Microsoft SQL Server ODBC driver, 3.2.1

introduction

migrating, 6.1

of guide, 1.1

Oracle Model, 5.1

reports, 9.1

L

LEFT JOIN

parser error messages, A.1

LIKE .. INNER

parser error messages, A.1

M

mapping, 5.1

Microsoft Access

capturing, 3.2.3.1

configuring, 3.2.3, 3.2.3

creating data files, 6.6.3

turning off security, 3.2.3

using original forms and reports, 6.2

Microsoft SQL Server, 3.2.1

capturing, 4.4.1

creating data files, 6.6.2

migrating, 6

benefits of, 1.4

overview, 6.1

process of using Migration Workbench, 1.3

recommendations, 6.1

required roles and privileges, 1.3.2

migration process

capturing, 1.3.1

migration project

determining requirements, 2.1

planning, 2.5

migration scripts

generating, 6.4

Migration wizard

using, 6.2

Migration Workbench

creating tablespaces, 5.4.2.1

starting, 4.2, 4.3

MySQL

configuring, 3.2.5

creating data files, 6.6.5

N

NAME

parsing error messages, A.1

parser error messages, A.1

O

ODBC driver

installing for SQL Server, 3.2.1

offline capture

overview, 4.1

offline capture files, 4.4

creating for Microsoft SQL Server or Sybase Adaptive Server, 4.4.1

default delimiter characters, 10.3.3

offline data transfer, 6.1, 6.1, 6.6

offline schema creation, 6.1

omwb_emulation schema, 1.3.4

online capture

overview, 4.1

online data transfer, 6.1, 6.5

online schema creation, 6.1, 6.1, 6.3

operational

requirements, 2.3

Oracle database

deploying, 8.2

Workbench repository, 4.2

Oracle Enterprise Manager, 5.4.2.1

Oracle Model

creating, 5

overview, 5.1

schema objects, 5.4.1

Oracle ODBC data source

setting, 3.2.1

ORDER BY

parser error messages, A.1

orphaned schema objects

setting owners, 10.3.2

OUTER RIGHT LEFT JOIN

parser error messages, A.1

overview

migrating, 6.1

of guide, 1.1

Oracle Model, 5.1

reports, 9.1

P

parallel approach

to deploying, 8.1.3

parse exception errors, 5.3

parser

ALTER TABLE errors, A.1

BEGIN TRAN errors, A.1

Case..End errors, A.1

CREATE INDEX errors, A.1

CREATE TABLE errors, A.1

CREATE VIEW errors, A.1

CURSOR .. NAME errors, A.1

DROP PROCEDURE errors, A.1

DROP TABLE errors, A.1

DROP VIEW errors, A.1

FETCH errors, A.1

FULL OUTER JOIN errors, A.1

global variable errors, A.1

GRANT errors, A.1

INSENSITIVE CURSOR errors, A.1

LEFT JOIN errors, A.1

LIKE .. INNER errors, A.1

LIKE errors, A.1

NAME errors, A.1

NN errors, A.1

ORDER BY errors, A.1

OUTER RIGHT LEFT JOIN errors, A.1

raiserror errors, A.1

RIGHT JOIN errors, A.1

SCROLL CURSOR errors, A.1

set errors, A.1

T-SQL syntax errors, A.1

UPDATE errors, A.1

WITH STRING errors, A.1

parser reference information

error messages, A.1

phased approach

to deploying, 8.1.1

planning

migration project, 2.5

plug-in

configuring, 3.2

plug-ins

choosing, 4.2, 4.3

preparing

migration project, 2.5

privileges

required for migrating, 1.3.2

process

of migrating, 1.3

product features, 1.4

projects

creating plan, 2.3

requirements for, 2.1

R

raiserror

parser error messages, A.1

recommendations

for migrating, 6.1

relations, deleting within Microsoft Access, 10.2.2

removing Microsoft Access security, 10.2.1

renaming stored procedure collections, 10.3.1

renaming tablespaces, 5.4.2.2

replicating, 1.3.4

reports

generating, 9.2

Microsoft Access, 6.2

overview, 9.1

using Detailed, 9.3.4

using Error and Warnings reports, 9.3.6

using Summary report, 9.3.2

viewing and using, 9.3

viewing Detailed, 9.3.3

viewing Error and Warnings reports, 9.3.5

viewing summary, 9.3.1

repository, 4.2, 4.3

creating user, 3.1.1

database user, 4.2, 4.3

of Migration Workbench, 1.2.3

troubleshooting, 10.1

REPUSER

creating, 3.1.1

requirements

for applications, 2.4

operational, 2.3

to determine project, 2.1

RIGHT JOIN

parser error messages, A.1

roles

required for migrating, 1.3.2

rollout

strategy, 8.1

S

schema

omwb_emulation, 1.3.4

schema objects

Oracle Model, 5.4.1

Source Model, 4.7

without owners, 10.3.2

scripts

generating migration, 6.4

generating SQL*Loader, 6.6.1

SCROLL CURSOR

parser error messages, A.1

security

turning off, 3.2.3

security, removing Microsoft Access, 10.2.1

set

parser error messages, A.1

setting

Oracle ODBC data source, 3.2.1

source database, 4

about capturing, 1.3.1

source database system functions, 1.3.4

Source Model

customizing, 4.7

SQL Server

configuring, 3.2.1

SQL*Loader

generating scripts, 6.6.1

stages

of migration process, 1.3

starting

Migration Workbench, 4.2, 4.3

stored procedure collections

renaming, 10.3.1

strategies

for deploying, 8.1

Summary reports

using, 9.3.2

viewing, 9.3.1

support

for databases, 1.5

for technologies, 1.5

Sybase Adaptive Server

capturing, 4.4.1

configuring, 3.2.2

creating data files, 6.6.2

T

tables

containing empty string data, 10.3.4

tablespace

default setting, 5.4.2.1

tablespace discoverer, 5.4.2.3

tablespaces

about, 5.4.2

creating using Migration Workbench, 5.4.2.1

creating using Oracle Enterprise Manager, 5.4.2.1

renaming, 5.4.2.2

using tablespace discoverer, 5.4.2.3

technologies

supported, 1.5

third-party databases

configuring, 3.2

supported, 1.5

transferring

data offline, 6.1, 6.6

data online, 6.1, 6.5

offline data, 6.1

troubleshooting

Microsoft SQL Server, 10.3

modifying Microsoft Access, 10.2.6

repository, 10.1

Sybase Adaptive Server, 10.3

turning off security, 3.2.3

U

UPDATE

parser error messages, A.1

user interface, 1.2.1

using

Capture wizard, 4.5

Detailed report, 9.3.4

Error and Warnings reports, 9.3.6

existing tablespaces, 5.4.2.3

Migration wizard, 6.2

Migration Workbench, 1.3

Migration Workbench to estimate workload, 2.2

reports, 9.3

Summary report, 9.3.2

V

viewing

Detailed report, 9.3.3

Error and Warnings report, 9.3.5

log window and file, 9.4

reports, 9.3

W

warnings

using reports, 9.3.6

viewing reports, 9.3.5

window

accessing log, 9.4

WITH STRING

parser error messages, A.1

wizards

using Capture wizard, 4.5

using Migration wizard, 6.2

Workbench repository

about, 1.2.3

choosing, 4.2, 4.3

database user, 4.2, 4.3

default, 4.2

Oracle database, 4.2

workload

estimating, 2.2

X

XML file, 4.5