March 7, 2018 at 7:58 am
We have our prod server where our we have SSIS installed. Our development team creates packages and update our DBs. I am trying to work on getting their own dev server setup with only SSIS installed and not the DB engine so they are doing any work on prod. So I just want to know if we have to license the dev server I guess?
March 7, 2018 at 8:12 am
NewBornDBA2017 - Wednesday, March 7, 2018 7:58 AMWe have our prod server where our we have SSIS installed. Our development team creates packages and update our DBs. I am trying to work on getting their own dev server setup with only SSIS installed and not the DB engine so they are doing any work on prod. So I just want to know if we have to license the dev server I guess?
Development version of SQL Server 2016 and above is free. 2014 and below require licences, I believe.
You cannot install SSIS without installing the database engine.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 7, 2018 at 8:16 am
Phil Parkin - Wednesday, March 7, 2018 8:12 AMNewBornDBA2017 - Wednesday, March 7, 2018 7:58 AMWe have our prod server where our we have SSIS installed. Our development team creates packages and update our DBs. I am trying to work on getting their own dev server setup with only SSIS installed and not the DB engine so they are doing any work on prod. So I just want to know if we have to license the dev server I guess?Development version of SQL Server 2016 and above is free. 2014 and below require licences, I believe.
You cannot install SSIS without installing the database engine.
I think 2014 is also free.
Thanks
March 7, 2018 at 8:21 am
So I just want to make sure that I understand that correctly, if we have a development version of SQL Server installed on the dev server where we have SSIS installed and dev team uses that server to create packages to update our DBs, we don't have to license that server?
March 7, 2018 at 8:27 am
NewBornDBA2017 - Wednesday, March 7, 2018 8:21 AMSo I just want to make sure that I understand that correctly, if we have a development version of SQL Server installed on the dev server where we have SSIS installed and dev team uses that server to create packages to update our DBs, we don't have to license that server?
Your developers will need to register with Visual Studio Dev Essentials but you are correct. Have a read of the link
Thanks
March 7, 2018 at 8:27 am
NorthernSoul - Wednesday, March 7, 2018 8:16 AMPhil Parkin - Wednesday, March 7, 2018 8:12 AMNewBornDBA2017 - Wednesday, March 7, 2018 7:58 AMWe have our prod server where our we have SSIS installed. Our development team creates packages and update our DBs. I am trying to work on getting their own dev server setup with only SSIS installed and not the DB engine so they are doing any work on prod. So I just want to know if we have to license the dev server I guess?Development version of SQL Server 2016 and above is free. 2014 and below require licences, I believe.
You cannot install SSIS without installing the database engine.I think 2014 is also free.
Thanks
Ah yes, I think you are right. Was it from 2014 SP1 onwards?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 7, 2018 at 8:30 am
NewBornDBA2017 - Wednesday, March 7, 2018 8:21 AMSo I just want to make sure that I understand that correctly, if we have a development version of SQL Server installed on the dev server where we have SSIS installed and dev team uses that server to create packages to update our DBs, we don't have to license that server?
Not for SQL Server. You will still need to licence the OS, of course.
As the dev edition is free, I would suggest that you consider installing it locally for all of your developers and let them do dev & unit testing there. Maybe that does not work in your environment, but it's a fairly standard way of operating.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
March 7, 2018 at 8:35 am
Phil Parkin - Wednesday, March 7, 2018 8:27 AMNorthernSoul - Wednesday, March 7, 2018 8:16 AMPhil Parkin - Wednesday, March 7, 2018 8:12 AMNewBornDBA2017 - Wednesday, March 7, 2018 7:58 AMWe have our prod server where our we have SSIS installed. Our development team creates packages and update our DBs. I am trying to work on getting their own dev server setup with only SSIS installed and not the DB engine so they are doing any work on prod. So I just want to know if we have to license the dev server I guess?Development version of SQL Server 2016 and above is free. 2014 and below require licences, I believe.
You cannot install SSIS without installing the database engine.I think 2014 is also free.
Thanks
Ah yes, I think you are right. Was it from 2014 SP1 onwards?
Yeah I think so. There was a welcome change of opinion from Microsoft. It's a bit of a pain keeping track of who has registered with Dev Essentials though.
Thanks
March 8, 2018 at 1:35 pm
NewBornDBA2017 - Wednesday, March 7, 2018 8:21 AMSo I just want to make sure that I understand that correctly, if we have a development version of SQL Server installed on the dev server where we have SSIS installed and dev team uses that server to create packages to update our DBs, we don't have to license that server?
Not quite if I understand your question correctly.
If you install a Developer edition Instance on any server that instance can not access any production environment.
So Dev server with SQL db + ssis for development and testing. Can only access non-production environments.
Once ready to go to prod deploy packages/jobs and whatever else is required to the production instance and run the jobs there.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply