Holiday book sale: Save up to 30% on print and eBooks. No promo code needed.
Save up to 30% on print and eBooks.
Migrating to the Cloud
Oracle Client/Server Modernization
1st Edition - October 3, 2011
Authors: Tom Laszewski, Prakash Nauduri
Paperback ISBN:9781597496476
9 7 8 - 1 - 5 9 7 4 9 - 6 4 7 - 6
eBook ISBN:9781597496483
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
LIMITED OFFER
Save 50% on book bundles
Immediately download your ebook while waiting for your print delivery. No promo code is needed.
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.
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
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
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.