Barclay Hill

Barclay Hill, Sr. Program Manager, SQL Server Developer Tools, Code-Named “Juneau” (SSDT)

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: Deploying Visual Studio Database Projects from TFS TeamBuild 2010

    I had planned to update my previous database continuous integration post with what is new in 2010, but have not had any time to do so yet. Many customers ask me for the same. I shared my 2010 walkthroughs and samples with Steven, Sr. Technical Writer in User Education, and he beat me to it. Steven created...
  • Blog Post: Deployment Contributor Sample: LiteScript

    In Visual Studio 2010 we have enabled a number of new extensibility points as detailed in my earlier post . In this post we will take a look at creating a deployment contributor . This deployment contributor is a deployment executor. Essentially what the sample contributor does is walks through...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 then I have...
  • Blog Post: 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 schema changes. In Part...
  • Blog Post: Managing data motion during your deployments (Part 1)

    Continuing with the VSTS: DB Best Practices post series, let’s take a look at managing data motion in your deployments. This will be Part 1 of a 2 part post. In the first post we will take a look at managing data motion necessary to make table schema modifications while hanging on to your existing data...
  • Blog Post: Deployment Failure: "An item with the same key has already been added"

    We are receiving reports from customers that they are encountering a deployment failure of their database projects using the GDR release. This issue typically occurs when the project is copied to a new location on disk or when the solution configuration is changed with a specific sequence. This deployment...
  • Blog Post: Deploying your Database Project without VSTSDB installed

    The release of Visual Studio Team System Database Edition GDR version includes a very powerful tool to import and deploy database schemas from boxes where Visual Studio is not installed. The tool is a command line utility capable of: Importing a database schema from a live database into a dbschema...
Page 1 of 1 (10 items)