Hello all...we have migrating our Sybase ASA databases from
Adaptive Server Anywhere 9.0.2.2451 to SQLAnywhere
11.0.1.2044. If we find there is a need to apply build 2299
to SQLAnywhere 11.0.1.2044, will we have to re-migrate our
databases? Any info would be greatly appreciated

No need to migrate. From this point 11.0.1 will at most only
need a short run of dbupgrad ... if that ...

The need to rebuild is based upon a major change to the
data structures used inside the database. Most of that
requirement was a 10.0 change ... give this is the very
first time this was such a fixed requirement (in the
entire history of the product) ... I would not expect
this to come up too frequently or any time soon.

You can always rebuild a database at any version, but
other than trying to compact space or reorganize the
internal storage of the tables and indexes (universally
instead of doing single table reorgs) you normally
will only need to do so to pick up major new features
and only for those features that require a change of
some data structure to support them. [Those will
be identified in the new features section on every
release version.]

Short of having some need to test/work-around some
file system corruptions that pretty much covers the
need to rebuild databases.


<Mark> wrote