When you hit the Finish button, the program goes through the migration process, and, depending on the amount of data, you will be presented with a message confirming success, or otherwise, as shown. Here the migration of the Employees table was successful.

The next picture shows the employees table that was migrated recently. There is another pre-existing Employees table owned by another user.

The next picture shows the details of the migrated table, which may now be compared with the original Oracle 10G XE's table. As you can see, the Employees table was migrated with all the data intact. The data type, scale, and size were all migrated correctly as well.

The following picture shows a small portion of the data from the migrated table.

Summary

The migration of the table from Oracle 10G XE to SQL Anywhere 10 was effortless and easy once the connection was correctly configured. The wizard provides a lot of guidance during migration, which is very helpful. During the migration process you have the option of creating a new owner for the migrated table. You may also create a new remote server, including an ODBC DSN for the remote server. The wizard caters to all well established database vendors; it also supports a generic server for which an ODBC driver is available. The author would like to thank David Jonker, Product Manager at Sybase iAnywhere, for helpful suggestions in the preparation of this article.