SSDT installation on multi server platforms

  • Hello,

    We have a BI-Stack configuration for server SQL 2012 that includes a gateway server that houses the app, a second server which houses SQL Server DB and SSIS, and a third server that houses SSAS and SSRS. Where should SSDT tools be installed? I assume on the gateway? This is a production environment, so should VS and/or SSDT not be here at all?

    Any help is appreciated

    SQL-TG

    The are no problems, only solutions. --John Lennon

  • I wouldn't put SSDT on a production machine at all. It's a development platform. It goes on your laptop or a shared desktop or something, not on production.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply