应用sybase迁移到oracle,Sybase数据库迁移到Oracle 11g手册

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: