Migrate Data Warehouse Resources

  • Article

The Microsoft Commerce Server Upgrade Wizard does not migrate any Data Warehouse resources. However, you can use the Data Warehouse tools to do the following:

  • Migrate Data Warehouse Resources (Commerce Server 2000 Only)

  • Update Data Warehouse Dimension Tables

  • Update Data Warehouse Tables

Migrate Data Warehouse Resources (Commerce Server 2000 Only)

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 2009 R2. The Data Warehouse migration tool compares the schema from the Commerce Server 2000 Data Warehouse with that of Commerce Server 2009 R2, 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 2009 R2. You do not have to run the Data Warehouse migration tool on Commerce Server 2002 and onward.

You must run the Data Warehouse Migration tool in 32-bit mode.

To migrate a Data Warehouse resource from Commerce Server 2000

  1. Unpack a Commerce Server 2009 R2 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. Open a 32-bit Command Prompt window.

    From the Start menu, select Run to open the Run dialog. Type %windir%\SysWoW64\cmd.exe in the Open field and press Enter.

  3. In the Command Prompt window, navigate to the <Commerce Server Root>\Upgrade directory.

  4. 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

    Any error messages will be displayed in the console window.

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

Option

Description

Required

/src_server

Specifies the name of the server where the source SQL Server is installed.

/src_server<server>

REQUIRED

/src_db

Specifies the name of the source SQL Server 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 name of the server where the destination SQL Server is installed.

/dst_server<server>

REQUIRED

/dst_db

Specifies the destination SQL Server 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

Update Data Warehouse Dimension Tables

Use the Data Warehouse Update Dimension tool to migrate the Data Warehouse dimension tables to Commerce Server 2009 R2. 

You must run the Data Warehouse Update Dimension tool in 32-bit mode.

To update Data Warehouse dimension tables

  1. Open a 32-bit Command Prompt window.

    From the Start menu, select Run to open the Run dialog. Type %windir%\SysWoW64\cmd.exe in the Open field and press Enter.

  2. In the Command prompt window, navigate to the <Commerce Server Root>\Upgrade directory.

  3. Run the DWUpdateDimension.wsf script using the following syntax:

    DWUpdateDimension.wsf <name of analysis server> <name of database>

    Any error messages are displayed in the console window.

Update Data Warehouse Tables

Use the Data Warehouse Update Tables tool to migrate the Data Warehouse tables to Commerce Server 2009 R2.

To update Data Warehouse tables

  1. Open a 32-bit Command Prompt window.

    From the Start menu, select Run to open the Run dialog. Type %windir%\SysWoW64\cmd.exe in the Open field and press Enter.

  2. In the Command Prompt window, navigate to the <Commerce Server Root>\Upgrade directory.

  3. Run the DWUpdateTables.wsf script using the following syntax:

    DWUpdateTables.wsf <name of server> <name of database> [<userid> <password>]

    Any error messages are displayed in the console window.