blogs.conchango.com

I want to take the opportunity give a little bit of love out to the datadude team. Just now I wanted to move one of my tables into a different schema. This table is referenced in countless pieces of code so I used Refactor-->Move Schema to make the change. All of my code that references the table is auto checked-out of source control and ...

Service Release 1 of Visual Studio 2005 Team Edition for DB Pros (aka datdude) includes a new feature that hasn't been mentioned anywhere by the datadude team. Any database deployed using SR1 will contain an extended property called 'microsoft_database_tools_deploystamp'. You can see it here look: The deployment script that is ...

It has annoyed me for a long time that this product (note I'm linking to it, not naming it) suffers from a lack of identity. The official name is "Visual Studio 2005 Team Edition for Database Professionals" (58 characters for pity's sake) though in some places it is listed as "Visual Studio 2005 Team Edition for ...

Do you get lost in the myriad of tools that congregate under the banner of Visual Studio Team System (VSTS)? Perhaps you don't, but I do! Today David Reed pointed me at a resource on MSDN that does a good job of unmuddying the waters as regards these tools. Head to Visual Studio 2005 Team Editions Comparison for an explanation of the ...

As Gert Drapers has previously reported, the datadude team have released Service Release 1 (SR1) and Power Tools for datadude (aka Visual Studio Team System for Database Professionals). Back in December 2006 I published this blog entry that explained a hack one could use to change the name of the file that is output from a datadude project build. ...

I work predominantly in the data integration space and I suspect most of you reading this do too. One of the most common data integration scenarios is discovering what records in one table don't exist in another and I have previously written about how to achieve that in my tool of choice, SQL Server Integration Services. Recently another tool ...

I use datadude quite alot and recently I imported lots of tables into my datadude project but forget to configure it to not import the collation (more on how to configure that some other time). Hence, I had a huge collection of tables with unwanted collation statements in them. An easy way to fix this is to use Visual Studio's find/replace ...

On my current project we are using Visual Studio Team System for Database Professionals aka Datadude to manage the deployment of SQL Server objects to our various dev, test, QA and production environments. In doing that I came across a bit of a problem that can easily occur if you are not dliligently testing your deployment scenarios. A ...

Here at Conchango there has been quite a bit of discussion by certain people (JRJ, Dan Perrin, Mick Horne amongst others) about how best to leverage the capabilities of Visual Studio Team System For Database Professionals (DBPro for short). It is generally believed that the cost of DBPro is prohibitive. Each seat requires a seperate ...

I found a bug in datadude yesterday and, with a little help, I was able to come up with a workaround so figured I'd post here in case anyone else comes up against it. In the RTM version of Datadude it is possible to specify the name of the database when it is deployed. As you can see here: Note the specified name of the database ...