ReadMe for Windows Server Update Services RC to WSUS Final Release Upgrade Script

The final release of WSUS allows migration from a WSUS RC server. After you upgrade from the RC version, you will need to run the upgrade script to address compatibility issues between the RC and RTM releases.

If you are upgrading from the RC to the release version of Windows Server Update Services, download this cab to the server where the WSUS database is located and extract the script using the below command. Run this script after you have upgraded to the released version of Windows Server Update Services. This script is provided AS IS. No product support is available for this script.

Downloading the Upgrade Script .CAB file

Download the upgrade script .cab file to a directory on the WMSDE/MSDE or full SQL server system machine.

Extracting the SQL script from the downloaded cab:

To extract this script from the cab open a command prompt and in the same directory where the cab was downloaded type:

expand wsusdbfix.cab patchPrerequisites.sql

Executing the upgrade script: (executing the upgrade script requires the osql tool which can be found in Program Files\Update Services\Tools\osql folder, be in the path or specified on the command line for the following commands)

Full version SQL Server 2000:

To execute this script on servers running SQL Server 2000, open a command prompt and in the same directory where the patch was extracted type:

osql -E -n -i patchPrerequisites.sql.

MSDE or WMSDE

To execute this script on servers running MSDE or WMSDE, open a command prompt and in the same directory where the patch was extracted type:

osql -E -S %COMPUTERNAME%\WSUS -n -i patchPrerequisites.sql.

QueryAnalyzer:

This script can also be executed using the QueryAnalyzer (isqlw) on the SQL server machine.