Sybase数据库迁移到Oracle 11g手册
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
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
Enter