Share via


Data Warehouse Migration Tool

Use the Data Warehouse migration tool to migrate the Data Warehouse resource from sites that were created by using Commerce Server 2000 to Commerce Server 2007. The Data Warehouse migration tool compares the schema from the Commerce Server 2000 Data Warehouse, with that of Commerce Server 2007, makes the necessary changes to the new schema, and then copies the data to the new Data Warehouse. In-place migration (where the source and destination connection strings are the same) is not supported.

Note

There are no Data Warehouse schema changes from Commerce Server 2002 to Commerce Server 2007, so you do not have to run the Data Warehouse migration tool on Commerce Server 2002 Data Warehouses.

To migrate a Data Warehouse resource

  1. Unpack a Commerce Server 2007 Data Warehouse. This will be the destination Data Warehouse that you will use later in this procedure. For more information, see How to Unpack the Data Warehouse Resource.

  2. At a command prompt, locate the %COMMERCE_SERVER_ROOT%\Upgrade directory.

  3. Run the DWMigrate.wsf script. The following example shows the syntax used to migrate a Data Warehouse:

    DWMigrate.wsf /src_server OurSourceServer /src_db OurSourceDB /src_catalog OurSourceCatalog /dst_server OurDestinationServer /dst_db OurDestinationDB /dst_catalog OurDestinationCatalog /site OurSite
    

    Error messages will be displayed in the console window.

  4. If performing a new install of Commerce Server 2007 and applying SP1 before installing a PuP file, some changes to the MSCS_Admin database will not be made. To resolve this issue run the following command at a command prompt to update the MSCS_Admin database:

    CSConfig.exe /r Feature.MS.CS.Admin
    

The full set of parameters for DWMigrate.wsf are as follows:

Option

Description

Required

/src_server

Specifies the name of the source SQL server.

/src_server<server>

REQUIRED

/src_db

Specifies the name of the source SQL database.

/src_db<database>

REQUIRED

/src_catalog

Specifies the source Data Warehouse catalog name.

/src_catalog<catalog name>

REQUIRED

/src_userid

Specifies the source SQL server user id.

/src_userid<user id>

OPTIONAL

/src_password

Specifies the source SQL server password.

/src_password<password>

OPTIONAL

/dst_server

Specifies the destination SQL server.

/dst_server<server>

REQUIRED

/dst_db

Specifies the destination SQL database.

/dst_db<database>

REQUIRED

/dst_catalog

Specifies the destination Data Warehouse catalog name.

/dst_catalog<name>

REQUIRED

/dst_userid

Specifies the destination SQL server user id.

/dst_userid<user id>

OPTIONAL

/dst_password

Specifies the destination SQL server password.

/dst_password<password>

OPTIONAL

/site

Specifies the site that is associated with the data warehouse.

/site<site>

REQUIRED

/generate_log

Generates a log of the schema changes.

/generate_log

OPTIONAL

/migrate_data

Migrates the data.

/migrate_data

OPTIONAL