Migrating to the Cloud: Oracle Client Server Modernization

401 Pages·2011·9.12 MB·english

by  Tom Laszewski

Migrating to the Cloud
This page intentionally left blank
Migrating to the Cloud
Oracle Client/Server
Modernization
Tom Laszewski
Prakash Nauduri
Technical Editor
Ward Spangenberg
AMSTERDAM(cid:129)BOSTON(cid:129)HEIDELBERG(cid:129)LONDON
NEWYORK(cid:129)OXFORD(cid:129)PARIS(cid:129)SANDIEGO
SANFRANCISCO(cid:129)SINGAPORE(cid:129)SYDNEY(cid:129)TOKYO
SyngressisanimprintofElsevier
AcquiringEditor:ChrisKatsaropoulos
DevelopmentEditor:MattCater
ProjectManager:JessicaVaughan
Designer:AlisaAndreola
SyngressisanimprintofElsevier
225WymanStreet,Waltham,MA02451,USA
(cid:1)2012ElsevierInc.Allrightsreserved.
Nopartofthispublicationmaybereproducedortransmittedinanyformorbyanymeans,electronicor
mechanical,includingphotocopying,recording,oranyinformationstorageandretrievalsystem,without
permissioninwritingfromthepublisher.Detailsonhowtoseekpermission,furtherinformationaboutthe
Publisher’spermissionspoliciesandourarrangementswithorganizationssuchastheCopyrightClearance
CenterandtheCopyrightLicensingAgency,canbefoundatourwebsite:www.elsevier.com/permissions.
ThisbookandtheindividualcontributionscontainedinitareprotectedundercopyrightbythePublisher
(otherthanasmaybenotedherein).
Notices
Knowledgeandbestpracticeinthisfieldareconstantlychanging.Asnewresearchandexperiencebroadenour
understanding,changesinresearchmethodsorprofessionalpracticesmaybecomenecessary.
Practitionersandresearchersmustalwaysrelyontheirownexperienceandknowledgeinevaluatingandusing
anyinformationormethodsdescribedherein.Inusingsuchinformationormethodstheyshouldbemindfulof
theirownsafetyandthesafetyofothers,includingpartiesforwhomtheyhaveaprofessionalresponsibility.
Tothefullestextentofthelaw,neitherthePublishernortheauthors,contributors,oreditors,assumeanyliability
foranyinjuryand/ordamagetopersonsorpropertyasamatterofproductsliability,negligenceorotherwise,
orfromanyuseoroperationofanymethods,products,instructions,orideascontainedinthematerialherein.
LibraryofCongressCataloging-in-PublicationData
Laszewski,Tom.
Migratingtothecloud:Oracleclient/servermodernization/TomLaszewski,PrakashNauduri.
p.cm.
ISBN978-1-59749-647-6
1.Cloudcomputing.2.Systemsmigration.3.Oracle(Computerfile)4.Client/servercomputing.
I.Nauduri,Prakash.II.Title.
QA76.585.L382012
004.6782edc23
2011029908
BritishLibraryCataloguing-in-PublicationData
AcataloguerecordforthisbookisavailablefromtheBritishLibrary.
ISBN:978-1-59749-647-6
PrintedintheUnitedStatesofAmerica
1213141516 10987654321
ForinformationonallSyngresspublicationsvisitour
websiteatwww.syngress.com
Contents
Aboutthe Authors...................................................................................................xv
Aboutthe Technical Editor..................................................................................xvii
Introduction.............................................................................................................xix
CHAPTER 1 Migrating to the Cloud: Client/Server Migrations
to the Oracle Cloud............................................... 1
What Is CloudComputing?...........................................................2
Cloud Computing Service Models...........................................3
Cloud Computing DeploymentModels...................................5
TheOracleCloud..........................................................................6
Legacy Client/ServerDatabases andApplications.....................10
Why Migrate?..............................................................................11
Why Oracle?...........................................................................13
Migration Strategies...............................................................16
Summary......................................................................................19
Endnotes......................................................................................19
CHAPTER 2 Identifying the Level of Effort and Cost..................21
Complexity ofDatabaseand Application SQL
Migration Defined.......................................................................24
OverallEstimating andScoping Approach................................25
Questionnaires........................................................................25
First-Pass Migration with Oracle SQLDeveloper.................27
On-site Visit or Web Conference(s).......................................27
Migration Workshop...............................................................28
Scope Deliverables.................................................................28
Analysis and Design....................................................................28
DatabaseMigration.....................................................................29
Schemaand Data....................................................................29
StoredProcedures...................................................................30
Triggers...................................................................................30
Views.......................................................................................31
Application Migration.................................................................32
SQL Only................................................................................32
Language Migration...............................................................33
Language Migration:Sybase andSQL Server
C/Cþþ APIs...........................................................................33
Service Enablement................................................................34
Integration Architecture..............................................................34
Infrastructure Products, Utilities,and Tools...............................34
v
vi Contents
Application ServerMigration toOracle WebLogic...............34
Hardware and Software...............................................................35
Exadata and Exalogic:Databaseand Middleware
Hardware andSoftware..........................................................35
Oracle Virtualization andOracleEnterprise Linux:
Databaseand Middleware Hardware and Software...............36
Operating System Migration..................................................36
System,Customer Acceptance, andPerformance
Testing..........................................................................................36
MovingtoProduction..................................................................37
Other Things toConsider............................................................38
ProjectManagement andEnterprise Architect...........................38
Migration Effort Examples..........................................................38
SQL ServerVisualBasic Migration Estimate.......................39
Sybase Cþþ, PowerBuilder, Java, and Business
Object MigrationEstimate.....................................................40
DB2 PowerBuilder and Java MigrationEstimate..................40
Summary......................................................................................42
Endnotes......................................................................................43
CHAPTER 3 Methodology and Design ......................................45
Migration Options.......................................................................45
Methodology andDesign............................................................46
Assessment..............................................................................47
Analysisand Design...............................................................51
Migration................................................................................55
Testing.....................................................................................62
Optimization...........................................................................63
Deployment.............................................................................65
Post-Production Support.........................................................66
Migration Services......................................................................66
Summary......................................................................................67
CHAPTER 4 Relational Migration Tools....................................69
Initial Database Migration...........................................................70
DatabaseAPI and Protocol Options.......................................70
SQL Loader and External Tables...........................................73
Oracle SQL DeveloperMigration Workbench
DatabaseMigration.................................................................73
Oracle Gateways.....................................................................74
Oracle ETL and ELT Tools....................................................75
Oracle TuxedoWorkbenchfor DB2 z/OS.............................76
Oracle GoldenGate.................................................................77
Contents vii
Third-PartyTools....................................................................77
Reducing Data Migration Timeand Disk
Requirements..........................................................................78
Matrixof Oracle and Third-PartyDatabaseMigration
Tools........................................................................................79
Initial Stored Object Migration...................................................79
Matrixof Oracle and Third-PartyStored Object
Migration Tools......................................................................81
Application SQLMigration........................................................83
OracleSQL Developer MigrationWorkbench
Application Migration............................................................84
Ispirer......................................................................................84
SwisSQL.................................................................................85
Unit Testing.................................................................................86
Performance Testing....................................................................86
System Testing.............................................................................86
Production Rollout......................................................................87
OracleGoldenGate.................................................................87
OracleCDC............................................................................88
ODI CDC Knowledge Modules.............................................89
Matrixof Production Rollout Tools.......................................89
Global andNiche Service Providers...........................................89
Summary......................................................................................90
Endnotes......................................................................................91
CHAPTER 5 Database Schema and Data Migration...................93
DatabaseMigration Tools fromOracle......................................93
DatabaseSchema MigrationTasks.............................................95
Data Migration..........................................................................102
Data Extraction.....................................................................103
Data Staging andTransfer....................................................104
Data Loading........................................................................106
Data Loading Using Oracle SQL*Loader............................107
Data Loading Using the External Table Feature.................110
Data Loading Using SQL Developer...................................112
Data Migration Using ETLTools Suchas ODI...................113
Data Validation..........................................................................113
Sample Sybase Database Migration toOracle Using
OracleSQL Developer..............................................................115
Prerequisites for Schema MigrationUsing SQL
Developer..............................................................................115
DatabaseSchemaMigration.................................................117
Summary....................................................................................129
viii Contents
CHAPTER 6 Database Stored Object Migration.......................131
SQL Developer Environment for Sample Migrations..............133
TranslationScratch Editor....................................................135
StoredProcedure Migrations.....................................................136
Oracle Differences................................................................137
Top Challenges andSolutions..............................................138
Example Sybase StoredProcedure Migration.....................139
Triggers......................................................................................142
Oracle Differences................................................................142
Top Challenges andSolutions..............................................143
Example SQLServer Trigger Migration..............................144
Views.........................................................................................147
Oracle Differences andTopChallenges and
Solutions...............................................................................147
Example SQLServer ViewMigration.................................148
Unit Testing...............................................................................150
SettingUp the Unit TestingEnvironment andCreating
the Unit Test.........................................................................151
Unit Test of Oracle Stored Procedure..................................151
Unit Test of Sybase and SQL ServerStored Procedures....151
Summary....................................................................................153
CHAPTER 7 Application Migration/Porting Due to
Database Migration............................................155
TypesofApplication Changes..................................................155
FactorsInfluencing Application Changes.................................156
Migration Optionsand Solutions..............................................159
ManuallyIdentifying Changes and Modifying
Applications..........................................................................159
Migrating Applications Using Scripts and Tools.................159
EmulationTechnology-based Solutions...............................162
Application Migration Tasks.....................................................163
DatabaseConnectivity Changes...........................................164
EmbeddedSQL Changes......................................................168
Application CodeChanges...................................................171
DatabaseAPI Changes.........................................................173
Changes toExternal Interfaces and Replication
Solutions...............................................................................173
Error Handling......................................................................175
Performance Optimization....................................................175
Application BuildProcessChanges.....................................178
Summary....................................................................................179
Contents ix
CHAPTER 8 Migrating Applications to the Cloud ....................181
Application MigrationOptions.................................................182
Emulation/Web Service Enablement....................................183
Rearchitecture/Rewrite.........................................................184
Automated Migration...........................................................184
COTS....................................................................................185
MovingtoNoncoding Fusion Products...............................186
Rehosting..............................................................................186
Portfolio Rationalization...........................................................187
Application Analysis.................................................................188
3GL Applications......................................................................190
4GL Applications......................................................................190
Target Languagesand Environments........................................191
Java and JavaEE..................................................................192
Java EE Frameworks............................................................192
OracleApplication Development Framework (ADF)..........193
OracleApplication Express (APEX)....................................193
OracleFusion ProductSolutions..........................................194
Application-SupportingTools and Custom Scripts..................195
Applications in the Cloud.........................................................195
Target Hardware and SoftwareStackOptions..........................197
Building Your Own Nonvirtualized Cloud..........................198
Building Your Own Virtualized Cloud Platform.................200
OracleVirtualized Red Stack...............................................202
“Cloud ina Box”: Exalogic.................................................203
Pros andConsof Each Hardware and Software
StackOption.........................................................................205
Hosting Options.........................................................................207
Summary....................................................................................207
Endnotes....................................................................................208
CHAPTER 9 Service Enablement of Client/Server
Applications......................................................209
TheUnique Client/ServerDilemma.........................................210
Replacing Client/Server Systems with a
Cloud-based Application......................................................211
Restructuring Client/Server Code........................................211
Reusing Client/ServerApplications Using SOA.................212
LegaSuite: Platform for SOA-EnablingWindows
Client/ServerApplications........................................................213
Step byStep for Creating anSOA Interface from a
Legacy Windows Client/ServerApplication.............................214