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

For details about working with database projects, see the following topics.

In This Section

• Database Projects
  Describes the Database Project template available from the New Project dialog box.
• Creating a Database Project
  How to create a new database project in Solution Explorer.
• Adding 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.
• Setting a Default Database Reference for a Database Project
  How to set the default database for a database project in Solution Explorer.
• Deleting 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.
• Running SQL Scripts in Solution Explorer
  How to run SQL scripts by dragging the script to a database reference.
• Creating and Deleting Command Files
  How to work with command files to run multiple SQL scripts.
• Exporting Data to a Database Project
  How to export data to your database project in Solution Explorer.

Related Sections

• Database Connections and Database References
  Describes similarities and differences between database connections in Server Explorer and database references in Solution Explorer.
• Projects and Solutions, Environment, Options Dialog Box
  Explains that by default, new projects are created in the location set in the Projects and Solutions, Environment, Options dialog box.