Migrating to the Cloud: Oracle Client/Server Modernization

Front Cover
Migrating to the Cloud : Oracle Client/Server Modernization
Copyright
Contents
About the Authors
About the Technical Editor
Introduction
	Book Overview
	Audience
	Book Layout
	Conclusion
Chapter 1 - Migrating to the Cloud: Client/Server Migrations to the Oracle Cloud
	What Is Cloud Computing?
	The Oracle Cloud
	Legacy Client/Server Databases and Applications
	Why Migrate?
	Summary
	Endnotes
Chapter 2 - Identifying the Level of Effort and Cost
	Complexity of Database and Application SQL Migration Defined
	Overall Estimating and Scoping Approach
	Analysis and Design
	Database Migration
	Application Migration
	Integration Architecture
	Infrastructure Products, Utilities, and Tools
	Hardware and Software
	System, Customer Acceptance, and Performance Testing
	Moving to Production
	Other Things to Consider
	Project Management and Enterprise Architect
	Migration Effort Examples
	Summary
	Endnotes
Chapter 3 - Methodology and Design
	Migration Options
	Methodology and Design
	Migration Services
	Summary
Chapter 4 - Relational Migration Tools
	Initial Database Migration
	Initial Stored Object Migration
	Application SQL Migration
	Unit Testing
	Performance Testing
	System Testing
	Production Rollout
	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 Validation
	Sample Sybase Database Migration to Oracle Using Oracle SQL Developer
	Summary
Chapter 6 - Database Stored Object Migration
	SQL Developer Environment for Sample Migrations
	Stored Procedure Migrations
	Triggers
	Views
	Unit Testing
	Summary
Chapter 7 - Application Migration/Porting Due to Database Migration
	Types of Application Changes
	Factors Influencing Application Changes
	Migration Options and Solutions
	Application Migration Tasks
	Summary
Chapter 8 - Migrating Applications to the Cloud
	Application Migration Options
	Portfolio Rationalization
	Application Analysis
	3GL Applications
	4GL Applications
	Target Languages and Environments
	Application-Supporting Tools and Custom Scripts
	Applications in the Cloud
	Target Hardware and Software Stack Options
	Hosting Options
	Summary
	Endnotes
Chapter 9 - Service Enablement of Client/Server Applications
	The Unique Client/Server Dilemma
	LegaSuite: Platform for SOA-Enabling Windows Client/Server Applications
	Step by Step for Creating an SOA Interface from a Legacy Windows Client/Server Application
	Legasuite Runtime Considerations
	From Windows Client/Server Applications to SOA in the Real World
	Summary
	Endnotes
Chapter 10 - Oracle Database Cloud Infrastructure Planning and Implementation
	Oracle Database Cloud Implementation Considerations
	Infrastructure Planning for Database Migrations to Oracle (DBaaS)
	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
	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
	Summary
	Endnotes
Chapter 12 - Application Migration: Oracle Forms to Oracle Application Development Framework 11g
	Oracle Application Development Framework Introduction
	Options: Rearchitect or Rewrite
	Migration/Rewrite: Common Implementation Steps
	Other Forms-to-ADF Mappings
	Case Study: Manufacturing and Logistics
	ADF in the Cloud
	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 Challenges
	Carter's Priorities
	Migration Options Considered
	Pilot Project Results
	The OMNIA2 Project
	The New OMNIA2 Architecture
	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