VS2010 Database Project with Multiple Deployments

Question

I have a database project in my vs2010 solution. The working database is installed locally on my machine. I'm wondering if there is a way to setup the project so that it can deploy to multiple databases? (i.e., per build configuration like a 'QA' version and a 'Production' version)

Thanks

Answer 1

You can create multiple configuration files by opening Properties window for Database project and adding new Deployment configuration file.

You can specify different files for each Configuration, ie. Debug can deploy to localhost, and Release to test environment.