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 http://www.grapefruitmoon.net/automating-db-and-ssis-builds-from-source-con

Updated, see: http://www.grapefruitmoon.net/powershell-deployment-script-update

Note the blog links have updated to my new domain.

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