Export (0) Print
Expand All

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.
Show:
© 2014 Microsoft