Home arrow Oracle arrow Page 4 - Migrating from Oracle 10G XE to SQL Anywhere 10

Continuing the migration - Oracle

In a previous article, a set of tables from Oracle 10G XE were transferred to SQL 2005 Server using SQL 2005 Server's Export/Import Wizard. This article is about migrating a table from Oracle 10G XE to SQL Anywhere 10.

TABLE OF CONTENTS:
  1. Migrating from Oracle 10G XE to SQL Anywhere 10
  2. Initial steps to take before migration
  3. Using the Migrate Database Wizard in SQL Anywhere 10
  4. Continuing the migration
  5. Finishing the migration
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 9
July 19, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

When you click on the Next button you have the option of making it read only or updatable. For this exercise, the read only option is chosen as shown in the next picture.

Clicking on the Next button opens the window where you need to provide an external login for the current user (dba, sql). This is where you type in the Oracle 10g XE credentials. You can also test the connection, which succeeded in this example, as you can see. 

Clicking on the Finish button will take you back to an earlier step in the Migrate Database Wizard. But this time your remote server has joined the collection of remote servers.

Highlight the new remote server OracleXE, and click on the Next button. This is the step where the tables to be migrated must be chosen. You can see all the Oracle tables in the Available Tables area. You can add and remove all the tables to the right by clicking the buttons between the left and right text areas. You may also select a single table and move it to the right, as shown in the picture for the Employees table.

When you click the Next button you will be taken to a window where you need to provide an owner for this table. In this case, DBA has been chosen as shown.

Clicking on the Next button in the above screen will lead you to the step where some migration options need to be chosen. You can migrate data as in this case, or migrate both data and foreign keys, as well as create proxy tables. The options chosen are shown in the picture.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: