Working with Database Projects
You can create database projects in Solution Explorer to store database references, run SQL scripts and queries, and use command files to run multiple SQL scripts.
The Database Project template creates the following folders in Solution Explorer:
Change Scripts
Change scripts record a series of modifications you intend to make to selected database tables. They are useful because they can be run at another time if you do not have security permissions to alter a database or if you are not ready to update the database. For more information, see How to: Generate Change Scripts.Create Scripts
Create scripts recreate the schema of a database. For more information, see How to: Generate Create Scripts.Queries
Queries retrieve, create, modify, or delete data in a database. For more information, see Designing Queries and Views.Database References
Each database reference contains connection information to a database and is saved as part of the project. A database project can have multiple database references. For more information, see How to: Add a Database Reference to a Database Project.
For details about working with database projects, see the following topics.
In This Section
How to: Create a Database Project
How to create a new database project in Solution Explorer.How to: Add a Database Reference to a Database Project
How to add a database reference in Solution Explorer and establish the associated database connection in Server Explorer.How to: Delete a Database Reference from a Database Project
How to delete a database reference in Solution Explorer and remove the associated database connection from Server Explorer.How to: Set a Default Database Reference for a Database Project
How to set the default database for a database project in Solution Explorer.How to: Add SQL Scripts to a Database Project
How to use Server Explorer to add a new SQL script to a database project.
See Also
Concepts
Database Connections and Database References