Migrating from Oracle 10G XE to SQL Anywhere 10

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:

By: Jayaram Krishnaswamy

Poor Best

Rating:

/ 9

July 19, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

In an earlier article migrating an MS Access database to the SQL Anywhere 9 server was considered, where the front end created on MS Access was retained. SQL Anywhere 10 is still in its beta and has more than 200 new features and enhancements.

Details of table migrated

The Employees table from the HR database in Oracle 10G XE whose details are shown in the next picture will be migrated to SQL Anywhere 10's demonstration database, demo10. It will be helpful to review the articles on Oracle 10G XE as well as SQL Anywhere 10 (to appear on the ASP Free website soon) so that the skills necessary to work with these databases are acquired. The Employees table has 11 columns with 107 rows of data. While foreign keys can be migrated using the Migrate Database Wizard, they will not be in this exercise. This exercise steps through and documents the process of using the Migrate Database Wizard in SQL Anywhere 10.