467,076 Members | 863 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,076 developers. It's quick & easy.

Tool/Best Practices for installing BI Project

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
  • viewed: 1648
Share:
1 Reply
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.

Similar topics

5 posts views Thread by great_googley_moogley | last post: by
1 post views Thread by Vincent V | last post: by
10 posts views Thread by jojobar | last post: by
5 posts views Thread by BK | last post: by
3 posts views Thread by STandard | last post: by
5 posts views Thread by GaryDean | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.