Migrating to the Cloud
Oracle Client/Server Modernization
- 1st Edition - October 3, 2011
- Authors: Tom Laszewski, Prakash Nauduri
- Language: English
- Paperback ISBN:9 7 8 - 1 - 5 9 7 4 9 - 6 4 7 - 6
- eBook ISBN:9 7 8 - 1 - 5 9 7 4 9 - 6 4 8 - 3
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… Read more
Purchase options
Institutional subscription on ScienceDirect
Request a sales quoteMigrating 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.
- 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
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
- No. of pages: 400
- Language: English
- Edition: 1
- Published: October 3, 2011
- Imprint: Syngress
- Paperback ISBN: 9781597496476
- eBook ISBN: 9781597496483
TL
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.PN
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.Read Migrating to the Cloud on ScienceDirect