|
ISBN:
0-9797951-6-8
ISBN 13:
978-0-9797951-6-9 |
Library of
Congress Number: xxx |
xxx
pages
Perfect bind - 9x7 |
Publication Date:
TBD |
|
Shelving:
Databases/Oracle |
Easy Oracle Series
#x |
|
|
Migrating to
Oracle
Expert secrets to migrate 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 has 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 San Diego and Orange
County Oracle and IBM DB2 User Group community, and he has
published various articles for customers and user groups on
data management.
Ben has been working with databases
including Oracle, Microsoft SQL Server, IBM DB2 UDB,
Informix, MySQL, and PostgreSQL since 1996 and has
accumulated over a decade of practical knowledge and
experience with complex database migrations and support on
how to best achieve results with large database migrations
to the Oracle platform.
Ben enjoys training in martial arts and tai chi as well as
travel to exotic locations in his free time outside of
working on Oracle databases. He has traveled to over 15
countries in Latin America and Asia and has a passion for
learning new foreign languages as well as cultural
traditions. |
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: |
|
