Code-First Database Creation During TFS 2010 CI Build

Posted by jedimindtrickster on Server Fault See other posts from Server Fault or by jedimindtrickster
Published on 2012-10-02T16:12:09Z Indexed on 2012/10/05 9:39 UTC
Read the original article Hit count: 234

Filed under:

configuration

|

team-foundation-server

|

tfs2010

|

continuous-integration

I would like to automate code-first database generation during the automated CI build of a web project in Team Foundation Server 2010.

When run locally the tests create a code-first database specified by the connection string in the app.config of the tests project. How do I configure the TFS Build Configuration to mimic this behaviour on the TFS build server?

Edit

The problem, it turns out, was that the TFS build server was successfully running the test which was using the default connection string in the app.config which pointed to the local SQL Server, not where I expected it.

The solution was to use SlowCheetah on the TFS server as a means to transform the App.config file using the QA transform as per this blog article.

© Server Fault or respective owner

Related posts about configuration

SSIS Configuration error: Cannot retrieve configuration table schema

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to add a simple configuration to a SSIS package, of type SQL Server, so stored in a table. At the end of the wizard, when it goes to try and write a new row to the nominated table to store the configuration it fails with the error: TITLE: Microsoft Visual Studio Could not complete wizard… >>> More
SharePoint: Can't Connect to a Configuration Database When Using Configuration Wizard

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone. I wonder if you could help me with the following problem: We have a SharePoint farm consisted of two servers with an NLB (a load balancer), a database server and an index server (4 servers in total). The issues initially appeared when we were trying to change Search settings via Shared… >>> More
Module configuration and layout configuration in zend framework.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I got some codes from other articles for configuring module and layout in zend framework. I tried with in my local. i didn't get different layout for default and admin module. Here is my code for configuring module and layout for zend framework. configs/application.ini [production] #… >>> More
Xml configuration versus Annotation based configuration

as seen on Stack Overflow - Search for 'Stack Overflow'
In a few large projects i have been working on lately it seems to become increasingly important to choose one or the other (XML or Annotation). As projects grow, consistency is very important for maintainability. My question is, what do people prefer. Do you prefer XML based or Annotation based… >>> More
Creating packages in code - Package Configurations

as seen on SQLIS - Search for 'SQLIS'
Continuing my theme of building various types of packages in code, this example shows how to building a package with package configurations. Incidentally it shows you how to add a variable, and a connection too. It covers the five most common configurations: Configuration File Indirect Configuration… >>> More

Related posts about team-foundation-server

Mercurial Conversion from Team Foundation Server

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I’m using Twitter. Follow me @matthawley One of my many (almost) daily tasks when working on the CodePlex platform since releasing Mercurial as a supported version control system, is converting projects from Team Foundation Server (TFS) to Mercurial. I'm happy to say that of all the conversions… >>> More
Generate automated builds for source code from multiple branches using Team Foundation Server and Te

as seen on Code Project - Search for 'Code Project'
Generate automated builds for source code from multiple branches using Team Foundation Server and Team Builds >>> More
[Visual Studio Extension Of The Day] Test Scribe for Visual Studio Ultimate 2010 and Test Professional 2010

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Test Scribe is a documentation power tool designed to construct documents directly from the TFS for test plan and test run artifacts for the purpose of discussion, reporting etc... . Known Issues/Limitations Customizing the generated report by changing the template, adding comments,… >>> More
Visual Studio 2013 Static Code Analysis in depth: What? When and How?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I'll illustrate in details the following points What is static code analysis? When to use? Supported platforms Supported Visual Studio versions How to use Run Code Analysis Manually Run Code Analysis Automatically Run Code Analysis while check-in source… >>> More
Overwriting TFS Web Services

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this blog I will share a technique I used to intercept TFS Web Services calls. This technique is a very invasive one and requires you to overwrite default TFS Web Services behavior. I only recommend taking such an approach when other means of TFS extensibility fail to provide the same functionality… >>> More