COVID-19 Update: We are currently shipping orders daily. However, due to transit disruptions in some geographies, deliveries may be delayed. To provide all customers with timely access to content, we are offering 50% off Science and Technology Print & eBook bundle options. Terms & conditions.
Migrating to the Cloud - 1st Edition - ISBN: 9781597496476, 9781597496483

Migrating to the Cloud

1st Edition

Oracle Client/Server Modernization

Authors: Tom Laszewski Prakash Nauduri
eBook ISBN: 9781597496483
Paperback ISBN: 9781597496476
Imprint: Syngress
Published Date: 3rd October 2011
Page Count: 400
Sales tax will be calculated at check-out Price includes VAT/GST
Price includes VAT/GST

Institutional Subscription

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

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




No. of pages:
© Syngress 2011
3rd October 2011
eBook ISBN:
Paperback ISBN:

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