[键入文字]
第 1 页 共 56 页
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:
Capture the
Source
Database The first step is to capture a "snapshot" of your Sybase database. This can be done in
two ways.
1. Online Capture: This requires creating a connection in SQL Developer to a live Sybase
database. Using JDBC, the Sybase database metadata can be accessed and the Capture Model [键入文字]
第 2 页 共 56 页 created.
2. Offline Capture: This involves BCP scripts generated by SQL Developer to extract the
Sybase database metadata to files. These files can then be "captured" by SQL Developer to create
the Captured Model.
The second method is what you will perform in this tutorial.
Using SQL Developers Offline Capture feature, Sybase Northwind sample database has been
extracted into offline data files. The Sybase15.ocp file generated by the Capture contains the
database schema information for the Sybase pubs2 database. Oracle SQL Developer Migration
Workbench uses this file as the basis for building a representation of the structure of the source
Microsoft Access database. This structure is called the Captured Model.
Convert the
Captured
Database Oracle SQL Developer Migration Workbench uses the Captured Model to convert the captured
objects to Oracle-format objects, building up a representation of the structure of the destination
database. This structure is called the Converted Model.
Generate
the Oracle
Database Oracle SQL Developer Migration Workbench generates DDL statements to create the new
Oracle database, based upon the Converted Model objects. Running the DDL statements will
result in the creation of the objects in the Oracle database.
Migrate the
Data The last step in the process is to migrate the data. You can do this in one of two ways.
1. Online Data Move: You can create a connection from within Oracle SQL Developer to your
Sybase source database and migrate the data.
2. Offline Data Move: You can export the data from Sybase. SQL Developer will create
a series of BCP and sqlldr files that you can run from a batch file.
The second method is what you will perform in this tutorial.
In this tutorial, the required scripts for the offline migration have already been generated and modified. If you do not
have time to perform this tutorial, you can also view the offline method, click here.
This tutorial uses a modified version of the pubs2 sample database. This sample database has been seeded with
migration issues, so that a more complex migration can be demonstrated.
The following issues will be covered.
➢ Conversion Preferences
➢ Stored Procedure Conversion Failures
➢ Stored Procedure Conversion Limitations
➢ Dynamic SQL
➢ Offline Data Move Preferences
If you are unfamiliar with SQL Developer Migration Workbench, please follow the "Migrating a Microsoft SQL Server
Database to Oracle Database 11g" tutorial first.
To view the steps for the online method, click here.
三、Prerequisites
Before you perform this tutorial, you should:
1. Install the Oracle Database 10g or later, or Oracle Database XE
2. Download and unzip Oracle SQL Developer here.
3. Download and unzip the sybasemigration.zip file into your working directory (i.e.wkdir)
