Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Migrating to Oracle Training Class

© 2007-2016 by Burleson Corporation

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Don't forget supplemental mentoring

 

Key Features

* Understand SQL Developer Migration tools and the Oracle Migration Workbench .

* See real world examples for migrating to Oracle.

*  Save hours of time by recognizing potential Oracle migration pitfalls.

* Learn the risks for each methods of migrating to Oracle.

*  Avoid tedious and risky manual Oracle migrations.

*  Migrate to Oracle with minimum downtime and hassle.

*  Understand how to convert T-SQL and C to PL/SQL

* Migrate course content is customized to your specific learning needs, offering for migrating from MySQL, MS SQL (SQL Server) and DB2.

  

Course Description

This migration to Oracle course examines all of the common processes involved when you migrate to Oracle, training with an eye on working secrets and tips for migrations with minimum unplanned downtime.

This Oracle migration training course is special because it is taught by a veteran Oracle Certified DBA with many years of full-time experience.
 

Book Required

  Migrating to Oracle

Benjamin Prusinski

ISBN 0-9797951-6-8 

Details:  Migrating to Oracle book

Audience

This course is designed for practicing database professionals who have basic experience with relational databases. Prior experience with Oracle is not required, but experience in Oracle concepts is beneficial.
 

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson also served as the Editor for the premier book Migrating to Oracle  by Rampant TechPress.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle Migration training class.

Course Duration

This is an intensive 3-day Migrating to Oracle from other relational databases.  The course topics are customized to meet your needs and can focus on migrating from Sybase, migrating to Oracle from SQL Server (MS-SQL) and migrating to Oracle from DB2. 



Migrating to Oracle Class
3-Day Training Syllabus

Copyright © 2016 by Donald K. Burleson

 

DAY 1

Introduction to Database Migration

Overview of database migration
      Manual procedures for migration
      The Oracle 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

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

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

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?

DAY 2

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

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

 
 

 

 




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

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

Oracle Migration Testing

Data Verification Testing

Performance Tuning

    User Acceptance Testing
    Quality Assurance (QA) Testing

DAY 3

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 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


- Using the Oracle API's within foreign applications

Optional Oracle Migration Topics:

MS-SQL SL Server SQL to Oracle SQL

Migrating MySQL SQL to Oracle SQL

Migrating DB2 SQL to Oracle SQL

Changing C programs to access Oracle

Changing PHP programs to access Oracle

 

 
 
 
 
 

This is a BC Oracle training course (c) 2007-2016

 

   

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.