Upgrading a Commerce Server Final Preview Installation

This document provides instructions for upgrading your Commerce Server Final Preview installation to Commerce Server 2000. Commerce Server includes three upgrade programs that make the upgrade process fast and easy. These programs are available on the Commerce Server 2000 CD.

If you are using Commerce Server Final Preview for site development, you will not lose any code by upgrading to Commerce Server 2000. After you upgrade to Commerce Server 2000, your site will continue to operate normally. None of the data in your databases is affected by the upgrade.

Important   To upgrade a Commerce Server Beta installation to Commerce Server 2000, you must first upgrade your site from Commerce Server Beta to Commerce Server Final Preview, and then upgrade Commerce Server Final Preview to Commerce Server 2000. For instructions, see Upgrading a Commerce Server Beta Release Installation.

The following topics are addressed:

Overview of the Upgrade Process

  1. Back up your Business Desk application. Perform this step only if you have customized your Commerce Server Business Desk application.

  2. Run the RC0Export.vbs program. Perform this step only if you have custom Direct Mailer and Predictor resource property settings that you want to save.

  3. Uninstall Commerce Server Final Preview. If you have customized your BlankBizDesk application, your changes will be lost.

  4. 19Install Commerce Server 2000.

  5. Restart your computer.

  6. Run the cs2kRTMUpgrade.exe program. Run this program to upgrade your tables and stored procedures.

  7. Run the RTMImport.vbs program. Perform this step only if you exported custom Direct Mailer and Predictor resource property settings using the RTMExport.vbs program.

  8. Run the DTS report preparation task. Run this task to re-process and reconnect to the online analytical processing (OLAP) server cubes for the Analysis reports.

  9. Remove references to the UserType dimension from static reports based on the Campaign cube. Perform this step only if you created custom static reports that use the Campaign cube and the UserType dimension.

  10. Unpack the BlankBizDesk application. This replaces your existing Commerce Server Final Preview Business Desk application with updated Business Desk pages. Perform this step even if you are using a Business Desk application from a Retail Solution Site package or Supplier Solution Site package.

  11. Install the new Business Desk client (.hta).

Note   After you perform these steps, you cannot use Business Desk to view saved static reports that you created using the Commerce Server Final Preview installation. However, the physical files still exist, and you can rerun the reports using Commerce Server Final Preview data.

Upgrade Programs

You use the following programs during the process of upgrading your Commerce Server Final Preview installation to Commerce Server 2000. These programs are available on the Commerce Server 2000 CD.

  • RC0Export.vbs and RTMImport.vbs. If you have custom Direct Mailer and Predictor resource property settings that you entered in Commerce Server Manager, use the RC0Export.vbs program to export your property settings. After you install Commerce Server 2000, use the RC0Import.vbs program to import the property settings. You do not need to use these programs if you do not have custom Direct Mailer and Predictor property settings.

    If you need to run the RC0Export.vbs and RTMImport.vbs programs, then you must run both programs on the same computer, and the resources must be installed on that computer. For example, you cannot run the RC0Export.vbs program on Server1 and then run the RTMImport.vbs program on Server2. In addition, you cannot run the RC0Export.vbs program on Server1 if Direct Mailer is installed on Server2.

  • cs2kRTMUpgrade.exe. Use this program to upgrade stored procedures and database tables. When the cs2kRTMUpgrade.exe program upgrades procedures, it creates a backup of the original stored procedure. For example, if the procedure sp_Proc1 is upgraded, a backup procedure is created and named sp_Proc1_cs2k_backup_1.

The following table lists the changes made by the cs2kRTMUpgrade.exe program.

Resource Database Changes
Product Catalog Updates the following procedures associated with each catalog:
  • sp_DropCatalogProcedures

  • sp_CreateCatalogProcedures

  • sp_GetProductsForCatalog

  • sp_RemoveDefinitionFromCatalog

For each catalog, adds the new procedure sp_DeleteProduct_for _CatalogName.

App Default Config Changes the Description Column in the Resources table in the Administration database from "Site Options" to "App Default Config."

Changes the flag f_resourceflags for Commerce Server Business Desk in the Resources table in the Administration database from 10 to 522.
Profiles In the DisplayName and Description columns in the MemberDef table, the entries for "Partner desk role flags" are changed to "Partner service role flags."

In the DisplayName and Description columns in the ColDef table, the entry for "Partner desk role" is changed to "Partner service role."
Transactions The KeyField value in the Transdimension table is set to 1 if the CategoryName = OrderFormLineItems and DimensionName is (product_id, product_variant_id, Product_catalog_base).
Transaction Config Adds the following countries to the Region table: Korea, Taiwan, and China.

Changes the code of United Kingdom in the u_Name field from UK to GB.
Data Warehouse Updates stored procedures to improve performance and report content.

Updates the CSReport.SQL file to the latest report definitions.

Updates the dimensions defined in cubes.

Updates the structure of the cube file.

Steps to Upgrade Your Commerce Server Installation

Step 1: Back up your Business Desk application

Perform this step only if you have customized your Business Desk application. It is important that you make a copy so you can apply your custom changes to the Commerce Server 2000 Business Desk application.

Step 2: Run the RC0Export.vbs program

Perform this step only if you have custom Direct Mailer and Predictor resource property settings that you want to save. If you need to perform this step, note that Direct Mailer and the Predictor resource must be on the local computer. You cannot run the RC0Export.vbs program if one of the resources is installed on a different computer.

  1. Insert the Commerce Server 2000 CD into the appropriate disc drive.

  2. At the command prompt, navigate to the \support\RC0 upgrade folder on the CD.

  3. At the command prompt, type cscript RC0Export.vbs <drive:\><filename.txt>, where filename.txt is the name of the file to which you want to write the Direct Mailer and Predictor resource property settings. For example, you might type the following:

    cscript RC0Export.vbs C:\export.txt

