Is there a command line to deploy a Sql Server Database project?

Question

We are using the SQL Server Database project template with VS 2010. As part of our integration testing, I would like to first launch a fresh deploy of the database. But short of manually right clicking the project and picking "Deploy" It doesn't seem to be a simple thing to get a fresh copy of the database deployed.

The documentation for this project type seems sparse to non-existant. Perhaps I"m looking in the wrong place. If possible, please include a reference to the how-to.

Update: Our integration tests are written as unit tests in Visual Studio. So the goal would be to press the Run Tests button, and have the database deploy, and then the tests against it run.

Answer 1

For a fresh database instance (not an incremental update to a database), MSDeploy should do the trick. Here's a quick post I found on the subject. I haven't actually done it myself yet, but a collegue says it's worked in his environment.