VSTS 2008 Database Edition GDR: More First Impressions

Tools, Visual Studio
Because I was having so many problems yesterday after I tried doing everything at once, creating multiple deployments to multiple servers with a variety of different settings... Anyway, it didn't work. So today I went back to square one. I created a blank project.¬† Yesterday I used the schema compare to capture the database, but today I right clicked on the project and found "Import Database Objects and Settings..." which did it all for me. Yee Ha! Anyway, after getting all the objects in, I started trying to deploy. This time I got errors on FK's. It somehow changed the order on the compound keys columns. While editing, I found that if I messed up the syntax and then saved the file, I didn't get an instantaneous error. That bummed…
Read More

Unit Testing Database Code

Steve Jones, in his daily email from SQL Server Central, supplied a link to a terrific article in the MSDN magazine. Apply Test-Driven Development to your Database Projects. It was written by Jamie Laflen who is a Tech Lead on the DBPro team.  I've written a couple of articles on database unit testing, but none of them touch this. It's the new gold standard for introducing the topic to beginners (and lending a helping hand to experienced users). It's worth a read, or even two. I'm going to go back and review it a couple of times with Visual Studio open and a project running. No word yet on new virtuals. I'm going to work on another set of tests that I have to run. More on that later.
Read More