SetupWarehouse

SetupWarehouse

Switch on low bandwidth view

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

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.

Note:
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

Reference

Command-Line Syntax (Team System)

Other Resources

Managing Data

Using Team Foundation Server Command-Line Tools

Tags

: davidwinarno (x) Add a tag

Community Content

Add new content

Annotations

Do not delete the \data\ folder in "To delete the version control cache"

Gabriel Lozano-Moran | Edit | Show History

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 (x) Add a tag

Install of Analysis Services fails with DS_Name_Error_Domain_Only

Markus Schiller | Edit | Show History

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.

Tags

: analysis (x) ds_name_error_domain_only (x) services (x) setup (x) tfs (x) Add a tag

Flag as ContentBug

Side effects of rebuilding the warehouse relational store.

Bill.Wang | Edit | Show History

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

: Add a tag

Flag as ContentBug