Upgrade a Distributed Installation

In an upgrade of a distributed installation of UDDI Services, upgrade the UDDI Services Database first and then upgrade the UDDI Services Web Application server.

• If your UDDI Services database is running on a SQL Server failover cluster, see Upgrade a Distributed Installation Running a SQL Server Failover Cluster

Upgrading the UDDI Services Database (not clustered)

During the upgrade process, you uninstall all non-Windows applications—including SQL Server—and then reinstall them after the upgrade.

Membership in Administrators, or equivalent, is the minimum required to complete the upgrade. Review details about using the appropriate accounts and group memberships at https://go.microsoft.com/fwlink/?LinkId=83477.

To upgrade the UDDI Services Database

1. Upgrade the Windows Server 2003 operating system to the corresponding edition of Windows Server 2008.

2. Install an appropriate version of SQL Server 2005.

3. Click Start, right-click Command Prompt, and then click Run as administrator.

4. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

5. At the command prompt, run the Universal Description, Discovery, and Integration (UDDI) upgrade tool by typing the appropriate command in the following list, depending on your system configuration.

   Command, with example	Configuration and instructions
   uddiupgrade.exe	SQL Server is the default database instance on the computer, and UDDI Services is installed in the default location in Windows Server 2003 (%systemdrive%\inetpub\uddi). At a command prompt, type the command, and then press ENTER.
   uddiupgrade.exe /sqlsvr:UDDISVR\UDDI	SQL Server is not the default database instance on the computer. Type the command, and then enter the instance name. For example, if the local computer name is UDDISVR and the SQL Server instance name is UDDI, type the command as in the example, and then press ENTER.
   uddiupgrade.exe /dbfile:d:\uddi\data\uddi.sys.mdf	In the Windows Server 2003 operating system, UDDI Services is not installed in the default location (%systemdrive%\inetpub\uddi). Type the command, and then enter the full path of the database file uddi.sys.mdf, which is typically located in the \data folder under the UDDI Services installation folder. For example, if UDDI Services was installed at d:\uddi in Windows Server 2003, type the command as in the example, and then press ENTER.

Upgrading the UDDI Services Web server

Membership in Administrators, or equivalent, on the local Web server and on the remote UDDI Services Database server is required to complete this procedure. Review details about using the appropriate accounts and group memberships at https://go.microsoft.com/fwlink/?LinkId=83477.

To upgrade the UDDI Services Web server

1. Upgrade the Windows Server 2003 operating system to the corresponding edition of Windows Server 2008.

2. Click Start, right-click Command Prompt, and then click Run as administrator.

3. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue.

4. At the command prompt, type the following command, and then press ENTER:

   uddiupgrade.exe
   

Parameter	Description
Uddiupgrade.exe	Upgrades UDDI Services as part of an operating system upgrade.
Uddiupgrade.exe /wid	Upgrades UDDI Services using the Windows Internal Database.
Uddiupgrade.exe /sqlsvr	Upgrades UDDI Services using a named SQL Server instance.
Uddiupgrade.exe /dbfile	Upgrades UDDI Services by specifying the full path of the old UDDI database file. Only necessary if UDDI Services was installed in a non-default location in Windows Server 2003 because you cannot specify a different database file location for the upgrade. The default location is %systemdrive%\inetpub\uddi.

Additional considerations

To open an elevated Command Prompt window, click Start, point to All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.