
SPECIFYING UPGRADE OPTIONS 

The upgrade process verifies that your current (old) server meets
system requirements and is eligible to be upgraded to the new 
version level. 

To specify an upgrade option:

1. Click the button for the task you want to perform: 

   * Run the eligibility tests only 
   * Run the eligibility tests and, if they pass, perform the 
     upgrade immediately
   * Perform the reserved word check
   * Skip the reserved word check

2. Click OK. 

If your server does not pass the eligibility tests, 
you must fix the condition(s) that failed, and run the eligibility 
tests again. 

You may not need to exit sqlupgrade to fix the problem. You may be able to 
fix the problem in an xterm window (for example, by altering a database to 
add space). Then click the appropriate button in the Specify Upgrade Options 
screen again.


UPGRADE TESTS PERFORMED  

The upgrade eligibility tests:

 * Verify that none of the database objects in your current (old) server 
   have names that are reserved words (Transact-SQL keywords) in the new 
   Adaptive Server. This test is performed if you select the perform the 
   reserved word check. 

 * Verify that all system and user databases have enough free space for 
   the upgrade. 
  
 * Indicate which databases need more space and how much is needed. 
    
   For information about space requirements, including how to add space to 
   the system procedures database or other databases, see the Adaptive Server 
   installation guide. 

   The eligibility tests do not explicitly warn you if a database 
   does not have enough log space for messages generated by the upgrade 
   process itself. To ensure that you have enough log space, run the 
   DUMP TRAN command as described in the Adaptive Server installation guide.
   
 * For pre-System 10 servers, allows you to create a system procedures device 
   (sybsystemprocs).  
   
 * Verify that auditing is turned off. Sqlupgrade cannot upgrade a server 
   if any database has auditing turned on. For information on disabling auditing, 
   see the Adaptive Server installation guide.
