Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An Example of Test-Driven Development, Part 5 Expand / Collapse
Author
Message
Posted Thursday, August 20, 2009 12:08 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
Comments posted to this topic are about the item An Example of Test-Driven Development, Part 5

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #774015
Posted Thursday, August 20, 2009 10:56 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 8:31 PM
Points: 13, Visits: 61
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?
Post #774778
Posted Friday, August 21, 2009 4:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 11, 2013 2:42 AM
Points: 150, Visits: 245
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

Post #774896
Posted Friday, August 21, 2009 6:51 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 11:44 AM
Points: 46, Visits: 341
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.
Post #774995
Posted Tuesday, November 16, 2010 8:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 7:50 AM
Points: 1, Visits: 39
Excellent Andy ! Thank you very much :)
Post #1021552
Posted Saturday, November 27, 2010 4:03 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, May 24, 2014 7:58 PM
Points: 219, Visits: 824
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?
Post #1027004
Posted Saturday, November 27, 2010 7:50 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 6:49 PM
Points: 389, Visits: 1,042
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
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1027010
Posted Saturday, November 27, 2010 7:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, May 24, 2014 7:58 PM
Points: 219, Visits: 824
Same here, Andy - I ended up unit testing almost everything, but with other tools.
Post #1027011
Posted Thursday, June 30, 2011 8:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 5, 2012 2:33 AM
Points: 3, Visits: 9
thanks i mastered it from part1 to 5 now where are the rest of the parts i want continue
Post #1134510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse