Alternative to dump and load for Adaptive Server 12.5.1

If you are upgrading from Adaptive Server 12.5.1 or later and plan to build a new server instead of upgrading an existing server, the following steps are faster alternative to dumping and loading the database. This method is fastest if you are using storage area network (SAN) technology, even if you are migrating to new hardware at the same time. The server you are building must have access to (or copies of) the physical devices of the old server, and the databases must be aligned with the devices. If a device contains fragments of more than one database, you may have to move or upgrade all the databases at the same time.

Either quiesce the 12.5.x database to a manifest file during testing, or unmount the database from the server.
If the 15.0 Adaptive Server is on another host, unmount the disk devices from the current host and mount them to the new host machine or copy the devices using SAN utilities.
Copy the manifest file to the new Adaptive Server 15.0 location.
Mount the 12.5.x database to the Adaptive Server 15.0 server using the manifest file. You may need to rewrite the new device paths for the server location.
Issue the online database command. The database upgrade begins when you bring the database online.

Example

The following example assumes that you are upgrading the testdb database using a manifest file named testdb_manifest.mfst.

Quiesce the 12.5.x database:

quiesce database for_upgrd hold testdb
for external dump
to "/opt/sybase/testdb_manifest.mfst"
with override

Copy the devices using disk copy commands (for example, dd), SAN utilities, or standard file system command.
When the device copy is finished, release the quiesce:
```
quiesce database for_upgrd release
```
If this is the final upgrade for this server (as opposed to a server for testing), shut down the server to prevent further changes.
Move the device copies to the new host machine and mount them as appropriate.
In the 15.0 server, issue the following to list the physical-to-logical device mappings:
```
mount database all from "/opt/sybase/testdb_manifest.mfst" with listonly
```

Use the results from step 6 to determine the new physical device mappings that correspond to the logical devices and mount the database in the 15.0 Adaptive Server:

mount database all from "/opt/sybase/testdb_manifest.mfst" using
	"/opt/sybase/syb15/data/GALAXY/test_data.dat" = "test_data",
	"/opt/sybase/syb15/data/GALAXY/test_log.dat" = "test_log"

Bring the database online and start the upgrade process:
```
online database testdb
```