Tool/Best Practices for installing BI Project

[jimdandy@shaw.ca]

Hi all,

Am looking for some guidance/advice in terms of best practices for
deploying a MS BI project.

We have a relatively large BI system that we need to deploy between
DEV/QA/UAT/PROD and want a simple way to manage this deployment between
environments. The system consists of:

SQL Server 2005 Catabases, tables, views, sprocs, security scripts,
etc.
SQL Server 2005 AS Cubes
SQL Server 2005 Reporting Services reports
SQL Server 2005 IS Packages
Business Scorecard Manager stuff

etc.

What tools/technologies would best suit this type of deployment with so
many moving parts? Right now the database portion of the install is all
automated with command files that call sqlcmd to run each script,
object. But to deploy all the other stuff, we have our build guy
actually opening Visual Studio and deploying from within there. We know
how to use config files for the IS packages.

Appreciate your thoughts/feedback on this.

JD

[jimdandy@shaw.ca]

Re: Tool/Best Practices for installing BI Project

The level of feedback seems to reflect the level of thought MS put into
this :)