Migrating a Sybase Database to Oracle Database 11g 一、Topics
This tutorial covers the following topics:
Overview
Prerequisites
Creating the mwrep User
Creating the Migration Repository
Capturing the Sybase Exported Files
Checking Convertion Preferences
Converting to the Oracle Model
Resolving Stored Procedure Convertion Failures
Resolving Stored Procedure Convertion Limitations
Generating and Executing the Script to Create the Oracle Database Objects
Checking Offline Data Move Preferences
Analysis and Estimation
Migrating the Data
Resolving Compilation Issues
Resolving Runtime Issues
Testing and Deployment
二、Overview
What Is SQL Developer?
Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks. Using Oracle SQL Developer, you can browse database objects, run SQL statements, edit and debug PL/SQL statements and run reports, whether provided or created.
Microsoft SQL Server Migration Overview
Using Oracle SQL Developer Migration Workbench, you can quickly migrate your third-party database to Oracle.
There are four main steps in the database migration process: