Preliminary steps

Before you run the installation program to reconfigure Adaptive Server:

  1. Dump all user databases and the master database. If you have made changes to model or sybsystemprocs, dump them also.

  2. Load the Language Module if it is not already loaded (see the configuration documentation for your platform for complete instructions).

  3. If you are changing the Adaptive Server default character set, and your current databases contain non ASCII-7 data, use bcp to copy the existing data out of your databases.

Once you have loaded the Language Module, you can run the Adaptive Server installation program, which allows you to:

See the configuration documentation for your platform for instructions on using the installation program.

To reconfigure the language, character set, or sort order, use the sqlloc utility, described in Utility Guide for UNIX Platforms. If you are using Windows NT, use the Server Config utility, described in Configuration Guide for Windows NT. If you are adding a new character set that is not included with Adaptive Server, see the Sybase Character Sets manual for complete instructions.

If you installed additional languages but did not change Adaptive Server’s character set or sort order, you have completed the reconfiguration process.

If you changed the Adaptive Server default character set, and your current databases contain non ASCII-7 data, copy your data back into your databases, using bcp with the necessary flags to enable conversion.

If you changed Adaptive Server’s default sort order or character set, see “Reconfiguring the character set, sort order, or message language”.