By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Tool/Best Practices for installing BI Project

P: n/a
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

May 11 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The level of feedback seems to reflect the level of thought MS put into
this :)

May 15 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.