Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

New to SQL anywhere - db rebuilding question

Hi there,

I have inherited a small project involving a SQL Anywhere database that I have a question about. I have a database file that was created years ago and is hosted on a network server that a small number of client applications access. Over the years, the version of the db engine has been upgraded (currently running on SQL Anywhere 16), but the database file itself has not. I am currently archiving and cleaning out a bunch of data, and I wanted to run a rebuild on the database. During my crash course of SQL Anywhere, I read that the only way to rebuild the db is to unload and then reload it, which I did using Sybase Central. However, it appears that this also upgrades the db version, which makes a few of the client applications unhappy when they try to connect (these apps are not currently under my control). In corresponding with the person who previously maintained this db, it seems that the db file was originally created on version 12 of SQL anywhere, though I don't have an exact version number. Is it possible to reload the database into an 'old version' (for lack of a better term) using the existing engine, or do I need to try and find a copy of 12 to do this with?

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question