An Example of Test-Driven Development, Part 5

  • Comments posted to this topic are about the item An Example of Test-Driven Development, Part 5

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • Great series. Replicated all the steps and have it working except for one thing: When I drop the WeatherData db and run the MasterDeploy script, I get the following:

    ------------------------------------------------

    [V1] Deploying WeatherData v1

    [V1] Calling CreateWeatherData.test.sql...

    Failure: WeatherData does not exist.

    [V1] CreateWeatherData.test.sql called.

    Msg 911, Level 16, State 1, Line 3

    Database 'WeatherData' does not exist. Make sure that the name is entered correctly.

    > DBVersion table exists.

    > Dropping AddNewVersion stored procedure

    ...however if I highlight just the CreateWeatherData lines and run those first on their own, the database gets created and then I can run the MasterDeploy in its entirety. Any idea why it's getting stuck?

  • What is the point of storing this kind of information in the Database itself, but not using some kind of trigger?

    People should be able to find out what they are looking at BEFORE they dive into the internals of the database, so the only point that I can see for storing version info in a table is if you can set things up to automatically record what changes are made.

    Throw away your pocket calculators; visit www.calcResult.com
  • Great series Andy - Thank you.

    I do have a question. All of the work you did here is something that has to be done manually and maintained manually. Now I understand in situations where you can’t buy a development too this is the way to go. I am a big fan of automation and using tools that help reduce errors and maintain efficiency. With that said is it me or are others seeing a big drop off in the number of posts for tools like Visual Studio Team Edition For Database Professionals even though 2008 was recently introduced? Reason why I ask is because I am pushing to use this tool as a standard yet I don’t want to go down this path only to have to go back to the manual way in the near future or worse yet back myself into a corner. Do you have any feedback on this? Again thank you for taking the time to put together a great series.

  • Excellent Andy ! Thank you very much 🙂

  • Scott Abrants (8/21/2009)


    Great series Andy - Thank you.

    I do have a question. All of the work you did here is something that has to be done manually and maintained manually. Now I understand in situations where you can’t buy a development too this is the way to go. I am a big fan of automation and using tools that help reduce errors and maintain efficiency. With that said is it me or are others seeing a big drop off in the number of posts for tools like Visual Studio Team Edition For Database Professionals even though 2008 was recently introduced? Reason why I ask is because I am pushing to use this tool as a standard yet I don’t want to go down this path only to have to go back to the manual way in the near future or worse yet back myself into a corner.

    Hey Andy, I have the same question - is VS Team Edition a popular tool? How many people are using it? Does it have many bugs? Do they fix them quickly?

  • I haven't used Database Edition recently. I liked the earlier versions a lot, and liked the direction of the product. One thought when I started this series was to show how to do test-driven development manually, and then follow it up with ways to accomplish similar tasks using Database Edition. Obviously I haven't done that, at least not yet.

    I've been disconnected from the Database Edition crowd for a bit, so I'm not sure how widely it's been adopted.

    :{>

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • Same here, Andy - I ended up unit testing almost everything, but with other tools.

  • thanks i mastered it from part1 to 5 now where are the rest of the parts i want continue

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply