Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft