Contents

Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with Application Migrations Workshop

• About Migrating a Microsoft Access Application
  • Preparation Checklist for Migrating Microsoft Access Applications
  • Analyze Your MDB File in Microsoft Access
  • About the Microsoft Access Migration to Oracle Application Express Forum
• About Converting an Oracle Forms Application
  • Preparation Checklist for Converting Oracle Forms Applications
  • About the Oracle Application Express Forum

2 Overview of the Migration Process

• Why Migrate to Oracle Application Express?
• Before Starting the Conversion Process
• Evaluating Whether to Convert or Build an Application from Scratch
• Understanding What Oracle Application Express Application Conversion is Not
• Key Differences with Oracle Application Express
  • Stateless Web Applications
  • Evaluating User Interface Design
  • About Business Logic Replication
• Creating an Oracle Application Express Migration Project

3 Migrating a Microsoft Access Application

• How to Migrate a Microsoft Access Application
• Step 1: Export Microsoft Access Metadata
• Step 2: Migrate the Microsoft Access Database to Oracle
  • Verifying If Generated DDL Executes Against the Appropriate Instance
• Step 3: Create a Workspace and Add Oracle Application Express Users
  • Creating a Workspace Manually
  • Creating Oracle Application Express Users
  • Logging in to Your Oracle Application Express Workspace
• Step 4: Create a Migration Project
  • About the Project Page
• Step 5: Review Your Retrieved Objects
  • Reviewing Retrieved Tables
  • Reviewing Retrieved Queries
  • Reviewing Retrieved Forms
  • Reviewing Retrieved Reports
  • Reviewing Database, Module, and Pages Information
• Step 6: Generate the Oracle Application Express Application
• Deleting a Migration Project

4 Converting an Oracle Forms Application

• How to Convert Your Application
• Step 1: Convert Oracle Forms to XML
  • Converting FormModules, ObjectLibraries, or MenuModules to XML
  • Converting a PL/SQL Library
  • Converting an Oracle Report to XML
• Step 2: Create a Workspace and Add Oracle Application Express Users
  • Creating a Workspace Manually
  • Creating Oracle Application Express Users
  • Logging in to Your Oracle Application Express Workspace
• Step 3: Upload Database Objects into the Schema Associated with Your Workspace
• Step 4: Create a Conversion Project
• Step 5: Review and Edit Forms Metadata
  • About the Project Page
  • Editing Project Details
  • Reviewing Forms Modules
  • Reviewing Oracle Reports
  • Reviewing PL/SQL Libraries
  • Reviewing Forms Menus
  • Reviewing Object Libraries
  • Using Annotations to Track the Conversion Process
• Step 6: Generate the Oracle Application Express Application
  • Setting Up Application Defaults
  • Creating an Application
• Deleting a Migration Project

A Oracle Forms Generation Capabilities and Workarounds

• Oracle Forms Modules
  • Overview of Oracle Forms Components
  • About Generated Applications
  • Block to Page Region Mappings
  • List of Values Implementation
  • Implementing Business Logic
• Oracle Reports
• PL/SQL Libraries
• Forms Menus
• Object Libraries

Index