Migrating to the Cloud book cover

Migrating to the Cloud

Oracle Client/Server Modernization

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.

Audience

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

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

Paperback, 400 Pages

Published: October 2011

Imprint: Syngress

ISBN: 978-1-59749-647-6

Contents


  • About the Authors

    About the Technical Editor

    Introduction

    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

        Summary

        Endnotes

    Chapter 2 Identifying the Level of Effort and Cost

        Complexity of Database and Application SQL Migration Defined

        Overall Estimating and Scoping Approach

             Questionnaires

             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

             Triggers

             Views

        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

        Summary

        Endnotes

    Chapter 3 Methodology and Design

        Migration Options

        Methodology and Design

             Assessment

             Analysis and Design

             Migration

             Testing

             Optimization

             Deployment

             Post-Production Support

        Migration Services

        Summary

    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

             Ispirer

             SwisSQL

        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

        Summary

        Endnotes

    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

        Summary

    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

        Triggers

             Oracle Differences

             Top Challenges and Solutions

             Example SQL Server Trigger Migration

        Views

             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

        Summary

    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

        Summary

    Chapter 8 Migrating Applications to the Cloud

        Application Migration Options

             Emulation/Web Service Enablement

             Rearchitecture/Rewrite

             Automated Migration

             COTS

             Moving to Noncoding Fusion Products

             Rehosting

        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

        Summary

        Endnotes

    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

        Summary

        Endnotes

    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

        Summary

    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

             Analytics

             Procedural Languages

             Security

             Backup and Recovery

             High Availability

             Partitioning and Storage

             Database Clustering

             Sybase Analytics Appliance versus Oracle Exadata

             Performance

             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

             Results

        Summary

        Endnotes

    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

             Rearchitecting

             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

        Summary

    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

        Summary

    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

        Summary

    Index






Advertisement

advert image