Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23, 2015 at 06:18 PM

    Hi Matt,

    You can open a v12 database with the v16 SQLA database engine, so need to unload/reload.

    Note: the situation where you'd want unload/reload is when you want to change the file format of the database so that you can take advantage of the new features.

    Add comment
    10|10000 characters needed characters exceeded

    • IMHO the quickest and easiest way would be using V12 to do the rebuild. In Sybase Central connect to the target database, select "Unload Database ..." from the database's context menu to start the wizard and select "Unload and reload into a new database" as unload method.

      This will generate a new database without the need to edit a reload skript.

      UnloadWizard.png (101.9 kB)