Migrate Data and Update Commerce Server Schema
When migrating a site developed on an earlier version of Microsoft Commerce Server to Commerce Server 2009 R2, you must upgrade your site resources and the Administration database. The Commerce Server Upgrade Wizard migrates the existing global and site resources (including catalogs, orders, campaigns, marketing, and profiles data), and site data for Commerce Server sites you restored to Commerce Server 2009 R2.
Note
The Commerce Server Upgrade Wizard will only display information on global and site resources when an upgrade is necessary. Not all earlier versions of Commerce Server require migration for existing global and site resources.
When the upgrade process is complete, the Upgrade Wizard provides a list of resources that were not upgraded from your prerelease version. You must migrate these resources manually for them to function correctly.
To upgrade Commerce Server schema
If the Upgrade Wizard was not automatically launched at the end of the configuration, launch the Upgrade Wizard (click Start > All Programs > Microsoft Commerce Server 2009 R2 > Tools > Upgrade Wizard).
On the Welcome to the Upgrade Wizard page, click Next.
On the Select Options page, specify the path for the Commerce Server Upgrade Wizard log file, and click Next.
On the Upgrade Global Resources page, do the following:
For each global resource, use the arrow in the Action column to indicate whether the resource should be upgraded (using the Migrate option) or left untouched (using the Do Nothing option).
For information about the upgrade options for each global resource, see About Commerce Server 2000/2002 Global Resources.
If you want to skip migration of all global resources, select the Do not upgrade any global resources box.
Click Next.
On the Select a Commerce Site page, select the site(s) you want to migrate and click Next.
If you want to skip migration of all sites, select the Do not upgrade any sites box and click Next. Go to step 7.
On the Upgrade Site Resources page, do the following:
For each site resource, use the arrow in the Action column to indicate whether the resource should be upgraded (using the Migrate option) or left untouched (using the Do Nothing option).
For information about the upgrade options for each site resource, see About Commerce Server 2000/2002 Site Resources.
Click Next.
On the Marketing Configuration Settings page, select the default language (this is used to display basket information and the subject line of any e-mail messages sent by the Direct Mail service), and click Next.
On the Orders Configuration Settings page, do the following:
Specify a database schema definition file (or use the default file included in Commerce Server 2009 R2).
Specify a path for the exception log file (or use the default path).
(Optional) Select the Import orders/baskets from the exception log box to import orders that were previously logged to the exception log file and not migrated.
Click Next.
On the Upgrade Summary page, review your resource migration options. If you want to make any changes, click Back and change your selections. Otherwise, click Next.
The Upgrade Progress page appears and displays the status of your migration.
On the Completing the Upgrade Wizard page, click here to view the log file, or click Finish to close the Upgrade Wizard.
Next Steps
There are additional schema changes that the Upgrade Wizard does not automate. See Manual Schema Changes for more information.