Using CA AppLogic › Appliance Developer Guide › Appliance OS Installations › Common Components › Windows APK › Upgrade the Windows APK › Upgrade SQL Server Appliance

Upgrade SQL Server Appliance

The following steps describe the process for upgrading a Windows SQL appliance, using /system_ms:SQL08S_08 as an example.

Follow these steps:

1. Open the GUI, then create and open a new application. This creates a sandbox application that you delete in the final step.

   The application displays in the Infrastructure Editor.

   • Drag an instance of the IIS08S appliance from the system_ms catalog to the canvas.
   • Branch the class instance.
   • Right click the singleton and select Modify Boundary. The Class Definition dialog box displays.

     In the Documentation URL field, enter the catalog datasheet URL. For example:

     http://doc.3tera.com/AppLogicxx/CatDatabaseAppliancesSQL.html.

     where xx is the new version of CA AppLogic

   • Select the Volume tab, then add a 3 GB raw volume .

     Configure the singleton to use this volume as its data volume.

   • Click OK. The Infrastructure Editor displays.
   • Save and start the application. Do not close the GUI.
2. Open a 3t shell and ssh into the running singleton.
   • Set a new Administrator password, such as net user administrator newpwd.
   • Note the IP address of the DHCP server for the internal interface using

     ipconfig /all | grep 'DHCP Server' 
     

   • Change the directory

     cd /cygdrive/c
     

   • Use wget and the IP address noted above to obtain the current Windows Server exe from the grid controller. For example:

     wget http://ip-address:8080/download/Server_Windows-*.exe
     

   • Use the following to change permissions

     chmod 755 *.exe
     

   • Do not close the 3t shell.
3. Open the graphical console for the singleton and log in as Administrator.
   • Execute the installer by double-clicking the file SQL_Windows-*.exe in Windows Explorer.
4. In the ssh session, open on the singleton:
   • rm -f *.exe
   • Set a new complex Administrator password, such as net user administrator a3893hf092jfww.^JDFoi8hfwehohgw
   • Exit and then ssh back into the running singleton
   • rm -f ~/.bash_history
   • Exit
5. Access the GUI and select the application. The application displays in the Infrastructure Editor.
   • Click the Restart icon. This stops and restarts the application. The application updates the parameters, such as setting a random admin password, that were manually updated in the previous steps.
   • Click the Stop icon.
   • Drag the singleton to the user catalog.
6. Access the 3t shell and execute the following commands to destroy or archive the existing class:
   • To destroy the existing class

     class destroy /system_ms:SQL08S_08 --force  
     

   • To archive the existing class

     class move /user:SQL08S_08 /system_ms:SQL08S_08 
     

7. Access the GUI, then destroy the application that you created in step 1.