I recently dug up a very old SQL Anywhere database. I have it installed and it kind of works, its only the distributed side of the data, so everythings running via dbeng50 and ODBC.
I would like to migrate this data to MySQL. Is there a way to do this? I attempted to view the data using an ODBC tool but I kept getting error messages saying the ODBC driver doesn't support the version of ODBC behavior. I guess the database is too old (its from 1997).
Its also difficult to find the old SQL tools that would help me access these.
Is it possible to use the .db file with a newer version?
Any help or guidance at all would be appreciated.
You should be able to migrate this database using the tools in the latest version of SQL Anywhere, which is version 12. A free developer edition is available here: http://www.sybase.com/detail?id=1016644&contentOnly=true
Once you get the newest developer edition, complete instructions on upgrading the database are located here: http://dcx.sybase.com/index.html#1201/en/sachanges/unloading-reloading-upgrading-newjasper.html
Perhaps you will find that SQL Anywhere version 12 will solve all your needs, and you won't need to do any additional migration work!
answered 29 Aug '12, 16:08
You should be able to use this database file with database servers up to version 9.0.2. Version 5.x.x also has a utility dbunload.exe to extract the data and schema from that database.
answered 29 Aug '12, 05:19