|
ISBN:
0-9797951-6-8
ISBN 13:
978-0-9797951-6-9 |
Library of
Congress Number:
2009930093 |
400
pages
Perfect bind - 9x7 |
PD 0810 |
|
Shelving:
Databases/Oracle |
Oracle In-Focus Series
#33 |
|
|
Migrating to
Oracle
Expert Secrets for Migrating from
SQL Server and MySQL
Ben Prusinski
Retail
Price $89.95
/ £74.95
| Order now at 30% off and
get access to the
code depot! |
Only $62.99
(30% off) |
 |
|
|
One of
the biggest challenges that IT departments currently face is how
to migrate their non-Oracle databases to Oracle platform with
limited budget, staff, and time constraints.
In order
to meet these needs, Oracle originally developed an excellent
tool called the Oracle Migration Workbench (OMWB). As the latest
and greatest enhancement to migration software, Oracle has
provided the new version of migration tools along with a full
development environment with the SQL Developer software with
Oracle 10g and 11g database releases as the method of choice to
accomplish these daunting tasks.
This
comprehensive guide to these new Oracle migration tools will be
valuable to all database professionals who are challenged with
the task of migrating their non-Oracle databases to the Oracle
10g and 11g platforms. This text will provide the blueprint and
implementation details as well as expert hands-on tips and
techniques on how to use this new migration tool to quickly
migrate non-Oracle databases to the Oracle 10g database
environment.
Topics
will include a detailed discussion of these tools including
coverage of both SQL Developer and the Oracle Migration
Workbench installation and configuration process, techniques on
how to best use the editors for parsing non-Oracle SQL and
stored procedures to map to the Oracle SQL and PL/SQL code,
problem resolution and troubleshooting during the migration
process, and testing procedures after the initial migration has
been completed.
This book
distills the very complex and technical challenges of how to
best migrate your non-Oracle database into an easily digested
format with clear step by step techniques that all database
professionals can implement right away. |
|
|
Migrate to
Oracle with
Confidence!
|
|
•
Understand SQL Developer Migration tools and the Oracle
Migration Workbench
• See
real examples for SQL Server migration to Oracle
• See
examples for migrating from MySQL to Oracle
•
Understand how to convert T-SQL to PL/SQL
• Save
hours of time by recognizing potential migration pitfalls
• Avoid
tedious and risky manual migrations |
SQL Developer
and the Oracle 10g Migration Workbench are the premier
migration tools offered by Oracle with release 10g and 11g to
perform rapid migrations of large non-Oracle databases to the
Oracle 10g/11g platform without the need to purchase expensive
conversion tools. It provides a free option to convert all
non-Oracle database servers to Oracle 10g instead of manual
conversion techniques which would require hundreds of painful
hours of trial and error. Because of the powerful capabilities
within both SQL Developer and the Migration Workbench tool, it
is quick method to perform mass migrations of SQL Server and
MySQL databases for example, to the Oracle 10g/11g platform.
This tool provides many automation features as well.
This book
has a very broad reader base encompassing almost all technical
professionals who need to perform database migrations to Oracle
10g. This text will become indispensable to both technical and
project management staff who wish to migrate from non-Oracle
platforms on a narrow timetable and limited budget.
This book
incorporates proven techniques for implementing and completing
database migrations from non-Oracle databases to the Oracle
10g/11g platform.
All of the
techniques in this book use both SQL Developer as well as the
Oracle 10g Workbench Migration tool, so no additional third
party tools are required to be used to perform the database
migration to Oracle 10g/11g. This text will be comprehensive,
covering every aspect of how to migrate your non-Oracle database
to Oracle 10g and 11g using either the new SQL Developer tool or
the Oracle Workbench Migration tool. This text also includes
expert tips and techniques that have been developed by the
author that will provide a timeless and invaluable reference for
performing database migrations using SQL Developer and the
Oracle 10g Workbench Migration tool.
About the Author:
|
Ben Prusinski
 |
