Microsoft® Visual Studio® 2010 Unleashed

Building and Deploying

The final item we haven’t covered is the actual act of updating a schema in a database with the schema in a database project. You use the familiar build-and-deploy paradigm leveraged by other Visual Studio project types. In the context of a database project, the build process parses all the SQL files and identifies any files that have SQL syntax errors. If the build is clean, the deployment actually updates the target database with the schema (or creates a new database if the target database doesn’t exist).

We specified the default target database when we ran through the initial project creation wizard. You can also change this information at any time by right-clicking on the project in the Solution Explorer window and ...