Computing? Computing Service Models Computing Deployment Models
The Oracle Cloud
6
Legacy Client/Server
Databases and
Applications
Why Migrate?
10 11
Why Oracle?
CHAPTER 2
3 5
13
Migration Strategies Summary
16
Endnotes
19
Identifying the
19
Level of Effort and Cost
Complexity of Database and Application SQL Migration Defined Overall Estimating and Scoping Approach
Migration with Oracle SQL Developer
On-site Visit
or Web
24 25 25
Questionnaires First-Pass
21
Conference(s)
27 27
Migration Workshop
28
Scope Deliverables
28
Analysis Database
and
28
Design
29
Migration
Schema and Data
29
Stored Procedures
30
Triggers
30
Views
31
Application Migration SQL Only Language Migration Language Migration: Sybase
32 32 33 and SQL Server
C/C++ APIs
33
Service Enablement
34
Integration
Architecture
Infrastructure
Products, Utilities, and Tools
34 34 V
vi
Contents
Application
Server
Migration
to Oracle
WebLogic
Hardware and Software Exadata and
Exalogic:
35 Database and Middleware
Hardware and Software
35
Oracle Virilization and Oracle
Enterprise
Linux:
Database and Middleware Hardware and Software
Operating System Migration System, Customer Acceptance,
36
Sybase C++, PowerBuilder, Java, and Object Migration Estimate DB2 PowerBuilder and Java
36 37 38 38 38
39
Business
Migration Estimate
40 40
Summary
42
Endnotes
43
Methodology and Design
45
Migration Options Methodology and Design
45 46
Assessment
47
Analysis and Design Migration Testing Optimization Deployment Post-Production Support
51
Migration Summary CHAPTER 4
36
and Performance
Testing Moving to Production Other Things to Consider.. Project Management and Enterprise Architect Migration Effort Examples SQL Server Visual Basic Migration Estimate
CHAPTER 3
34
Services
Relational Migration Tools Initial Database Migration Database API and Protocol
Application Migration Ispirer SwisSQL Unit Testing
84
Performance
Testing System Testing
86
Production Rollout
87
85 86
86
Oracle GoldenGate
87
Oracle CDC ODI CDC
88
Knowledge
Modules
89
Matrix of Production Rollout Tools
CHAPTER 5
89
Global and Niche Service Providers
89
Summary
90
Endnotes
91
Database Schema and Data Database
Migration Migration Migration
Database Schema Data
Migration
Tools from Oracle
Data Data Data Data Data
102 103
and Transfer
Staging Loading Loading Using Oracle SQL*Loader Loading Using the External Table Feature Loading Using SQL Developer Migration Using ETL Tools Such as ODI
Data Validation
Oracle
104 106 107 110 112 113 113
Database Migration
to Oracle
Using SQL Developer Prerequisites for Schema Migration Using SQL Developer Database Schema Migration Summary
Sample Sybase
93 95
Tasks
Data Extraction Data
93
115 115 117
129
vii
vifi
Contents
CHAPTER 6
Database Stored
Object Migration
Environment for
SQL Developer
131
Sample Migrations
Stored Procedure
136
Migrations
Oracle Differences
137
Top Challenges and Solutions Example Sybase Stored Procedure Migration
138 139
I42
Triggers
142
Oracle Differences and Solutions
143
Top Challenges Example SQL Server Trigger Migration
144 147
Views Oracle Differences and
Top Challenges
and
147
Solutions
Example SQL Testing Setting Up the
Server View
Migration
148
Unit
Environment and
150
Unit
Testing
Creating 151
the Unit Test
151
Unit Test of Oracle Stored Procedure Unit Test of
Sybase
and
SQL
Server Stored Procedures ....151
153
Summary
CHAPTER 7
133 135
Translation Scratch Editor
Application Migration/Porting Database Migration
Due to 155 155
Types of Application Changes
Influencing Application Changes
156
Migration Options and Solutions Manually Identifying Changes and Modifying
159
Factors
Applications Migrating Applications Using Scripts and
159 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
163 164 168 171 173
175
Optimization
Application Build Summary
162
173
Handling
Performance
159
Process
175
Changes
178 179
Contents
CHAPTER 8
Migrating Applications
to the Cloud
181 182
Application Migration Options Emulation/Web Service Enablement
183
Rearchitecture/Rewrite
184
Automated
184
Migration
185
COTS
Moving to Noncoding Rehosting
186
Fusion Products
186
Portfolio Rationalization
187
Application Analysis 3GL Applications 4GL Applications Target Languages and Environments
188 190 190
191
Java and Java EE
192
Java EE Frameworks
192
Oracle Oracle
Application Development Framework (ADF) Application Express (APEX)
Target Hardware
Building Your
Custom
Scripts
195 195
and Software Stack
Options
Own Nonvirtualized Cloud
Building Your Own
193 194
Oracle Fusion Product Solutions
Application-Supporting Tools and Applications in the Cloud
193
Virtualized Cloud Platform
197 198 200
Oracle Virtualized Red Stack
202
"Cloud in
203
a
Box":
Exalogic
Pros and Cons of Each Hardware and Software
CHAPTER 9
Stack Option Hosting Options Summary
205
Endnotes
208
207 207
Service Enablement of Client/Server
Applications The
209 210
Unique Client/Server Dilemma with
a Replacing Client/Server Systems 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
211 211 212
213 214
ix
x
Contents
Development
Process
217
Runtime Considerations
LegaSuite Sizing for Performance and Scalability Load Balancing Infrastructure Changes Including Client/Server Application Logic
228 230
231 233 with
233
Oracle Middleware From Windows Client/Server
Applications
to SOA in
234
the Real World
Study In-Depth: Social Interest Solutions Modernizes Public Assistance Enrollment Process Case
with
CHAPTER 10
LegaSuite Summary
235
Endnotes
238
236
Oracle Database Cloud Infrastructure Planning and Implementation Oracle Database Cloud
239
Implementation Considerations
239
Server Consolidation and Virtualization
(IaaS
and
240
PaaS)
Workload Consolidation and Database Oracle
(PaaS
or
Migrations
241
DBaaS)
Database Considerations for Multitenant
(Software
as a
Infrastructure
to
Service
Planning
or
Applications
SaaS)
for Database
245
Migrations
to
Oracle (DBaaS)
247
Platform Considerations
248
Platform
252
Sizing
Exadata System Sizing
Backup
and
Recovery
254 and Disaster
Recovery 258
Strategy
Monitoring
and
Management
of the Oracle
Database Cloud
260
Summary
CHAPTER 11
260
Sybase Migrations from a Systems Integrator Perspective, and Case Study Why
Consider Database
Migration from Sybase
Oracle? Technical
Key
261
to
262
266
Challenges
Architectural Differences between
ASE and Oracle
Sybase 267
Contents
267
Database Server
Memory
268
Model
Transaction Processing
269
Analytics
269
Procedural Languages
270
Security
271
Recovery High Availability Partitioning and Storage Database Clustering Sybase Analytics Appliance
Backup
271
and
271 272 272 versus
Oracle Exadata.
Tools
Development Keeping the Current Sybase Environment Running during the Migration Migration Tools Cost of Migration Sizing the Target Oracle Database Environment Infrastructure
CHAPTER 12
mLogica
Case
273
274 274 275 276 276
Migration Challenges
277
Server Consolidation Oracle
273 273
Performance
278
Study
Business Drivers
279
Situation
Analysis Challenge Implementing the Solution
279
The
279
Results
280
280
Summary
280
Endnotes
281
Application Migration: Oracle Forms Oracle Application Development
to
Framework 11g
283
Oracle Application Development Oracle ADF
Framework Introduction ..283 284
Organizational Impact
Rearchitect
Rewrite
or Options: Rearchitecting Rewriting from Scratch Migration/Rewrite: Common Implementation Steps
Forms-to-ADF What Doesn't
285 286 288 288
Mapping
290
Map?
290
The ADF Data Model
290
Forms to ADF
Migrating Application Module Client Exposed
285
Methods
292
xi
xii
Contents
View
in the
Objects and Queries
Application
Module
Other Forms-to-ADF
296
Mappings
296
Table-based Search/Edit List of Values
versus
Drop
Downs
298
versus View
298
Post-Query Keystrokes and Menu Items versus Buttons Case Study: Manufacturing and Logistics Background and Challenge
299 300
300
and
Analysis Design Assessing Complexity Mapping Forms to ADF Project Results
301
302 304
with ART
305 306
ADF in the Cloud Amazon and Oracle Cloud
306
Templates
308
Summary
CHAPTER 13
Application Migration: PowerBuilder
to
Oracle APEX
309
Application Express Overview Why Migrate PowerBuilder to APEX? Background on Carter's, Inc
309
Oracle
The OMNIA Sales Order
310 311
Management Pilot Project
Legacy System Characteristics
and Technical
312
Architecture.,313
Legacy System Characteristics Legacy Technical Architecture Legacy System Challenges
313
Carter's Priorities
317
Migration Options Considered Pilot Project Results The OMNIA2 Project Design Objectives
317
314 315
319 320 321
The New OMNIA2 Architecture
PL/SQL Emphasis
CHAPTER 14
293 293
ADF Task Flows
When
Using
323 Oracle APEX
325
APEX in the Cloud
326
Summary
328
Challenges and Emerging Business
Challenges
Trends
in Database and
Application
Migration
Technological Challenges Application Migration
331 331
in Database and 332
Contents
Emerging Trends in Database and Application Migration Technology Business Challenges in the Adoption of Cloud Computing Technical Challenges of Cloud Computing