What version of TFS data schema am I running?
In my previous TFS versioning post, we queried the TfsIntegration database to determine the TFS version. But does this match the data base schema on the data tier (DT)?
You can execute the following query against the TfsVersionControl database to verify that all is in order in the state of TFS:
SELECT SchemaVersion FROM tbl_repository.
Schema Version Description
--------------------------------------------------------------------
8.50517.00 Team Foundation Server (TFS) BETA 3 / BETA 3 Refresh
8.50815.00 Team Foundation Server (TFS) BETA 3 / BETA 3 Refresh
upgraded from BETA 2
8.51103.00 Team Foundation Server (TFS) Community Technology
Preview (CTP) December 2005 and TFS Release Candidate.
Warning: Although these two releases share the same
schema number, their schema is not the same.
8.50727.138 Team Foundation Server (TFS) Release to market (RTM)
8.50727.327 Team Foundation Server (TFS) Service Pack 1