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:
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)
四、Creating the mwrep User
To create a new database user, perform the following steps:
Note: If you already have a system_orcl connection and a mwrep user, you can skip these steps.
1. Open Oracle SQL Developer from the icon on your desktop.
2. Select View > Connections.
3. In the Connections tab, right-click Connections and select New Connection. A New / Select Database Connection window will appear.
4. Enter system_orcl in the Connection Name field (or any other name that identifies your connection), system for the Username field, and for the Password field. Select the Save Password check box.
Enter in the Hostname field and orcl in the SID field. Click Test.
