SQLServerCentral / Discuss Content Posted by Andy Leonard / Article Discussions / Article Discussions by Author / An Example of Test-Driven Development, Part 5 / Latest Posts

RE: An Example of Test-Driven Development, Part 5

awonke.fongoqa — Thu, 30 Jun 2011 08:48:23 GMT

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

RE: An Example of Test-Driven Development, Part 5

Alexander Kuznetsov — Sat, 27 Nov 2010 19:59:31 GMT

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

RE: An Example of Test-Driven Development, Part 5

Andy Leonard — Sat, 27 Nov 2010 19:50:51 GMT

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.:{>

RE: An Example of Test-Driven Development, Part 5

Alexander Kuznetsov — Sat, 27 Nov 2010 16:03:08 GMT

[quote][b]Scott Abrants (8/21/2009)[/b][hr]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. [/quote]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?

RE: An Example of Test-Driven Development, Part 5

cornu_virginie — Tue, 16 Nov 2010 08:56:46 GMT

Excellent Andy ! Thank you very much :)

RE: An Example of Test-Driven Development, Part 5

Scott Abrants — Fri, 21 Aug 2009 06:51:38 GMT

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.

RE: An Example of Test-Driven Development, Part 5

mike brockington — Fri, 21 Aug 2009 04:42:37 GMT

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.

RE: An Example of Test-Driven Development, Part 5

rd-600137 — Thu, 20 Aug 2009 22:56:26 GMT

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.[b]Msg 911, Level 16, State 1, Line 3Database 'WeatherData' does not exist. Make sure that the name is entered correctly.[/b] > 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?

An Example of Test-Driven Development, Part 5

Andy Leonard — Thu, 20 Aug 2009 00:08:59 GMT

Comments posted to this topic are about the item [B]An Example of Test-Driven Development, Part 5[/B]