First, I would suggest that you use a newer version of SQL Anywhere. ASA 9 has been EOL'ed for many years. The current version is SA 16.
Have you looked at the Database Migration Wizard? The SQL Anywhere migration tools can help you move your data from Oracle into a SQL Anywhere database, but cannot help you migrate any stored procedures or triggers, etc. (I doubt you will find any tool to do the latter since the languages used by the two DBMSes are different).
answered 28 May '13, 08:57
Regardless of the tool, free or otherwise, pay CLOSE ATTENTION to the data types after the migration. There are many fundamental differences at the physical level, and which SQL Anywhere data type you choose (in SOME cases) depends on how the data is being used by your application.
Data types are often chosed because they are "plenty good enough" for a particular column. That's fine, but after migration, the generated data type might be "not quite good enough".
If you care about your data (and it's OK to not care, if the data's not important), there is no substitute manually ... checking ... each ... and ... every column data type.
Plus, if you don't completely understand all the Oracle and SQL Anywhere data types involved, either learn (they're all documented) or find someone who does understand.
(and good luck with the triggers and procedures, but that's a whole different conversation)
answered 28 May '13, 09:34