I am sending this on behalf of an ISUG member in Mexico. He is considering upgrading from SQL Anywhere to ASE and is looking for some guidelines for the process.
He is concerned about the usual migration issues: creating the database objects (DDL) and loading the data. I have worked with SQL Anywhere but do not remember if it has a tool to extract the data to flat files and then use BCP to load it into ASE.
Also, I don't believe that SQL Anywhere uses T-SQL. It must use ANSI SQL, so that means that many of his queries should probably be rewritten.
Any hints and tips will be greatly appreciated. Migration guide?
This rant: Comparing SQL Anywhere With ASE
...leads to this 71-page migration guide: Migrating SQL Anywhere database applications to ASE
answered 16 Jul '12, 15:21