Migrating to the Cloud

Migrating to the Cloud

Oracle Client/Server Modernization

1st Edition - October 3, 2011

Write a review

  • Authors: Tom Laszewski, Prakash Nauduri
  • eBook ISBN: 9781597496483
  • Paperback ISBN: 9781597496476

Purchase options

Purchase options
DRM-free (Mobi, EPub, PDF)
Sales tax will be calculated at check-out

Institutional Subscription

Free Global Shipping
No minimum order


Migrating to the Cloud: Oracle Client/Server Modernization is a reference guide for migrating client/server applications to the Oracle cloud. Organized into 14 chapters, the book offers tips on planning, determining effort and budget, designing the Oracle cloud infrastructure, implementing the migration, and moving the Oracle cloud environment into production. Aside from Oracle application and database cloud offerings, the book looks at various tools and technologies that can facilitate migration to the cloud. It includes useful code snippets and step-by-step instructions in database migration, along with four case studies that highlight service enablement of DOS-based applications, Sybase to Oracle, PowerBuilder to APEX, and Forms to Java EE. Finally, it considers current challenges and future trends in cloud computing and client/server migration. This book will be useful to IT professionals, such as developers, architects, database administrators, IT project managers, and executives, in developing migration strategies and best practices, as well as finding appropriate solutions.

Key Features

  • Focuses on Oracle architecture, Middleware and COTS business applications
  • Explains the tools and technologies necessary for your legacy migration
  • Gives useful information about various strategies, migration methodologies and efficient plans for executing migration projects


Primary: IT managers; database administrators; database developers; database architects

Secondary: project managers; data center managers; organizational application developers; programmers

