HomeOracle 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.
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.