DeployToDatabaseAddToServerExplorer

DeployToDatabaseAddToServerExplorer

Posted by richard | October 19, 2009 | Development, SQL Server, Visual Studio 2010

I’ve been doing a lot of work with the Database, er Development edition of VSTS 2008. Of course I’m running the GDR-R2 version which really changed the architecture of the database projects, as well as the process of building and deploying.

Prior to the GDR, if you deployed a database project it would automatically create a Data Connection in the Server Explorer window. I liked this, because I would almost always follow-up a first time deployment with some data generation or unit testing, and it just made it easier to select the pre-defined connection from the dropdowns. It seems that the GDR erased this timesaver.

 

For example, I just deployed a GDR-R2 database project according to these settings:

 

image

 

And when I go to the Server Explorer window, I don’t see my VSTSdev.AdventureWorks2009.dbo connection like I would have expected:

 

clip_image002

 

Well it seems that this change was by design and it is configurable! According to Duke Kamstra, there’s a property in the database project (.dbproj) file that lets you control this behavior:

 

<DeployToDatabaseAddToServerExplorer>False</DeployToDatabaseAddToServerExplorer>

 

If you set the property to True, the connection will get added to the list which Server Explorer displays, and the behavior I enjoyed prior to GDR will return. For added coolness, if you always want this behavior you could modify the template(s) that are instantiate dbproj file(s) from: C:Program FilesMicrosoft Visual Studio [9.0 | 10.0]VSTSDBExtensionsSqlServerProjectItems**.dbproj

 

Duke also tells me that the same property exists in Visual Studio 2010.

Related Blogs

Posted by richard | October 21, 2014
A unique load testing experiment
Most of the guidance you'll find about Visual Studio Ultimate Load Tests suggests that they are only for load testing Web Performance tests. Actually, they can be used to load...
Posted by richard | May 9, 2014
Develop.Idaho 2014 Videos Published
Updated 20 May: Added presentations (but no videos) from the "Business of Software" track. It took a few extra days to get these produced and published, but they are now...
Posted by Simon Reindl | September 19, 2012
Useful TFS Links
I have just finished delivering a Team Foundation Course today, and we had some great discussions around TFS Administration, upgrading, adoption etc. As usual, there is a whole pile of...