Moving the Contents of the Data Warehouse

  • Article

This section explains the process of physically moving your Data Warehouse from one computer (or set of computers) to another. The Data Warehouse includes both the SQL Server database (by default, this database is named <site name>_dw) and the OLAP database used for reporting.

Moving the Data Warehouse Database

Moving the Analysis Database

Updating the Data Warehouse Connections

Moving DTS Packages

Cross Domain Computer Configurations

Moving the Data Warehouse Database

There are four steps to moving the Data Warehouse database:

  1. Detach the database.
  2. Copy the database files.
  3. Paste the database into the new location.
  4. Attach the database.

Ee797074.important(en-US,CS.20).gifImportant

  • Before you move a SQL Server database, make sure you do not have any tasks scheduled to run at that time in the SQL Scheduler.

To detach a SQL Server database

  1. In Commerce Server Enterprise Manager, expand Microsoft SQL Servers, expand a server group, and then expand a server.
  2. Expand Databases, right-click the database you want to move, and click Properties.
  3. In the <database> Properties dialog box, on the Data Files tab, in the Database Files section, in the Location column, read the full path of where the <site name>_dw database files are stored on your hard drive. Write down the location of both the .mdf and the .ldf files.
  4. Click OK to close the Properties dialog box.
  5. Right-click the database you want to move, point to All Tasks, and then click Detach Database.
  6. In the Detach Database - <database> dialog box, check the Database status section to make sure that there is no current database activity or connections using the database.
  7. Click OK to complete the detach process, and click OK again to close the confirmation box.

To copy a SQL Server database

  1. On your desktop, right-click My Computer, and then click Explore.
  2. In the My Computer browser window, navigate to the location of the <site name>_dw file.
  3. Copy the following files to the media you will use to move them to the new location:
    • <site name>_dw.mdf
    • <site name>_dw.ldf

Ee797074.note(en-US,CS.20).gifNote

  • The Data Warehouse requires both the files <site name>_dw.mdf and <site name>_dw.ldf.

To paste the SQL Server database on the new computer

  1. On the destination computer desktop, right-click My Computer, and then click Explore.
  2. In the My Computer browser window, navigate to the location where you want to paste the database files, and then paste the database files (<site name>_dw.mdf and <site name>_dw.ldf) into the new location.

To attach the database on the new computer

  1. In Commerce Server Enterprise Manager, expand Microsoft SQL Servers, expand a server group, and then expand a server.
  2. Right-click Databases, point to All Tasks, and then click Attach Database.
  3. In the Attach Database dialog box, type the location of the .mdf file of the database you are attaching.
  4. In the Original File Name(s) column, verify that both the .mdf and the .ldf files for the database are listed.
  5. In the Attach as box, verify the name of the database.
  6. Click OK to attach the database, and click OK a second time to close the confirmation box.

Moving the Analysis Database

There are three steps to moving the Analysis Database:

  1. Archive the analysis database.
  2. Restore the analysis database into the new location.
  3. Process the virtual cubes.

To archive the analysis database

  1. In Commerce Server Enterprise Manager, expand Microsoft SQL Servers, expand Analysis Servers, expand a server group, right-click the analysis database you want to move, and then click Archive Database.
  2. In the Archive Database dialog box, in the Save In box, type the location to which you want to save the archived database. Write down the location.
  3. Click Archive.
  4. In the Archive Database Progress dialog box, click Close.

To restore the analysis database on the new computer

  1. In Commerce Server Enterprise Manager, expand Microsoft SQL Servers, expand Analysis Servers, expand a server group, right-click the node of the local computer where you want to add the analysis database, and then click Restore Database.
  2. In the Open Archive File dialog box, navigate to the location to which you archived the analysis database, select the .cab file you originally selected as the archive file for your analysis database, and then click Open.
  3. In the Restore Database dialog box, click Restore to complete the restore process.
  4. In the Restore Database Progress dialog box, click Close.

After you restore the analysis database, you must process the virtual cubes.

To process the virtual cubes

Ee797074.note(en-US,CS.20).gifNote

  • You must individually process all virtual cubes to complete the move.
  1. In Commerce Server Enterprise Manager, expand Microsoft SQL Servers, expand Analysis Servers, expand a server group, expand Cubes, and then right-click the virtual cube you want to process.
  2. In the Process a Cube dialog box, click OK to process the cube.
  3. In the Process dialog box, click Close.

Copyright © 2005 Microsoft Corporation.
All rights reserved.