According to the documentation for version 9

"There are two kinds of upgrade possible with version 9:

Upgrade the database - Use the Upgrade [dbupgrad] utility to upgrade your
database.

Upgrade the database file format - Some features, such as new index types,
require a new database file format. The Upgrade [dbupgrad] utility does not
change the format of the database file."

Although it states that upgrading the database [bdupgrade] does not upgrade
the file format, it is not specific whether updating the file format
[unload/reload] upgrades the database. To upgrade the database and update
the file format do I need to do both? And when I attempt to open a 5.5
database in Sybase central I am prompted to use the wizard to unload and
reload. Does this process upgrade the database AND upgrade the file format.

Thank you.

Bill

The unload-dbinit-reload-via-dbisql process does everything. Using the
Version 9 dbinit.exe guarantees that both the file format and the
system catalog are the very best they can be. Don't fiddle with
dbupgrad.exe; IMO it should be dropped from the product

Here is the step-by-step process that I recommend; FWIW you should use
Version 9 executables for all the steps here, even though you're
dealing with an old .DB file in the earlier steps:

1. Disconnect all other users from the old database.

2. Unload the old database with dbunload.exe.

3. Stop the old database.

4. Delete the old database file and transaction log.

5. Create a new database file with dbinit.exe.

6. Start the new database.

7. Increase the size of the new database file with ALTER DBSPACE
in ISQL.

8. Defragment the hard drive.

9. Examine and edit the reload.sql file if necessary.

10. Load the new database by running reload.sql via ISQL.

11. Check to make sure everything's OK.

12. Make the new database available.

If you have any questions about the details, just ask ... this list
comes from Chapter 12, Tuning, in SQL Anywhere Studio 9 Developer's
Guide ISBN 1-55622-506-7 Wordware Publishing, due 2004.

Breck

On 17 Dec 2003 14:06:23 -0800, "Bill Urbanovsky"
<burbanovsky (AT) irsaims (DOT) com> wrote:

--
bcarter (AT) risingroad (DOT) com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com