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.
oracle ocp培训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 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. p  by the Capture contains the database schema information for the Sybase pubs2 database. Oracle SQL Developer Migration Workbench uses this  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</font> 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.

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。