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

Initial steps to take before 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

The migration is from Oracle 10G XE to SQL Anywhere 10; therefore, both databases must be installed and working. For both databases you need the credentials to access the databases and permissions to work with the objects. For Oracle 10G XE the HR database will be used with the credentials Username: hr, Password: hr. For the SQL Anywhere 10 database the demonstration database demo10 will be used with User ID: dba and Password: sql. The following two pictures show how you may start and interact with the databases. In order to access the Migrate Database Wizard in SQL Anywhere 10, you will also need to start Sybase Central, the administration tool.

 

Creating an ODBC source for Oracle 10G XE

The migration wizard requires ODBC access to the Oracle 10G XE server in order to migrate the table. The ODBC DSN needs to be created. The ODBC DSN can be created from the Windows operating system's ODBC Manager. The next picture shows JayOra, a System DSN, created using the ODBC Manager. The ODBC source may also be created from within Sybase Central, or during the migration process.

The ODBC Oracle driver configuration is shown in the next picture. This needs to be correctly configured, otherwise the migration will fail. The Description item on this form refers to the machine on which the Oracle database is installed.



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