Migrating from Adaptive Server 12.5.1 to 15.5

Migrate from Adaptive Server version 12.5.1 to 15.5 using sybmigrate may generate an error message.

When you migrate from Adaptive Server version 12.5.1 to 15.5 using the sybmigrate utility, you may encounter an error message similar to:

"local server name not set for server 'source' on 
host 'host1'(IP address + port number='xx.xx.xx.xxx:xxxx')"

Adaptive Server version 12.5.1 is no longer supported, and Adaptive Server does not automatically recognize the 12.5.1 server. Sybase recommends that you upgrade from 12.5.1 to 12.5.4, then from 12.5.4 to 15.5.

To make the 12.5.1 server visible to the 15.5 server, use:

1>sp_addserver 'servername', local
2>go

Restart Adaptive Server. It now recognizes the 12.5.1 server.