Preface

This guide describes how to use Oracle Migration Workbench Release 10.1.0 for Microsoft Windows 98/2000/NT/XP and Linux x86 to migrate a third-party database to an Oracle database. It also provides information about the migration process.

Intended Audience

This manual is intended for application developers that want to migrate a third-party database to an Oracle database.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

Accessibility of Code Examples in Documentation JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Structure

This manual contains the following chapters:

Chapter 1, "Introduction"

This chapter describes how Oracle Migration Workbench (Migration Workbench) works to migrate a third-party database to an Oracle database.

Chapter 2, "Preparing a Migration Plan"

This chapter describes the process of how to create a migration project plan.

Chapter 3, "Before You Migrate"

This chapter describes the tasks that you must perform before using Migration Workbench to migrate a third-party database to an Oracle database.

Chapter 4, "Capturing a Source Database"

This chapter describes how to capture the source database.

Chapter 5, "Creating and Customizing the Oracle Model"

This chapter describes how to create and customize the Oracle Model.

Chapter 6, "Migrating the Database"

This chapter describes how to migrate third-party databases to an Oracle database.

Chapter 7, "Testing the Oracle Database"

This chapter describes how to test the migrated database and the application, including verifying that all of the data was migrated and validating that the migrated data is correct.

Chapter 8, "Deploying the Oracle Database"

This chapter describes how to deploy the migrated and tested Oracle database.

Chapter 9, "Using Reports"

This chapter describes how to use the reports available to you through Migration Workbench.

Chapter 10, "Troubleshooting"

This chapter contains problems, causes, and solutions to help you resolve migration issues.

Appendix A, "Parser Reference Information"

This appendix lists the parser error messages for Microsoft SQL Server and Sybase Adaptive Server.

Glossary

The glossary defines terms used in this manual.

Terminology

The following operating systems have been shortened in this guide to Windows, where appropriate:

Microsoft Windows 98
Microsoft Windows NT 4.0
Microsoft Windows 2000
Microsoft Windows XP

The name for the UNIX operating system, Red Hat Enterprise Linux - version 3, has been shortened in this guide to Linux x86, where appropriate.

Conventions

This section describes the conventions used in the text and code examples of this manual. It describes:

Conventions in Text
Conventions in Code Examples

Conventions in Text

The following typographic conventions are used in this manual:

Convention	Meaning
monospace	Monospace type indicates commands, directory names, user names, path names, and file names.
italic	Italic type indicates a variable, including variable portions of file names. It is also used for emphasis and for book titles.
UPPERCASE	Uppercase letters indicate Structured Query Language (SQL) reserved words, initialization parameters, and environment variables.

Conventions in Code Examples

All examples that show commands or file contents appear in monospace font. The following conventions are used in command syntax:

Convention	Meaning
braces {}	Braces indicate required items: .DEFINE {macro1}
brackets []	Brackets indicate optional items: cvtcrt `termname` [`outfile`]
ellipses ...	Ellipses indicate an arbitrary number of similar items: CHKVAL fieldname `value1` `value2` ... `valueN`
italics	Italic type indicates a variable. Substitute a value for the variable: `library_name`
vertical line \|	A vertical line indicates a choice within braces or brackets: SIZE `filesize` [K\|M]
. . .	Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted
boldface text	Boldface type in text indicates a term defined in the text, the glossary, or in both locations.
< >	Angle brackets enclose user-supplied names.
[ ]	Brackets enclose optional clauses from which you can choose one or none.

Code Example Variables in This Manual

The following table describes variables that are used throughout this manual. Other variables are described where they occur.

Variable	Description
`ORACLE_HOME`	The Oracle home directory specified by the %ORACLE_HOME% environment variable on Windows or the $ORACLE_HOME environment variable on UNIX.
`OMWB_install_dir`	The absolute directory where you installed Migration Workbench.

Online Documentation Requirements

To view the online documentation included with Migration Workbench, use a Web browser, such as Netscape Navigator 4.0 or higher. To view PDF documents, use Adobe Acrobat Reader version 4.0 or higher. You can download Adobe Acrobat Reader at:

http://www.adobe.com/products/acrobat/readstep.html

Online Support

Before you contact Oracle Support Services, consult the Migration Workbench documentation listed in "Related Documents". If you cannot locate the answer to your questions in the documentation, see the following sections for information about other forms of support.

Obtaining Technical Support

There are separate methods to log technical assistance requests with Oracle Support depending on whether you have a support contract with Oracle.

If you have a current support contract, log technical assistance requests with Oracle Support through OracleMetaLink:

For more information about OracleMetaLink, see "OracleMetaLink".
If you do not have a current support contract, log technical assistance requests with Oracle Support, as follows:
1. Follow the debugging procedure at:
```
http://www.oracle.com/technology/support/tech/migration/workbench/index.html
```
2. Log a Technical Assistance Request (TAR) by sending an e-mail to the support help desk at: infomwb_ww@oracle.com.

In either case, provide the support contact with the following information:

Your contact name, organization, contact number (including international dialing code), and address.
Describe the issue.
Describe what you were doing when the problem occurred.
List the operations that you were performing. Is the problem reproducible? What are the steps you took to locate the problem?
Describe your environment.
Provide the version of Migration Workbench that you are using.
Provide the error messages and numbers that you received.
The third-party database and version that you are migrating.

OracleMetaLink

In addition to the manuals and online help, Oracle offers OracleMetaLink, an electronic support service available to Oracle customers with active support service contracts, 24 hours a day, seven days a week.

OracleMetaLink provides access to information, such as white papers and product reference information, that aids you in using Oracle products. Templates are provided to help you prepare information about your problem before you call.

Customers can register with OracleMetaLink at:

http://www.oracle.com/support/metalink/index.html

OTN Discussion Forums

You can also obtain support through OTN discussion forums. You must register with OTN to view the Oracle discussion forums. To view current discussion topics or post a message about Migration Workbench:

Use a browser to view the following URL:

http://forums.oracle.com/forums/forum.jsp?forum=1

If prompted, enter the OTN user name and password, then click Login.

The Oracle Technology Network Migration Workbench page appears.
Click the Options icon located in the upper-right corner of the page to subscribe to an individual forum.

The Subscriptions page appears, containing a list of Oracle discussion forums.
In the Technologies section, locate Migration Workbench, then click Subscribe.
Click Save.
Click Migration Workbench to view the forum listing for the product.