Project Description
A lightweight way to automate SQL Server builds and deploy SSIS packages to development environments. Uses Red Gate SQL Compare, SVN and Powershell. Ideal for DW/BI projects.

This is a small project to enable developers to quickly automate database builds and deploy SSIS packages from source control. It's primarily aimed at BI/Data Warehouse developers. It's currently in it's first iteration, but the script works with a little bit of customisation for server names etc. Suggestions more than welcome!

For a bit of background to this, see my blog post at

Updated, see:

Note the blog links have updated to my new domain.

Last edited Apr 18, 2012 at 5:59 PM by grapefruitmoon, version 6