June 27, 2019 at 3:17 pm
We have an enterprise licence, can we install using the Enterprise key SSIS onto the developers machines or do they need a seperate developer licence?
June 27, 2019 at 5:41 pm
The SSIS engine is a part of the SQL Server Developer Edition bundle, so it would fall under the same licensing terms. Use that instead of your Enterprise key. Developer edition has all the same features as Enterprise. I am not a licensing expert and I can't find the link to terms right now, but it is considered free for purposes of development, demoing, QA testing, and even UA testing.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
June 27, 2019 at 5:47 pm
The developers only need Visual Studio (SQL Server Data Tools) - they do not need Integration Services installed on their workstations. SQL Server Data Tools does not require a license and is free to download and install.
Developers will build their projects/packages in VS - then deploy to the server. The deployment model you should be using is the project deployment to the Integration Services Catalog. The catalog should be installed and configured on a SQL Server instance - preferably an instance dedicated to SSIS or to an instance supporting integration projects.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply