 | Migrating from Microsoft Access to Oracle | Oracle SQL Developer is a free and fully supported product that provides tools and utilities to migrate from Microsoft Access to Oracle. Whether you plan and complete the migration on your own or with the help of Oracle partners, review the following for more information.
|
|
Supported Migration Objects |  | Tables | | | Constraints | | Indexes | | Users | | Views | | | | |
Teradata Core Features SQL Developer supports the following core features when migrating from Microsoft Access: - Automatically converts column data types to appropriate Oracle data types.
- Automatically resolves object name conflicts, such as conflicts with Oracle reserved words.
- Stores database metadata in a repository where you can make changes.
- Retrieves source database information via online capture or offline capture.
- Parses and transforms Microsoft Access Queries to Oracle PL/SQL Views.
- Provides advanced customization capabilities such as the ability to change data type mappings, delete and rename objects.
- Generates reports about the status of the migration.
- Generates the DDL scripts for the creation of the destination Oracle database.
- Generates scripts for data movement.
- Allows you to migrate objects to existing Oracle tablespaces.
- Displays informational, error, and warning messages about the migration in a progress window.
|
|
|
Getting Help If you don't want to attempt the migration on your own or you have more questions the following resources are available: |
Learn More | | Planning a Migration - Download PMG Service Request Form
- Work with our Platform Migrations Group(PMG) who can help you plan your migration or who will suggest partners to do the same.
- Download this document to sign up for the Migration Services for Partners offered by the Platform Migrations Group(PMG) in Oracle
- Review Assessment, Scope, and Estimating Examples and Templates
- Using the information you provided in the questionnaire, 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:
| | Migration Methodology Roles and Responsibilities - Explains the migration phases and the activities and resources relevant to each phase. | | Training recommendations document - Explains the recommended training for a DBA who is new to Oracle. | | New to Oracle - An area on the Oracle Technology Network (OTN) Web site dedicated anyone new to Oracle. | |
Products
Printer View