June 25, 2014 at 2:21 pm
Hello,
I have a BI_Stack configuration (DB, SSIS, SSAS, SSRS 2012) production environment, and I would like to know if it makes any sense installing Visual Studio and/or SSDT tools on a production environment. It seems to me that these tools should be installed on DEV and QA environments only, and if you need to deploy a change to Prod simply use SSDT to deploy. Is this correct?
Any help is appreciated.
SQL-TG
The are no problems, only solutions. --John Lennon
June 25, 2014 at 2:54 pm
No. There is no reason whatsoever to install those tools on the production server.
Maybe SSMS. Suppose the network is down and you can only access the server physically. (I hope that never happens)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2014 at 3:53 pm
Nuts, duplicate question. I said the same thing at the other location.
Please don't cross post. It just confuses conversations. Most of us look at multiple forums anyway.
"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
June 26, 2014 at 6:38 am
Thanks Koen - I figured that but just wanted to be sure. I have worked in a lot of environments that did not have the budget to use BI-Stack correctly. So EVERYTHING was installed on one box.
Appreciate the feedback 🙂
The are no problems, only solutions. --John Lennon
June 26, 2014 at 6:39 am
My bad about the duplicate post. I thought I didn't ask the question correctly 😀
The are no problems, only solutions. --John Lennon
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply