Wikis - Page Details

First published by JoeyDj (2Microsoft Partne)
When: 7 Nov 2011 8:18 PM
Last revision by Richard Mueller (cMVP, Microsoft Community Contributo)
When: 20 Sep 2013 5:04 PM
Revisions: 14
Comments: 4

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

Visual Studio 2011 - Database Project for DBA

This is a draft

Introduction

Database, just like any system design undergoes several stages of development.
This is known as DBLC or Database Development Life cycle. Microsoft Develop the "database
project" to manage DBLC. In this article we will look at database project in Visual Studio 2011 to
develop, design and deploy database.

Microsoft Visual Studio 2011 id available for download from this link

This is a draft
Introduction
Related Articles
Building A Database Project
Inspecting Project Properties

For more information on DBLC you can consult this wikipedia link.
MSDN article for "Database Project" for Visual Studio 2010 is found on this link

Building A Database Project

To build a database project. Open Visual studio 2011, Click on " File> New Project> Database project"
And enter the database project name. For this demonstration i'll be using HRIS or Human resource
information system.

Inspecting Project Properties

To inspect the project properties, right clik the project and click on properties.

As you can see database project 2011 can
target multiple database version including SQl server denali