Step 3: Uninstall Commerce Server Final Preview
  1. Expand Commerce Server Manager, expand Commerce Sites, and then expand the site you want to administer.

  2. Expand Applications, right-click <server name>/blankbizdesk, and then click Delete.

    The configuration data for the BlankBizDesk application is deleted from the Administration database.

  3. Click Start, point to Settings, point to Control Panel, and then click Add/Remove Programs.

  4. If you have installed the Commerce Server Solution Sites, in the Add/Remove Programs dialog box, select Commerce Server 2000 Solution Sites, and then click Remove.

    The Solution Site installer and packages are removed from your computer. Applications that you have already unpacked are not removed.

    If you have not installed the Solution Sites, go to the next step.

  5. In the Add/Remove Programs dialog box, select Commerce Server 2000, and then click Remove.

    The Commerce Server run-time objects, administration tools, Predictor resource, and Direct Mailer resource are removed from your computer.

  6. If you have installed the Commerce Server Business Desk client on this computer, in the Add/Remove Programs dialog box, select Commerce Server 2000 Business Desk, and then click Change/Remove.

    The Business Desk client is removed from your computer.

Step 4: Install Commerce Server 2000
Step 5: Restart your computer
  • If you did not restart your computer after installing Commerce Server 2000, do so now.
Step 6: Run the cs2kRTMUpgrade.exe program
  1. Use Windows Explorer to navigate to \Program Files\Microsoft Commerce Server 2000.

  2. Double-click the cs2kRTMUpgrade.exe program.

    The tables and stored procedures for the Commerce Server installation are upgraded. Each action is written to the application Event Viewer.

Step 7: Run the RTMImport.vbs program

Perform this step only if you used the RC0Export.vbs program to export custom Direct Mailer and Predictor resource property settings. You must perform this step on the same computer on which you ran the RC0Export.vbs program, and Direct Mailer and the Predictor resource must be installed locally.

  1. At the command prompt, navigate to the \support\RC0 upgrade folder on the CD.

  2. Type cscript RTMImport.vbs <drive:\><filename.txt>, where filename.txt is the name of the file that contains the Direct Mailer and Predictor resource property settings you want to import. For example, you might type the following:

    cscript RTMImport.vbs C:\export.txt

Step 8: Run the DTS Report preparation task
  1. Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

  2. Right-click Data Transformation Services, and then click New Package.

    Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.

  3. On the Task menu, click Report preparation (Commerce Server).

  4. In the Prepare Reports Properties dialog box, do the following:
    Use this To do this
    Description Type a description of the Reports preparation task.
    Site name Select the site for which you are populating the online analytical processing (OLAP) cubes.
    Full Select to process the OLAP cubes in their entirety. You must select full cube processing.

  5. Click OK.

  6. On the Package menu, click Execute.

    The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.

  7. Click OK, and then click Done.

The data is loaded into the OLAP cubes. You can now use the Commerce Server Business Analytics System, including Commerce Server reports, to analyze the data in the Data Warehouse.

Step 9: Remove references to the UserType dimension from static reports based on the Campaign cube

Perform this step only if you created custom static reports that use the Campaign cube and the UserType dimension. If you created custom dynamic reports that use the Campaign cube and the UserType dimension, the reports will run, but the PivotTable will not display the UserType data.

  1. Open the SQL script file you used to create the custom static report, and remove references to the UserType dimension.

  2. Run the updated SQL script file on the new Data Warehouse database to recreate the custom static report.
Step 10: Unpack the BlankBizDesk application

Perform this step to install the updated Commerce Server 2000 Business Desk pages. Perform this step even if you are using a Business Desk application included in the Retail or Supplier Solution Site packages. The BlankBizDesk application is the same as the Business Desk applications included in the Retail and Supplier Solution Sites. (You can also get the updated Business Desk pages by downloading a Commerce Server 2000 Solution Site package and unpacking the Business Desk application included in the package.)

  1. Click Start, point to Programs, point to Microsoft Commerce Server 2000, and then click Solution Sites.

  2. Double-click the Blank.pup package.

  3. In the Unpack dialog box, select Custom unpack, and then click Next.

  4. In the Unpack Method dialog box, select Add an application in the package to an existing site, and then click Next.

  5. In the Select Site dialog box, select the site to which you are adding the application, and then click Next.

  6. In the Select Applications dialog box, clear the BlankSite box, verify that the BlankBizDesk box is selected, and then click Next.

  7. In the Select IIS Web Sites and Virtual Directories dialog box, verify that the IIS virtual directory matches the current virtual directory for Business Desk, and then click Next.

  8. In the warning dialog boxes, click Yes. You will overwrite the existing virtual directory from your Commerce Server Final Preview installation.

  9. In the Unpacking is complete! dialog box, click Finish.

If you customized your Commerce Server Final Preview Business Desk application, you can now copy your customized code to the Commerce Server 2000 Business Desk application.

Step 11: Install the new Business Desk client (.hta)
  1. Uninstall the Commerce Server Final Preview Business Desk client from each client computer on which it is installed. For instructions, see Uninstalling the Business Desk Client.

  2. Install the new Commerce Server 2000 Business Desk client the next time you access the Business Desk application. For instructions, see Installing the Business Desk Client.


Last Reviewed: Wednesday, April 25, 2001