HomeOracle Page 4 - Migrating from Oracle 10G XE to SQL Anywhere 10
Continuing the 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.
When you click on the Next button you have the option of making it read only or updatable. For this exercise, the read only option is chosen as shown in the next picture.
Clicking on the Next button opens the window where you need to provide an external login for the current user (dba, sql). This is where you type in the Oracle 10g XE credentials. You can also test the connection, which succeeded in this example, as you can see.
Clicking on the Finish button will take you back to an earlier step in the Migrate Database Wizard. But this time your remote server has joined the collection of remote servers.
Highlight the new remote server OracleXE, and click on the Next button. This is the step where the tables to be migrated must be chosen. You can see all the Oracle tables in the Available Tables area. You can add and remove all the tables to the right by clicking the buttons between the left and right text areas. You may also select a single table and move it to the right, as shown in the picture for the Employees table.
When you click the Next button you will be taken to a window where you need to provide an owner for this table. In this case, DBA has been chosen as shown.
Clicking on the Next button in the above screen will lead you to the step where some migration options need to be chosen. You can migrate data as in this case, or migrate both data and foreign keys, as well as create proxy tables. The options chosen are shown in the picture.