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