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

Finishing 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 hit the Finish button, the program goes through the migration process, and, depending on the amount of data, you will be presented with a message confirming success, or otherwise, as shown. Here the migration of the Employees table was successful.

The next picture shows the employees table that was migrated recently. There is another pre-existing Employees table owned by another user.

The next picture shows the details of the migrated table, which may now be compared with the original Oracle 10G XE's table. As you can see, the Employees table was migrated with all the data intact. The data type, scale, and size were all migrated correctly as well.

The following picture shows a small portion of the data from the migrated table.

Summary

The migration of the table from Oracle 10G XE to SQL Anywhere 10 was effortless and easy once the connection was correctly configured. The wizard provides a lot of guidance during migration, which is very helpful. During the migration process you have the option of creating a new owner for the migrated table. You may also create a new remote server, including an ODBC DSN for the remote server. The wizard caters to all well established database vendors; it also supports a generic server for which an ODBC driver is available. The author would like to thank David Jonker, Product Manager at Sybase iAnywhere, for helpful suggestions in the preparation of this article.



 
 
>>> 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: