Visual Studio Team System
SetupWarehouse

Use SetupWarehouse to rebuild the online analytical processing (OLAP) or the relational databases.

The SetupWarehouse command-line utility is located in Drive:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools on Team Foundation Server application tier.

NoteNote:

Even if you are logged on with administrative credentials, you must open an elevated Command Prompt to perform this function on a server that is running Windows Server 2008. To open an elevated Command Prompt, click Start, right-click Command Prompt, and click Run as Administrator. For more information, see the Microsoft Web site.

Required Permissions

To use the SetupWarehouse command, you must be a member of the sysadmin security group for the SQL Server on the Team Foundation data-tier server. For more information, see Team Foundation Server Permissions.

SetupWarehouse [-v] [-o] -s ServerName -d Database -c ConfigFile -a AccountName -ra DataReaderAccountName [-l LogFile] [-mturl MidTierUrl] [-edt TeamBuildDbName] -rebuild
Parameters

Option / Argument

Description

-v

Optional. This option provides verbose output. If the -l option is specified, the output is written to the log file.

-o

Required. When this option is used, only the OLAP database is created. Only the warehouse cube is rebuilt.

-s ServerName

Required. The data-tier server name.

-d Database

Required. The warehouse database name.

-c ConfigFile

Required. The warehouse schema configuration XML file.

-a AccountName

Required. The service account name. In domain \user format.

-ra DataReaderAccountName

Required. The reader account name. In domain\user format.

-l LogFile

Optional. Log file for output.

-mturl MidTierUrl

Required. The URL of the Team Foundation Server domain, for example, http://machine1:8080.

-edt TeamBuildDbName

Required. The name of the Team Foundation Build database.

-rebuild

Required. Forces the warehouse database to be rebuilt. This repopulates all the data in the warehouse.
Remarks

The Team Foundation Server warehouse has a relational database and an OLAP database. Setupwarehouse, Team Foundation Server's warehouse setup tool, can be used to rebuild the OLAP database or the relational database. This is useful in backup/restore scenarios, for example, disaster recovery, moving servers, etc. For more information, see How to: Restore Data for Team Foundation.

Supported Usage

The supported combinations for Setupwarehouse.exe are:

  • Rebuilding OLAP (options -v and -l are optional): 

    Setupwarehouse -o -s ServerName -d TFSWarehouse -c warehouseSchema.xml -mturl "http://ServerName:Port" -a TFSServiceAccount -ra TFSReportAccount

  • Rebuilding the database(options -v and -l are optional):

    setupwarehouse -rebuild -mturl "http://ServerName:Port" -s ServerName -d TFSWarehouse -c wareHouseSchema.xml -a TFSServiceAccount -ra TFSReportAccount -edt TfsBuild
Example

Running the following command rebuilds the Analysis Services data cube from the underlying TFSWarehouse database.

> setupwarehouse -o -s ServerName -d TFSWarehouse -c warehouseschema.xml -a TFSServiceAccount -ra TFSReportAccount
See Also

Reference

Command-Line Syntax (Team System)

Other Resources

Managing Data
Using Team Foundation Server Command-Line Tools
Tags : davidwinarno


Community Content

Gabriel Lozano-Moran
Do not delete the \data\ folder in "To delete the version control cache"

To delete the version control cache

In step 2 you are asked to delete the data folder. I do not recommend this because you will then get unauthorized exception errors in the event logs for the user account used for the Team Foundation Server services. Instead empty the folder. If you have deleted the data folder, recreate the data folder and grant the local group TFS_APPTIER_SERVICE_WPG both Read and Write permissions.

Tags : contentbug

Markus Schiller
Install of Analysis Services fails with DS_Name_Error_Domain_Only

If you install the Analysis Services on an other server than the Data Tier the setup may fail with the error DS_Name_Error_Domain_Only. I resolved the issue by adding the user (normaly the TFS service user) in the msiproperty.ini file under VSTF_AS_ACCOUNT.


Bill.Wang
Side effects of rebuilding the warehouse relational store.

In Orcas, warehouse adapters never remove data from the warehouse relational store. You might destroy a version control file, destroy a work item, delete some builds. Those operation only affect the operational store. So the deleted information still shows up reports against the warehouse. Rebuilding the warehouse will generate warehouse data from scrach. Information such as deleted work items will be lost.

Tags :

jstclair
Rebuilding Cube example syntax is wrong
The second example section's syntax is missing the required -mturl parameter. The example should actually be:

setupwarehouse -o -s ServerName -d TFSWarehouse -c warehouseschema.xml -a TFSServiceAccount -ra TFSReportAccount -mturl "http://ServerName:Port"
Tags : contentbug

Page view tracker