VSTS 2005 and 2008: Building Database Projects with Team Build

Compilando proyectos de bases de datos con Team Build (2005 y 2008)

Luis Fraile — Wed, 12 Sep 2007 22:01:46 GMT

Aunque sea hacer de "repetidor", y aunque supongo que muchos estaréis subscritos a este blog

Compilando proyectos de bases de datos con Team Build (2005 y 2008)

Luis Fraile — Wed, 12 Sep 2007 22:02:15 GMT

Aunque sea hacer de "repetidor", y aunque supongo que muchos estaréis subscritos a este blog

re: VSTS 2005 and 2008: Building Database Projects with Team Build

Andy Leonard — Mon, 17 Sep 2007 00:37:14 GMT

Hi Buck,

Is it possible to configure TFS to build both v8.0 and v9.0 DBPro solutions?

Thanks,

Andy

VSTS Links - 09/17/2007

Team System News — Mon, 17 Sep 2007 16:32:56 GMT

Brian Harry on TFS Migration & Synchronization Tool for ClearCase Revealed. Sudhir Hasbe on Reporting...

re: VSTS 2005 and 2008: Building Database Projects with Team Build

Buck Hodges — Tue, 18 Sep 2007 04:35:58 GMT

Andy, you should just need to have both versions installed on your build computer.

Buck

re: VSTS 2005 and 2008: Building Database Projects with Team Build

jstangroome — Tue, 18 Sep 2007 16:55:57 GMT

Hi,

Is there a simple value I can use for the DefaultDataPath property in a .dbproj file that is not dependant on the file system structure of a SQL Server installation?

For example, I intend to use the (local) SQL Server in the TargetConnectionString but not all machines throughout our site have the SQL data path set to the same folder.

Thanks.

re: VSTS 2005 and 2008: Building Database Projects with Team Build

Jon Liperi — Tue, 18 Sep 2007 21:22:30 GMT

Hi jstangroome,

Unfortunately, no. The value for DefaultDataPath is a hard-coded string and, as you mention, this value may be different in each environment. For team scenarios (like team build), the DBPro team recommends creating a new .targets file that contains default values for these settings that is included in the .dbproj file just before the Microsoft.VisualStudio.TeamSystem.Data.Tasks.targets file (via an Import statement). This would allow default values to be used during Team Builds, while still allowing the settings to be overridden by a .user file, if one exists.

Thanks,

Jon

re: VSTS 2005 and 2008: Building Database Projects with Team Build

jstangroome — Wed, 26 Sep 2007 05:51:21 GMT

Hi Jon,

I've used your suggestion of importing a targets file for team build only and it is working great.

However, I really feel that a DBPro project should be able to be built and deployed to whichever data folder the SQL instance has set as it's default in the registry.

From memory, I can create CREATE DATABASE scripts that just use a relative path and produce this result. To whom do I suggest that DBPro should support this behaviour?

Thanks again,

- Jason

re: VSTS 2005 and 2008: Building Database Projects with Team Build

Jon Liperi — Wed, 26 Sep 2007 16:49:48 GMT

Hi Jason,

I'm very glad to hear it's working for you and thanks for your feedback! I would recommmend making your suggestion directly to the DBPro team. You can either create a post on their forum:

Visual Studio Team System - Database Professionals Forum

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=725&SiteID=1

Or you can log the suggestion at http://connect.microsoft.com. The benefit of logging it on connect is that it can be voted on by other members of the community and is tracked as a bug internally. The downside is that the connect site doesn't have a DBPro specific bucket, but I assure you it will make its way to the right place. :) I would recommend including DBPro in the issue title. Here's how you get to the Visual Studio submission page:

• http://connect.microsoft.com/VisualStudio

• Log in using your Passport

• Click "Submit a Bug or Suggestion"

• Click the green "submit feedback" link

• Search for your issue to see if it has already been logged

• Click "Submit Feedback"

• Choose the Bug or Suggestion form (I would log yours as a suggestion)

• Fill out the form and click Submit

Thanks,

Jon

The Data Dude Meets Team Build

Data Dude — Wed, 07 Nov 2007 05:54:22 GMT

At DevConnections and TechEd Europe every attendee has been receiving a special issue of CoDe Magazine

Building Team Data (DBPro) projects in Team Build

Ken Brubaker — Thu, 08 Nov 2007 21:43:51 GMT

Buck Hodges shares how to solve these five issues in this very useful post. Issue #1: Team Build service...

SQLSaturday!

jim blizzard's blog — Sat, 10 Nov 2007 18:28:06 GMT

Thanks to everyone who attended my session at SQLSaturday in Orlando today. Here's a link to my slides

Team System Linklist

Nicolas Müggler — Fri, 12 Sep 2008 17:02:53 GMT

I'd like to collect some good links about Team System from the community and Microsoft. Please give