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:

By: Jayaram Krishnaswamy

Poor Best

Rating:

/ 9

July 19, 2006

print this article

SEARCH DEV SHED

TOOLS YOU CAN USE

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.