|
Ben Prusinski is an
Oracle Certified Professional and Oracle ACE with more
than 10 years of full-time experience as a database
administrator and has written numerous articles and white
papers on database management. Ben is also an active
member of the IOUG, OAUG, and SROAUG user group
communities. As a top Oracle expert, Ben is a frequent
speaker and presenter at major technical conferences
including Oracle OpenWorld, IOUG, and CLOUG.
Ben has worked with databases including Oracle,
Microsoft SQL Server, IBM DB2 UDB, and MySQL since 1996.
As a certified Oracle RAC expert, Ben has designed robust
architectures for high availability with Oracle RAC,
Streams, and Data Guard for Oracle E-Business Applications
and data warehouse environments. Furthermore, he has
accumulated over a decade of practical knowledge and
experience with complex database migrations and support,
focusing mainly on how to best achieve results with large
database migrations to the Oracle platform.
|
Technical Editor: |
|
Paulo Ferreira Portugal |
|
Paulo Ferreira Portugal
is a DBA with a decade of experience in IT
and has worked as a DBA for 8 years. He is
an Oracle Certified Professional (9i and
10g); IBM DB2 Certified (8 and 9 “Viper”);
and an Oracle 11i Applications Database
Administrator Certified Professional.
Currently, Paulo works as Senior
Applications DBA for a company named F2C
Consultoria in Rio de Janeiro/Brazil. F2C
serves one of Oracle E-Business’ largest
clients in
Brazil.
He has participated in the Oracle Beta Test
11i project using Data Guard, and is a
specialist in High Availability tools like
Oracle Data Guard, Oracle Streams and Oracle
RAC. His clients in Brazil demand the most sophisticated
services using tools like Oracle E-Business
Suite 11i, Oracle OTM, Oracle Retail and
Oracle BPEL with Oracle RAC 10g.
Paulo greatly enjoys what he does and is
always improving his technical knowledge by
attending events like Oracle Open World -
San Francisco (2005 and 2006) and
IBM Information on Demand – Los Angeles (2006).
|
Table of Contents:
|
Section I - Background
CHAPTER 1 – Introduction to Database Migration
Overview of database migration
Manual procedures for migration
The new Oracle 10g Workbench Migration
Basic Training for Planning the Migration
Database Architecture differences and Oracle 10g
SQL differences and Oracle SQL
Stored Procedures and Oracle PL/SQL
Why Oracle Migration Workbench is the Preferred Method
CHAPTER 2 – Overview of the Oracle Migration
Workbench
Introduction to the Oracle Migration
Workbench (OMWB)
Oracle Migration Workbench and Oracle APEX Workbench
Oracle SQL Developer
Architecture of the Oracle Migration Workbench
CHAPTER
3 – Installation for Oracle Migration Workbench and the APEX
Migration Workbench
Pre-requisites
Installation Procedures
Oracle Migration Workbench
Oracle APEX Migration
Oracle SQL Developer
Install the Plugin for the Oracle Migration Workbench
CHAPTER
4 – Configuration Tasks for Oracle Migration Workbench
Building the Source and Target Models
Choose between Online and Offline Data Capture
Advantages of Online Capture Method
Disadvantages of Online Capture Method
Advantages of Offline Capture Method
Disadvantages of Offline Capture Method
Which is the best method for your environment?
CHAPTER 5 – How to Perform Online Capture with
Oracle Migration Workbench
Automation Process
Configuration Parameters
Oracle SQL Developer Migration Workbench
Online Capture with SQL Developer
Quick Migration with SQL Developer
CHAPTER 6 – How to Perform Offline Capture
with Oracle Migration Workbench
Offline Capture with SQL Developer and
Oracle Migration Workbench
Scripts for use with Microsoft SQL Server
Bcp scripts for offline capture
Scripts for use with Sybase Adaptive Server
Scripts for use with IBM DB2 UDB
Scripts for use with mySQL
Scripts for use with Informix
|
Section II – Completing the Database
Migration Using SQL Developer and
Migration Workbench
CHAPTER 7 – The
steps of mapping the Source Model to Target Database
Building the Source Model with Oracle
Migration Workbench
Building the Source Model with SQL Developer Migration
Workbench
Using the Oracle Migration Workbench Editors
Tablespace Discovery Editor
Code Parser Editor
Mapping the new Source Model to the Target Model
Problem Resolution
Complete the initial migration
CHAPTER 8 – Understanding SQL Developer and
Oracle Migration Workbench utilities
Using Oracle Migration Workbench
Verification tool
Using Oracle Migration Workbench Editors
Using Oracle APEX Migration with Workbench Migration
How to configure plugins with Migration Workbench
CHAPTER 9 – Testing
Data Verification Testing
Performance Tuning
User Acceptance Testing
Quality Assurance (QA) Testing
CHAPTER
10 – Conclusion
Section III – Appendix and Bibliography
Oracle 10g Workbench Migration
User’s Guide
Oracle SQL Developer Documentation
Section IV - Manual database migration
Loading Oracle tables:
Punching table data for loading into
Oracle
Using SQL*Loader to load rows
Migrating indexes to
Oracle
Overview of Oracle index types
MySQL to Oracle create index syntax
SQL Server to Oracle create index syntax
Migrating SQL Server SQL to Oracle SQL
Migrating MySQL SQL to Oracle SQL
Changing C programs to access Oracle
Changing PHP programs to access Oracle
Migrating to PL/SQL
- Removing process logic with advanced
SQL (e.g. using "order by" to replace a sort, using CASE to
replace an IF statement, using rollup and cube for
aggregation)
- Boolean logic, IF statements
- Loops - while, for repeat until
- Calling Java from PL/SQL
- I/O conversion (utl_file, etc.)
- Creating built-in functions in PL/SQL:
http://www.remote-dba.net/pl_sql/t_create_orcale_customized_built_in_function.htm
- Using the Oracle API's within foreign applications
|
| |
Reviews
From the
series Editor:
Errata: |
