none
Deployment of SQL Server Business Intelligence Development Studio (2008 R2)

    Question

  • Looking for some guidance on deploying SQL Server Business Intelligence Development studio (2008 R2).  I have a requirement from our Data Warehouse developers, and they require the SQL Server Business Intelligence Studio deployed to the server that will hold the production data warehouse.  Is the SQL Server Business Intelligence development studio normally deployed on a production server?

    I am hesitant about installing the SQL Server Business Intelligence Development studio since it's a development tool.  I haven't seen anything that it is required to run the developed objects.

    Any information you can provide will be appreciated.

    Thanks.

    DJ

    Tuesday, February 18, 2014 2:01 PM

Answers

  • Hi DonsJones,

    The SQL Server Business Intelligence Development studio (BIDS) is a client tool for BI Projects development and won’t be installed on the production server in most cases. For a DW/BI system, the BIDS is generally used to develop ETL packages, Data Mining, and Reporting. The development activities should be performed in the Dev environment, and the eventually ETL packages or reports should be deployed to the production server or report server. For a production server that will run the ETL packages (usually in SQL Server Agent jobs), SSIS should be installed on the production server.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    • Marked as answer by donsjones Tuesday, February 25, 2014 11:38 AM
    Thursday, February 20, 2014 3:26 AM

All replies

  • Hi DonsJones,

    The SQL Server Business Intelligence Development studio (BIDS) is a client tool for BI Projects development and won’t be installed on the production server in most cases. For a DW/BI system, the BIDS is generally used to develop ETL packages, Data Mining, and Reporting. The development activities should be performed in the Dev environment, and the eventually ETL packages or reports should be deployed to the production server or report server. For a production server that will run the ETL packages (usually in SQL Server Agent jobs), SSIS should be installed on the production server.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here


    Mike Yin
    TechNet Community Support

    • Marked as answer by donsjones Tuesday, February 25, 2014 11:38 AM
    Thursday, February 20, 2014 3:26 AM
  • Thanks, that is the information I was looking for.

    DJ

    Tuesday, February 25, 2014 11:38 AM