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
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.
At a command prompt, locate the %COMMERCE_SERVER_ROOT%\Upgrade directory.
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 OurSiteError messages will be displayed in the console window.
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 |