Migrating from Oracle 10G XE to SQL Anywhere 10 - Finishing the migration
(Page 5 of 5 )
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.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 7 
