Re: RoundhousE and Teamcity

[Rob Reynolds]

I've used both TC (TeamCity) and Hudson (Jenkins if you will) with RoundhousE. 

The process is actually quite simple. You need to include RH in your build output or have it installed on the box (install being a loose term here, just meaning on the PATH somewhere available).

Then I would recommend you split your build from your deploy. I can go into many details but it amounts to having a CI build that does nothing to affect your environments (kind of the same concept as command query separation, you don't mix a build and a deploy). But you can have an automated deploy for an environment, say DEV, when the CI build is successful.  And you can define your other environments, but have them with a manual trigger (so a QA person could say trigger a deploy to the TEST environment).

For TC, have a look at this article about dropkick (https://github.com/chucknorris/dropkick/wiki/TeamCityIntegration). The article is rough, but still applies with RH and/or any deployment scenario (which by the way, DK has an RH task built into it).

For the particulars of how with RoundhousE:

• As previously mentioned, rh.exe is reachable somewhere.
• Your scripts are checked in and getting built with your code.
• Depending on whether this is greenfield DB or maintenance, you would do a drop/run or a restore run. Also depending on your ability to affect an environment.
• If you have credentials necessary to a database, the optimal solution is to have someone set those in environment variables and then just put those into the connection string. i.e. if your database is named Northwind and you are hitting the DEV environment, you might set an environment variable named %Northwind_DEV_PWD%. Or you would go a step further and put the whole connection string into an environment variable. Whatever makes the most sense between you and your development team (DBAs included).

Here is an example (from a recent project in Jenkins):

Please feel free to hit the group up with any followup questions.

Note: So sorry about not approving this sooner. It got lost in my inbox.

____
Rob
"Be passionate in all you do"

http://devlicio.us/blogs/rob_reynolds
http://ferventcoder.com
http://twitter.com/ferventcoder

On Thu, Nov 8, 2012 at 6:03 AM, Tim Shepherd <tumbl...@gmail.com> wrote:

Hello All

 

Wading my way through the muddy waters of automated deployment - pretty sure what I want, just looking for the best way to go about it.

 

I've been reading about Teamcity and really like it, and for SQL, I've read about RoundhousE and really like the way it works (on paper). Has anyone used the two together? If so, how? Im just trying to visualise the link between the two and how I would get started with it.

 

Many Thanks!

--
You received this message because you are subscribed to the Google Groups "chucknorris" group.
To view this discussion on the web visit https://groups.google.com/d/msg/chucknorrisframework/-/H3HH9MTFv4gJ.
To post to this group, send email to chucknorri...@googlegroups.com.
To unsubscribe from this group, send email to chucknorrisframe...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/chucknorrisframework?hl=en.

[Tim Shepherd]

Hi Rob

Thanks for that info - invaluable stuff.

I got my Teamcity install done, got myself RoundhousE and am starting to work out the process with a test project. Cant wait to have this stuff automated :)

Can I ask, what are the main difference between Dropkick, UpperCut and RoundhousE (apart from the names)? If there's a link somewhere, that'd be great.

Tim

To unsubscribe from this group, send email to chucknorrisframework+unsub...@googlegroups.com.

[Rob Reynolds]

https://github.com/chucknorris

http://chocolatey.org/packages/roundhouse

http://chocolatey.org/packages/dropkick 

WarmuP - token replacement tool

UppercuT - conventional build tool

DropkicK - Fluent deployments

RoundhousE - database migration engine (sql)

____
Rob
"Be passionate in all you do"

http://devlicio.us/blogs/rob_reynolds
http://ferventcoder.com
http://twitter.com/ferventcoder

To view this discussion on the web visit https://groups.google.com/d/msg/chucknorrisframework/-/cVtA76FOy8gJ.

To post to this group, send email to chucknorri...@googlegroups.com.

To unsubscribe from this group, send email to chucknorrisframe...@googlegroups.com.