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
Note: If you did not create a ‘WSUS’ instance when you
installed MSDE and instead used the default instance or an already existing
instance, you may need to use one of the following commands in order to
successfully execute the script:
osql -E -S %COMPUTERNAME% -n -i patchPrerequisites.sql
osql -E -S -i patchPrerequisites.sql
osql -E -S %COMPUTERNAME%\<NAMED_INSTANCE> -n -i
patchPrerequisites.sql
QueryAnalyzer:
This script
can also be executed using the QueryAnalyzer (isqlw) on the SQL server machine.