INF: Loading Version 1.x Databases When Installing Version 4.2

  - Microsoft SQL Server version 4.2 for OS/2

SUMMARY

When the Setup program for SQL Server version 4.2 is used to upgrade existing version 1.11 databases, it automatically configures the code page and sort order. The code page is set to 850 and the sort order is set to either the version 1.x-compatible sort order (for a case-insensitive server) or the binary sort order (for a case-sensitive server).

When you perform a new version 4.2 installation with the intention of loading version 1.11 database dumps, you must select the same sort orders as above, according to the case sensitivity of the server.

If you need to put the server on code page 437 and also want to be able to load version 1.11 databases, use the Bulk Copy Program (BCP) to copy out the data, then do a fresh install of version 4.2 of SQL Server and BCP in the data after recreating the databases.

If you want to use code page 437 for the clients, you may not need extended character support because code page 437 provides limited support for extended characters. (Code page 437 is the default code page in the CONFIG.SYS file for the United States.) In this case, you can install SQL Server with code page 850 on the server, using the version 1.11 strict compatibility sort order option, and still configure the clients for code page 437 to allow 1.11 database dumps to be loaded. Because the first 128 characters are the same in both code pages, this will not make any difference if extended characters aren't going to be stored in the database or displayed at the client.

MORE INFORMATION

This information also applies to version 1.1 database dumps.