Jun 11 2008

VSTS 2008 Database Edition GDR: More First Impressions

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 me out. I got used to that in the original Visual Studio. Anyway, I fixed all the FK errors and now I got the deploy to work. I’m now going to walk through creating custom configurations one step a time to see where the deployment stops working.

Mar 07 2008

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.