Migrating to the Cloud, 1st Edition

Oracle Client/Server Modernization

 
Migrating to the Cloud, 1st Edition,Tom Laszewski,Prakash Nauduri,ISBN9781597496476
 
 
Up to
25%
off
 

  &      

Syngress

9781597496476

9781597496483

400

235 X 191

Migrate your legacy data to the cloud: A complete reference for Oracle database migration, desktop application migration and IT infrastructure consolidation projects!

Print Book + eBook

USD 59.94
USD 99.90

Buy both together and save 40%

Print Book

Paperback

In Stock

Estimated Delivery Time
USD 37.46
USD 49.95

eBook
eBook Overview

VST format:

DRM Free included formats: EPub, Mobi, PDF

USD 37.46
USD 49.95
Add to Cart
 
 

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

Description

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.

Readership

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

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

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.

Migrating to the Cloud, 1st Edition


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






 
 
Save up to 25% on all Books
Shop with Confidence

Free Shipping around the world
▪ Broad range of products
▪ 30 days return policy
FAQ

Contact Us