September 4, 2015 at 4:29 am
I have a case where I am going to be using a SQL Server 2014 Enterprise License on one server for a database, so that I can take advantage of the various data warehousing features that it offers. I am also thinking of a second server for running the SSIS ETL, so that it isn't contending with the main server for resources.
Can this second server just be licensed with a SQL server standard edition license? Does deploying onto the sql server standard licensed server reduce the functionality of the packages somehow? I will most likely be implementing enterprise features within the package, but the only reason these features would work, would be due to the fact that my DB is SQL Server Enterprise, I don't think there would be a dependency on the SSIS server itself, unless I'm mistaken.
Does anyone have any experience of this?
September 4, 2015 at 4:43 am
Ok I think I have answered my question, have been looking around and I found the below link:
https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
So, I assume if I had a standard instance, and tried to deploy a package to it using some of the enterprise SSIS features (like the advanced connectors), then it wouldn't work, but if I restrict myself to functions that are part of the SQL server enterprise database (like table partitioning) then it would be fine, as there are no restrictions there.
September 4, 2015 at 9:23 am
I would spin up two Dev Server, Standard and Enterprise. Use MSDN licenses on them. Then develop enterprise freatures on enterprise Dev and standard on standard server. It would save you a lot of headache in the future.
------------
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply