Migrating from Oracle 10G XE to SQL Anywhere 10 - Initial steps to take before migration

(Page 2 of 5 )

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.

Next: Using the Migrate Database Wizard in SQL Anywhere 10 >>
 

More Oracle Articles
More By Jayaram Krishnaswamy

Comments On: Migrating from Oracle 10G XE to SQL Anywhere 10

· I have to say that this article seems to me a waste of web space, I mean:1. Is...    · Nothing is a waste, least of all web space. You need to stand, before you walk. This...   >>> Post your comment now!