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
Note the blog links have updated to my new domain.