Data Migration of Commerce Server 2000/2002 Global Resources

Commerce Server 2000 and Commerce Server 2002 each include the following global resources: Authentication, the Data Warehouse, Predictor, Direct Mailer, and Profiles. The Data Warehouse and Direct Mailer are not modified by the Upgrade Wizard, and Predictor has been removed from Commerce Server 2007. Commerce Server 2007 uses the Windows Server 2003 Authorization Manager security model to set permissions for business user roles. With role-based access control, you can specify the access control according to the organizational structure of your company. For more information about Authorization Manager, see https://go.microsoft.com/fwlink/?LinkId=46748 on the Microsoft TechNet Web site.

This topic discusses the migration options for each global resource.

Note

You can remove nonessential data after you complete the migration of your Commerce Server site. For more information, see Post Migration Data Management.

Authentication

The Upgrade Wizard lets you either migrate the Authentication resource or leave it as is (the Do Nothing option).

Data Warehouse

Although there have been changes to the Commerce Server 2007 Data Warehouse, the Upgrade Wizard only gives you the option to leave the resource as is (the Do Nothing option). Use the DWUpdateDimension.wsf and DWUpdateTables.wsf scripts to convert this data. For more information, see Data Warehouse Update Dimension Tool, and Data Warehouse Update Tables Tool.

The Commerce Server 2007 Data Warehouse schema has changed significantly from that of Commerce Server 2000. Use the Data Warehouse Migration Tool to convert the Data Warehouse resource to the required state before migration.

Predictor

The Upgrade Wizard lets you either remove this resource or leave it as is (the Do Nothing option). If you select Do Nothing, the resource is left in the site for reference. However, you cannot run it with Commerce Server 2007, because it is no longer part of the product.

Direct Mail

In Commerce Server 2007, no changes are made to the Direct Mail resource. The Upgrade Wizard only gives you the option to leave the resource as is (the Do Nothing option).

Profiles

The Upgrade Wizard lets you either migrate this resource or leave it as is (the Do Nothing option).

In Commerce Server 2000 and 2002, you created and managed Profiles in Business Desk. Business Desk was removed from Commerce Server 2007, and Profiles are now managed in the Customer and Orders Manager and in the Commerce Server Manager snap-in. The Customer and Orders Manager uses Authorization Manager for its role assignment.

Some profile definitions that were included with Commerce Server 2000 and 2002 have properties that might be displayed with a non-standard user interface in the Customer and Orders Manager user interface. To display the default Commerce Server 2007 user interface in the Customer and Orders Manager, properties must meet these criteria:

  • Profile properties that have a Type Reference that points to a site term must be set to the Site Term type.

  • Profile properties that have a Type Reference that points to a profile must be set to the Profile type.

If the Type for these properties is set to anything other than Site Term or Profile, the Customer and Orders Manager will not display the property as a combo box that contains the possible site term values. Instead, only a user-editable text box will be displayed. You can save values for these properties, but the Customer and Orders Manager will not validate the value that you have entered. (New sites created by using the Commerce Server 2007 PUP packages are not affected by this issue.)

The following is a list of profile properties from prior versions of Commerce Server that show this behavior:

  • Address.GeneralInfo.id

  • Address.GeneralInfo.user_id_changed_by

  • BlanketPOs.GeneralInfo.org_id

  • BlanketPOs.GeneralInfo.user_id_changed_by

  • Organization.GeneralInfo.user_id_admin_contact

  • Organization.GeneralInfo.user_id_receiver

  • Organization.GeneralInfo.user_id_changed_by

  • Organization.Purchasing.user_id_purchasing_manager

  • UserObject.GeneralInfo.user_type

  • UserObject.GeneralInfo.user_id_changed_by

  • UserObject.AccountInfo.org_id

  • UserObject.AccountInfo.account_status

  • UserObject.BusinessDesk.partner_desk_role

See Also

Other Resources

Data Migration to Commerce Server 2007