blogs.conchango.com

December 2006 - Posts

• MSBuild using SQL Script parameters

  I have been working with MSBuild and the Microsoft.Sdc.Tasks to deploy my current project’s databases. Some of the SQL scripts that are executed within MSBuild need parameters to be set to create the database objects, which the Microsoft.Sdc.Tasks.Sql.Execute Read More... Posted 20 December 2006 10:12 by steve.wright | 0 Comments Filed under: SQL Server, SQL Server 2005, MSBuild

• To Collate or not to Collate

  Collation plays an important role within the database, as it sets out how the SQL Server has to manage string data within storage & queries, yet I don’t script out the collation when scripting out my databases. So why don’t I script out Read More... Posted 20 December 2006 10:08 by steve.wright | 0 Comments Filed under: SQL Server, SQL Server 2005, VSTDB, Visual Studio 2005 Team Edition for Database Professionals

• Delpoying Reporting Services Reports With MSBuild

  I am currently responsible for deploying our project into the test and production environments. The project has a few reports which need to be installed on a few report servers. The deployment tool that I am using for the rest of my project is MSBuild Read More... Posted 20 December 2006 10:00 by steve.wright | 2 Comments Filed under: Reporting Services 2005, .Net 2.0, Reporting Services, MSBuild Attachment(s): MsBuild Reporting Task.zip