Export (0) Print
Expand All

Getting Started with Database Projects

Visual Studio 2005

Before you can put a database schema under version control, you must create a database project. This section contains topics that describe how you create the database project for a new or existing version-controlled database. This section also contains topics about tasks that you often perform before you begin development work on that database project. An example of these tasks is defining files and filegroups that you can later use in object definitions.

In This Section

An Overview of the New Database Project Wizard

Describes the New Database Project Wizard and gives you information about the settings it contains.

How to: Create Database Projects

Describes how to use the New Database Project Wizard to create a database project for an existing database and import the schema for that database into the database project.

How to: Create Empty Database Projects

Describes how to create a database project for use in creating a database.

How to: Import a Database Schema

Describes how to import database schema and object information into an empty database project.

Overview of Files and Filegroups

Provides background information about how to define files, filegroups, and log files in the database project. Information in this topic includes the limitations of those features.

How to: Add Files and Filegroups

Describes how to add files, filegroups, and log files to the database project. This topic also describes limitations when you delete files, filegroups, and log files.

How to: Define Variables for Database Projects

Describes how to define the variables that are used in the definitions of files, filegroups, and log files. By defining files and filegroups in terms of variables, you can have different file names and paths in different deployments.

Related Sections

Working with Database Objects

Provides an overview of the tasks you can perform to work with database objects such as tables, views, and stored procedures.

How to: Create a Database Object

Describes how to add a new database object to your database project.

How to: Modify Database Objects

Describes how to update a database object definition within your database project.

Working with Database Scripts

Contains topics that give you information about how you can add deployment or management scripts to your database project.

Terminology Overview of Team Edition for Database Professionals

Defines terms used in Visual Studio Team Edition for Database Professionals.

Show:
© 2014 Microsoft