Have you ever wanted to load different reference data into your Visual Studio 2010 database project based on Project Configuration?

I found a great thread exposing how to do this. (Thank you Kuris01)  I’ll add a couple of screenshots from my experience.

This is the UI for adding SQL Command Variables:

This is the bottom of the Unloaded Database.dbproj where I added the ItemGroup:

Sure beats the heck out of what I used to do which was have unique .sqlcmdvars for each build configuration!