Maintaining and synchronizing your reference data through the database project

For database application developers working on data driven applications their reference data is as important and meaningful as the database schema itself.  In fact, the database schema is incomplete when the reference data is absent.  When I say reference data, I am speaking of the non transactional data within the database.  This data goes by…

11

Leveraging the Visual Studio 2010 Database Deployment API

I often get questions from developers wanting to modify the deployment engine’s behavior in some way.  These questions are typically motivated by the need to accommodate a specific requirement for a given environment or to support automation in some fashion.  In GDR there has not been much you could do to change the behavior of the…

11

Visual Studio 2010 Database Deployment API – Part 2

Since posting the first code sample on how to leverage the Visual Studio Database Deployment API, I have had a number of folks contact me and ask how to do the same, but also comprehend the database references, options set in the project, refactor log, pre and post deployment scripts, etc.  The short answer is…

8

Why VSTS:DB Best Practices?

Hi everyone! My name is Barclay Hill and I am a Program Manager on the Visual Studio Team System Database Edition Product Development Team. Yep, it’s a mouthful! I will refer to the product as just “VSTSDB” in my posts.  I have been working on a whitepaper regarding best practices for using VSTSDB for the…

7

Managing data motion during your deployments (Part 2)

This post finishes off a 2 part post. Sorry about the delay getting this second part out. I went on a vacation back in May and I am just now getting caught up. In Part 1 we reviewed how to use the pre and post deployment scripts to manage data motion required to deploy some…

7

Right sizing the master.dbschema file for better design time performance

In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system objects.  If you have a project that references the master.dbschema file, you may have noticed it takes a while to establish this reference. You may have also noticed the project…

7

SQL Server Developer Tools "Juneau" CTP3 bits available now!

Our CTP3 bits are available now through WebPI.  We invite you to evaluate this pre-release version of the SQL Server Developer Tools “Juneau” and send us your feedback.  If you are using Visual Studio Database Projects today you will find some improvements in this release including: Simplified project templates, SQL Azure/Denali support, offline/online table designer…

6

Goodbye dbp…Hello dbproj!

In Visual Studio 2010, Database Edition or DBPro Projects (.dbproj) have replaced the old Database Projects (.dbp) from previous versions of Visual Studio.  Database Projects (.dbproj) are available in Professional, Premium, and Ultimate versions of Visual Studio.   For those who have used the old .dbp projects and have these in their solutions your .dbp…

6

New 2010 VSDBCMD Features – Target Model and Override SQLCMD Variables

Targeting a dbschema model file for deployment  Since releasing GDR we have had customer’s ask for the ability to target a dbschema file through vsdbcmd. We were able to add this for the 2010 release. The primary use of this is to diff 2 dbschema files and generate an update script for review. This simplifies the process…

5

Come visit/revisit The Beer House! (Continuous Integration)

Isn’t it funny how a simple word like Beer can grab your attention?  In this post we will look at migrating The Beer House (TBH) sample application database to be managed by VSTS:DB.  For those in the NW you may have seen this previously as I have presented this to the PNWSQL User Group. Since…

4