 Database
Migration Path This is the recommended
database migration path to follow when using the services available
from the Oracle Product Technical Services (PTS) group.
Follow the steps outlined below to perform
your migration according to the recommended migration path. Please
read through all steps as you will find useful links here for each
phase of your migration project:
1
- Install and Set
Up the Hardware for your Oracle Database 11g
Refer to the Oracle Database 11g
documentation
for detailed information about hardware requirements.
2
- Download and
Install an Oracle Database 11g
Perform an Enterprise or Client database
download depending on your requirements. You only need Oracle SQL
Developer or an Oracle client installation for those machines that
only need to access the Oracle Database 11g server instance.
Download the Database software from here.
3
- Download and
Install Oracle SQL Developer
Oracle SQL Developer Migrations
Use Oracle
SQL Developer Migrations to migrate your non-Oracle database
schema, including data, triggers, views, stored procedures, and
other database objects to an Oracle database. The specifics of what
is migrated depends on the database being migrated.
4
- Download Presentations
and Documentation
Download the following presentations and
documents to help you understand Oracle architecture, technical
issues, the scope of the migration, and the recommended migration
methodology:
- Oracle
Database 11g Product Family - Outlines the choices of Oracle
Database editions available. Each edition of Oracle Database 11g
has features and functionality to meet the varying requirements
of today’s business applications.
- High-Level
Migration Presentation - Explains why to use Oracle and introduces
the migration methodology, migration tools, typical migration
timeframes, etc. (to be updated)
- Technical
Migration Presentation - Compares Oracle to other RDBMS products,
highlights things to watch out for, and includes a Tips and Tricks
presentation. (to be updated)
5
- Train your Staff
It is recommended that your staff refer
to the following training materials to help them get started in
an Oracle environment:
- New
to Oracle - An area on the Oracle Technology Network (OTN)
Web site dedicated to technical folks who are new to Oracle.
6
- Download PTS
Service Request Form
Download this document
to sign up for the Migration Services for Partners offered by the
Product Technology Services (PTS) group in Oracle.
7
- Download Technical
Migration Questionnaires
Download the appropriate Technical Migration
Questionnaires from the following list so that an assessment/estimate
can be completed for your migration project:
8
- Send Questionnaires
to Oracle
Send the completed Service Request Form
and the Technical Migration Questionnaire to the appropriate address
(names on Migration Services Request Questionnaire document).
9
- Review Assessment,
Scope, and Estimating Examples and Templates
Using the information you provided in the
questionnaires, a PTS representative will create and send you an
estimation document that includes an estimated timeframe for the
migration project as well as the main steps required to complete
the migration. In the meantime, you may find it useful to review
the following documents:
10
- Start the Migration
Use the following tools and services to
begin your migration:
11
- Use Migration
Support Resources
If you run into any difficulties during
your migration project, use the following resources to find solutions
to your problems:
- Discussion
Forum - Subscribe to the forums and get hints and tips from
migration experts.
- Migration
Knowledge Base - Check out the repository of common technical
issues encountered during migration projects and find out how
to perform particular technical tasks in Oracle. The Knowledge
Base also includes sample "before and after" code and
is updated on an ongoing basis.
If you still have questions or need assistance,
please contact Tom Laszewski. |
Bookmark
