Oracle Migration Workbench for MS Access Reference Guide Release 1.2.5.0.0 for Windows Z26073-02 |
|
The Oracle Migration Workbench for MS Access Reference Guide provides detailed information about migrating a database from MS Access 2.0, MS Access 95, or MS Access 97 to Oracle8 or Oracle8i. This reference guide describes several differences between MS Access and Oracle, and outlines how those differences are dealt with by Oracle Migration Workbench (Migration Workbench) during the conversion process.
This reference guide is intended for anyone who is involved in converting an MS Access database to Oracle using the Migration Workbench.
You should be familiar with relational database concepts and with the operating system environments under which you are running MS Access and Oracle.
This reference guide is organized as follows:
Introduces the Migration Workbench and outlines features of this tool.
Chapter 2, "The Migration Process"
Outlines the architecture of MS Access and Oracle, explains how to prepare your MS Access database for migration, and describes how to migrate from MS Access to Oracle using the Migration Workbench.
Chapter 3, "Data Types, Reserved Words, and Functions"
Illustrates the migration of data types and built-in functions from MS Access to Oracle and provides a list of Oracle8i reserved words.
Provides tips on how to migrate hyperlinks and how to perform a manual migration if necessary
Chapter 5, "Performance Tuning"
Outlines some measures that can be taken to tune your database.
Appendix A, "MS Access Error Messages"
Provides a list of Microsoft Jet database engine errors.
Appendix B, "Code and Query Samples"
Uses code examples to illustrate the migration process.
Every reader of this reference guide should read Chapter 1, "Overview". That chapter provides an introduction to the concept and terminology of the Migration Workbench.
The following typographic conventions are used in this reference guide:
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|