Automating Deployment For Clairfy Using Rake
February 6, 2012
Gary posted recently on Automating Deployment For Clarify. A customer recently had an automation need that I answered in a similar way but rather than using NAnt I pulled from our fancy favorite new build automation tool Rake. In this post we’ll take a look at automating common database setup tasks like applying schema scripts and executing arbitrary SQL using Rake. I hope you find it useful. Where is the Code? I put together a Dovetail Automation gist with everything you need to solve two problems. Applying Dovetail Schema Editor schema scripts. Applying all SQL scripts in a directory. Check out the readme for setup and execution instructions. Next I’ll talk a little about what each task does. Applying Schema Scripts (apply_schemascripts) This task looks for a child directory named schema below where the rakefile.rb is located. Every file in…