Deploying a database solution in Visual Studio Database Professional - Tip
I really like the database projects in visual studio however there are a
few bug bears that really annoy me.
This post is about deploying a solution.
When working in development i have the project set to build the delpoy script
and to deploy it. Whats annoying is that I prefer to work in the schema view of
the project and not the solution view and in schema view there is no
context menu(that I know of) to deploy the project. So each time you want to
deploy you have to go to the the solution explorer view, this is very time
consuming (relatively).
I decided this week to find a way around this, and as with many of the Visual
Studio options I found the answer in the customize menu/toolbar.
Here you will find almost all the commands avaialble to you in VS and you can
drag them onto your menus and toolbars.
For this problem you will find Deploy Selection and Deploy Solution under the
build Category.
From here you simply drag the item onto your
toolbar/menu and heh presto you get the menu on the toolbar, so no switching between the schema and solution explorer views any more.
On a related note for Management Studio I do the same to add "Toggle Word
Wrapping" and "Enable SQLCMD" onto my toolbar.