SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


An Example of Test-Driven Development, Part 5


An Example of Test-Driven Development, Part 5

Author
Message
Andy Leonard
Andy Leonard
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1116 Visits: 1095
Comments posted to this topic are about the item An Example of Test-Driven Development, Part 5

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
rd-600137
rd-600137
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
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?
mike brockington
mike brockington
SSC-Enthusiastic
SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)SSC-Enthusiastic (186 reputation)

Group: General Forum Members
Points: 186 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


Scott Abrants
Scott Abrants
SSC-Enthusiastic
SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)SSC-Enthusiastic (181 reputation)

Group: General Forum Members
Points: 181 Visits: 405
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.
cornu_virginie
cornu_virginie
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 41
Excellent Andy ! Thank you very much Smile
Alexander Kuznetsov
Alexander Kuznetsov
SSC-Addicted
SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)

Group: General Forum Members
Points: 401 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?
Andy Leonard
Andy Leonard
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1116 Visits: 1095
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
Data Philosopher, Enterprise Data & Analytics
Alexander Kuznetsov
Alexander Kuznetsov
SSC-Addicted
SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)SSC-Addicted (401 reputation)

Group: General Forum Members
Points: 401 Visits: 824
Same here, Andy - I ended up unit testing almost everything, but with other tools.
awonke.fongoqa
awonke.fongoqa
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 9
thanks i mastered it from part1 to 5 now where are the rest of the parts i want continue
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search