Table of Contents

  • About the Authors

    About the Technical Editor


    Chapter 1 Migrating to the Cloud: Client/Server Migrations to the Oracle Cloud

        What Is Cloud Computing?

             Cloud Computing Service Models

             Cloud Computing Deployment Models

        The Oracle Cloud

        Legacy Client/Server Databases and Applications

        Why Migrate?

             Why Oracle?

             Migration Strategies



    Chapter 2 Identifying the Level of Effort and Cost

        Complexity of Database and Application SQL Migration Defined

        Overall Estimating and Scoping Approach


             First-Pass Migration with Oracle SQL Developer

             On-site Visit or Web Conference(s)

             Migration Workshop

             Scope Deliverables

        Analysis and Design

        Database Migration

             Schema and Data

             Stored Procedures



        Application Migration

             SQL Only

             Language Migration

             Language Migration: Sybase and SQL Server C/C++ APIs

             Service Enablement

        Integration Architecture

        Infrastructure Products, Utilities, and Tools

             Application Server Migration to Oracle WebLogic

        Hardware and Software

             Exadata and Exalogic: Database and Middleware Hardware and Software

             Oracle Virtualization and Oracle Enterprise Linux: Database and Middleware Hardware and Software

             Operating System Migration

        System, Customer Acceptance, and Performance Testing

        Moving to Production

        Other Things to Consider

        Project Management and Enterprise Architect

        Migration Effort Examples

             SQL Server Visual Basic Migration Estimate

             Sybase C++, PowerBuilder, Java, and Business Object Migration Estimate

             DB2 PowerBuilder and Java Migration Estimate



    Chapter 3 Methodology and Design

        Migration Options

        Methodology and Design


             Analysis and Design





             Post-Production Support

        Migration Services


    Chapter 4 Relational Migration Tools

        Initial Database Migration

             Database API and Protocol Options

             SQL Loader and External Tables

             Oracle SQL Developer Migration Workbench Database Migration

             Oracle Gateways

             Oracle ETL and ELT Tools

             Oracle Tuxedo Workbench for DB2 z/OS

             Oracle GoldenGate

             Third-Party Tools

             Reducing Data Migration Time and Disk Requirements

             Matrix of Oracle and Third-Party Database Migration Tools

        Initial Stored Object Migration

             Matrix of Oracle and Third-Party Stored Object Migration Tools

        Application SQL Migration

             Oracle SQL Developer Migration Workbench Application Migration



        Unit Testing

        Performance Testing

        System Testing

        Production Rollout

             Oracle GoldenGate

             Oracle CDC

             ODI CDC Knowledge Modules

             Matrix of Production Rollout Tools

        Global and Niche Service Providers



    Chapter 5 Database Schema and Data Migration

        Database Migration Tools from Oracle

        Database Schema Migration Tasks

        Data Migration

             Data Extraction

             Data Staging and Transfer

             Data Loading

             Data Loading Using Oracle SQL*Loader

             Data Loading Using the External Table Feature

             Data Loading Using SQL Developer

             Data Migration Using ETL Tools Such as ODI

        Data Validation

        Sample Sybase Database Migration to Oracle Using Oracle SQL Developer

             Prerequisites for Schema Migration Using SQL Developer

             Database Schema Migration


    Chapter 6 Database Stored Object Migration

        SQL Developer Environment for Sample Migrations

             Translation Scratch Editor

        Stored Procedure Migrations

             Oracle Differences

             Top Challenges and Solutions

             Example Sybase Stored Procedure Migration


             Oracle Differences

             Top Challenges and Solutions

             Example SQL Server Trigger Migration


             Oracle Differences and Top Challenges and Solutions

             Example SQL Server View Migration

        Unit Testing

             Setting Up the Unit Testing Environment and Creating the Unit Test

             Unit Test of Oracle Stored Procedure

             Unit Test of Sybase and SQL Server Stored Procedures


    Chapter 7 Application Migration/Porting Due to Database Migration

        Types of Application Changes

        Factors Influencing Application Changes

        Migration Options and Solutions

             Manually Identifying Changes and Modifying Applications

             Migrating Applications Using Scripts and Tools

             Emulation Technology-based Solutions

        Application Migration Tasks

             Database Connectivity Changes

             Embedded SQL Changes

             Application Code Changes

             Database API Changes

             Changes to External Interfaces and Replication Solutions

             Error Handling

             Performance Optimization

             Application Build Process Changes


    Chapter 8 Migrating Applications to the Cloud

        Application Migration Options

             Emulation/Web Service Enablement


             Automated Migration


             Moving to Noncoding Fusion Products


        Portfolio Rationalization

        Application Analysis

        3GL Applications

         4GL Applications

        Target Languages and Environments

             Java and Java EE

             Java EE Frameworks

             Oracle Application Development Framework (ADF)

             Oracle Application Express (APEX)

             Oracle Fusion Product Solutions

        Application-Supporting Tools and Custom Scripts

        Applications in the Cloud

             Target Hardware and Software Stack Options

             Building Your Own Nonvirtualized Cloud

             Building Your Own Virtualized Cloud Platform

             Oracle Virtualized Red Stack

             “Cloud in a Box”: Exalogic

             Pros and Cons of Each Hardware and Software Stack Option

        Hosting Options



    Chapter 9 Service Enablement of Client/Server Applications

        The Unique Client/Server Dilemma

             Replacing Client/Server Systems with a Cloud-based Application

             Restructuring Client/Server Code

             Reusing Client/Server Applications Using SOA

        LegaSuite: Platform for SOA-Enabling Windows Client/Server Applications

        Step by Step for Creating an SOA Interface from a Legacy Windows Client/Server Application

             Development Process

        LegaSuite Runtime Considerations

             Sizing for Performance and Scalability

             Load Balancing

             Infrastructure Changes

             Including Client/Server Application Logic with Oracle Middleware

        From Windows Client/Server Applications to SOA in the Real World

             Case Study In-Depth: Social Interest Solutions Modernizes Public Assistance Enrollment Process with LegaSuite



    Chapter 10 Oracle Database Cloud Infrastructure Planning and Implementation

        Oracle Database Cloud Implementation Considerations

             Server Consolidation and Virtualization (IaaS and PaaS)

             Workload Consolidation and Database Migrations to Oracle (PaaS or DBaaS)

             Database Considerations for Multitenant Applications (Software as a Service or SaaS)

        Infrastructure Planning for Database Migrations to Oracle (DBaaS)

             Platform Considerations

             Platform Sizing

             Exadata System Sizing

             Backup and Recovery and Disaster Recovery Strategy

             Monitoring and Management of the Oracle Database Cloud


    Chapter 11 Sybase Migrations from a Systems Integrator Perspective, and Case Study

        Why Consider Database Migration from Sybase to Oracle?

        Technical Challenges

        Key Architectural Differences between Sybase ASE and Oracle

             Database Server

             Memory Model

             Transaction Processing


             Procedural Languages


             Backup and Recovery

             High Availability

             Partitioning and Storage

             Database Clustering

             Sybase Analytics Appliance versus Oracle Exadata


             Development Tools

        Keeping the Current Sybase Environment Running during the Migration

        Migration Tools

        Cost of Migration

        Sizing the Target Oracle Database Environment

        Infrastructure Migration Challenges

        Server Consolidation

        Oracle mLogica Case Study

             Business Drivers

             Situation Analysis

             The Challenge

             Implementing the Solution




    Chapter 12 Application Migration: Oracle Forms to Oracle Application Development Framework 11g

        Oracle Application Development Framework Introduction

             Oracle ADF Organizational Impact

        Options: Rearchitect or Rewrite


             Rewriting from Scratch

        Migration/Rewrite: Common Implementation Steps

             Forms-to-ADF Mapping

             What Doesn’t Map?

             The ADF Data Model

             Migrating Forms to ADF

             Application Module Client Exposed Methods

             View Objects and Queries in the Application Module

             ADF Task Flows

        Other Forms-to-ADF Mappings

             Table-based Search/Edit

             List of Values versus Drop Downs

             Post-Query versus View

             Keystrokes and Menu Items versus Buttons

        Case Study: Manufacturing and Logistics

             Background and Challenge

             Analysis and Design

             Assessing Complexity

             Mapping Forms to ADF with ART

             Project Results

        ADF in the Cloud

             Amazon and Oracle Cloud Templates


    Chapter 13 Application Migration: PowerBuilder to Oracle APEX

        Oracle Application Express Overview

        Why Migrate PowerBuilder to APEX?

        Background on Carter’s, Inc.

        The OMNIA Sales Order Management Pilot Project

        Legacy System Characteristics and Technical Architecture

             Legacy System Characteristics

             Legacy Technical Architecture

        Legacy System Challenges

        Carter’s Priorities

        Migration Options Considered

        Pilot Project Results

        The OMNIA2 Project

             Design Objectives

        The New OMNIA2 Architecture

             PL/SQL Emphasis When Using Oracle APEX

        APEX in the Cloud


    Chapter 14 Challenges and Emerging Trends

        Business Challenges in Database and Application Migration

        Technological Challenges in Database and Application Migration

        Emerging Trends in Database and Application Migration Technology

        Business Challenges in the Adoption of Cloud Computing

        Technical Challenges of Cloud Computing

        Emerging Trends in Cloud Services and Offerings



Product details

  • No. of pages: 400
  • Language: English
  • Copyright: © Syngress 2011
  • Published: October 3, 2011
  • Imprint: Syngress
  • eBook ISBN: 9781597496483
  • Paperback ISBN: 9781597496476

About the Authors

Tom Laszewski

Tom Laszewski has over twenty years' experience in databases, middleware, software development, management, and building strong technical partnerships. He is currently the Director of the Oracle Platform Migrations Group.

Affiliations and Expertise

Tom Laszewski is currently the Director of the Oracle Platform Migrations Group.

Prakash Nauduri

Prakash Nauduri has over 18 years' experience working with databases, middleware, development tools/technologies, software design, development and training. He is currently the Technical Director of the Oracle Platform Migrations Group.

Affiliations and Expertise

Prakash Nauduri is currently the Technical Director of the Oracle Platform Migrations Group.

Ratings and Reviews

Write a review

There are currently no reviews for "Migrating to the Cloud"