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.

asked 28 Aug '12, 17:19

Akshat's gravatar image

Akshat
31113
accept rate: 0%

edited 15 Mar '13, 18:26

Mark%20Culp's gravatar image

Mark Culp
22.7k9129266


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!

permanent link

answered 29 Aug '12, 16:08

Chris%20Kleisath's gravatar image

Chris Kleisath
3.2k92835
accept rate: 38%

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.

permanent link

answered 29 Aug '12, 05:19

Hartmut%20Branz's gravatar image

Hartmut Branz
37629
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×45
×17
×15

question asked: 28 Aug '12, 17:19

question was seen: 1,422 times

last updated: 15 Mar '13, 18:26