I have an application that I'm developing in Visual Studio 2010 that utilizes a SQL Server database. As such, I am using a VS SQL Server 2008 Database Project.
The database project requires a target connection for which is used to build the database.
Problem:
This project is under source control for a team of developers and a build server. Some of the developers have their '08 SQL Server instance named whereas others have a default instance. The idea of just using 'local' syntax will not suffice.
I need the ability to configure the database project connection outside of source control. I see that the database project offers a SQL command variables files, is this what I'm after?
What is the best practice approach on accommodating this problem?
I'm using MSBuild as part of my build server - how might this approach fit in with MSBuild?