Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    OMWB

    Uploaded by

    gbevolo
    The document discusses migrating data from a Microsoft Access database to an Oracle database using Oracle's Migration Workbench tool. It outlines how to install the Migration Workbench and the Access plugin, and how to set up a repository to store metadata about the migration. The document then walks through using the Migration Wizard to migrate table structure, data, and constraints from an Access database to Oracle, while retaining the ability to use the existing Access forms and reports through ODBC connectivity to Oracle.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    OMWB

    Uploaded by

    gbevolo
    36 views23 pages
    The document discusses migrating data from a Microsoft Access database to an Oracle database using Oracle's Migration Workbench tool. It outlines how to install the Migration Workbench and the Access plugin, and how to set up a repository to store metadata about the migration. The document then walks through using the Migration Wizard to migrate table structure, data, and constraints from an Access database to Oracle, while retaining the ability to use the existing Access forms and reports through ODBC connectivity to Oracle.

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses migrating data from a Microsoft Access database to an Oracle database using Oracle's Migration Workbench tool. It outlines how to install the Migration Workbench and the Access plugin, and how to set up a repository to store metadata about the migration. The document then walks through using the Migration Wizard to migrate table structure, data, and constraints from an Access database to Oracle, while retaining the ability to use the existing Access forms and reports through ODBC connectivity to Oracle.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    36 views23 pages

    OMWB

    Uploaded by

    gbevolo
    The document discusses migrating data from a Microsoft Access database to an Oracle database using Oracle's Migration Workbench tool. It outlines how to install the Migration Workbench and the Access plugin, and how to set up a repository to store metadata about the migration. The document then walks through using the Migration Wizard to migrate table structure, data, and constraints from an Access database to Oracle, while retaining the ability to use the existing Access forms and reports through ODBC connectivity to Oracle.

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 23

    Outgrown Access?

    Migrate to Oracle with Oracle


    Migration Workbench

    IOUG Live 2003 Paper #541

    Don Miller
    WTA Consulting
    Manager, Application Integration Practice
    [email protected]
    419-290-6141
    Objectives

     Attendees will learn how to install the Oracle


    Migration Workbench along with the
    installation of the access option
     Attendees will learn the advantages of the
    migration wizard
     Attendees will learn how to migrate an
    Access database with forms to an Oracle
    database. ODBC drivers will allow to use the
    Access forms on an Oracle database
    OMWB Overview

     Tool that simplifies the process of migrating


    data from non-Oracle databases
     This presentation focuses on Microsoft
    Access 2000 (very similar to 97)
     There are plug-ins for various databases
    – Informix Dynamic Server 7.3
    – Microsoft Access 95, 97, 2000
    – Microsoft SQL Server 6.5, 7.0, 2000
    OMWB Installation

     OMWB needs to be
    installed into an
    Oracle 9i home
     Plug-in Installation
     Repository Storage
    Install the Plug-in
    Microsoft Access Plug-in
    Feature Support Access
    Tables Y
    Views N (Queries)
    Indexes Y
    Groups/Roles N/A
    Users N
    Constraints Y (validation rules)
    Privileges N
    User-defined Types N/A
    Stored Procedures N/A
    Triggers N/A
    Embedded SQL N/A
    Relations, Link tables,
    Other features
    application code reuse.
    Repository Storage

     Set of tables to store migration data


     Enables user to work independently from
    production database
     Source Model
    – Contains a mirror image of the data dictionary of
    the source database
     Oracle Model
    – Created from information in the source model
    Creating the Repository

     Default Repository
    – Oracle 9i Lite (ships with product)
     Oracle 8i/9i Repository
    – Connect to database on network using
    JDBC driver
    – Must have a user already created with
    the CONNECT, RESOURCE roles granted
    Login Repository Screen
    Starting OMWB

     If your plug-in was


    successfully
    installed, you
    should receive the
    following box when
    starting OWMB
     You will see an
    entry for each
    plug-in installed
    OMWB Migration Wizard
    Create XML File from MDB File
     Open
    – ORACLE_HOME\OMWB\OMWB2000.mde
    – MDE file is a compiled MDB file that
    cannot be viewable or edited
    OMWB Install: Select Database
    Data Type Definitions

     Oracle Type
    – Possible Oracle types created from the source
    database
     Oracle Length
    – Digits or characters that are permitted for
    alphanumeric types
     Oracle Precision
    – Digits that are permitted for numeric types
     Oracle Scale
    – Digits to the right of the decimal that are
    permitted
    Data Type Illustration
    Oracle Model Illustration
    Migrate to Oracle
    Migration Connection

     Must enter a
    user with
    DBA privs
    Migrate Table Data
    Schema Objects to Migrate
    Access Forms and Reports

     Setup ODBC link on Access file


    – Make sure to use Oracle’s ODBC driver
     Link Access file to Oracle
    Data Migration

     Migrating a single table?


     Creation of users and their tables
     What happens to my constraints
     What errors might occur and how to
    handle them
    A Real Life Experience

     Access file too large


     Decision to migrate to Oracle
     No budget to replace forms and
    reports
     Solution to migrate data to Oracle and
    retain Access forms and reports

    You might also like