Implementing a database design using multiple database projects

This blog post assumes you are using Visual Studio 2010. However, most of the information is relevant to Visual Studio Team System 2008 Database Edition GDR. We get a lot of questions from customers for which we answer; use multiple projects (database and/or server). The following canonical examples represent the majority of what customers ask…

0

The pros and cons of Partial Projects and Database Project References

This blog post assumes you are using Visual Studio 2010. However, most of the information is relevant to Visual Studio Team System 2008 Database Edition GDR. We get a lot of questions on the forum for which the answer is to use partial projects and/or database project references. Before you choose one or the other…

4

T-SQL IntelliSense in Visual Studio 2010

One of the cool new features in Visual Studio 2010 is T-SQL IntelliSense. Yes, I know you’re thinking, “it’s about time.” Well, when we were implementing this functionality we had to made some difficult decisions about what we would support. So I thought it would be helpful to describe what T-SQL IntelliSense will/will not do…

1

Visual Studio 2010 SQL Database and DAC Projects (DBPROJ) – Project Properties

This post describes all the properties that may be configured in SQL Server, SQL Database and Data-tier Application Component (DAC) projects and how to go about setting them. Specifically, the properties that are defined and persisted in the DBPROJ file and the msbuild target files it references as well as the DBPROJ.USER file. People that…

1

What happened to DBP (aka database) projects in Visual Studio 2010?

Technorati Tags: DBP,database,project,visual studio 2010 In Visual Studio 2010 DBP projects (also known as database projects) have been replaced by DBPROJ projects (aka SQL Server 2005 or 2008 Database Projects). DBPROJ projects have only been available in Visual Studio Team System 2005 and 2008. Now these project types are available in Visual Studio 2010 Professional,…

2

What is a Visual Studio 2010 Data-tier Application project?

Technorati Tags: Visual Studio 2010,Data Dude,DBPro,Database Project,DAC,Data-tier Application In Visual Studio 2010 Beta 2 we have introduced a new database project type to support SQL Server Data-tier Applications (DAC). For detailed information on what DACs are please search for information available on SQL’s Books On Line (BOL). I suggest using the search string “SQL Server…

0

Implementing a WIX installer that calls the GDR version of VSDBCMD.EXE

Technorati Tags: Data Dude,DBPro,Database Edition,VSDBCMD,WiX,Setup,MSI One of the cool things that shipped with the Visual Studio Team System 2008 Database Edition GDR (aka the GDR) is the command line utility VSDBCMD.EXE. By using this utility, you can take the artifacts created by building a Database Project and deploy them to a database instance. If the…

8