Home arrow Oracle arrow Migrating from Oracle 10G XE to SQL Anywhere 10

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

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.



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