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 ...

Get Microsoft® Visual Studio® 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.