Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS SQL Licensing question

Posted on 2011-09-09
4
Medium Priority
?
340 Views
Last Modified: 2012-05-12
From what I understand SSIS does not come with SQL Express (can someone confirm this?)
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_26340644.html
What are the licensing requirements for MS SQL Standard for an application that will have one administrator. I will need the SSIS component and as far as I know I will need minimum the std edition in order to have the SSIS option

The App that will connect to SQL is for an eCommerce Magento connection to upload and download data. One administration and connection to a pervasive database with SSIS

Can someone give me an idea as to license requirements and cost as well for MS SQL for the above app?
0
Comment
Question by:Gerhardpet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 8

Expert Comment

by:venk_r
ID: 36513369
Thats right the express edition doesnt support SSIS

Best bet would be  sql server 2008  standard edition and  it will cost around 8,000 per processor
0
 
LVL 8

Expert Comment

by:venk_r
ID: 36513381
If it doesnt exceed 5 CAL then its around $1500 per license.
0
 
LVL 1

Author Comment

by:Gerhardpet
ID: 36514804
Do you know if the Workgroup edition comes with SSIS?

When I do a quote on MS website I get the following. I don't even see the workgroup edition. I'm not sure but does the first option come with 5CAL's? I don't see any option to select the CAL's?
SQL LIcense
0
 
LVL 8

Accepted Solution

by:
venk_r earned 2000 total points
ID: 36514949
Well, the workgroup has only limited features as far as SSIS is concerned.I think its limited to just import export options.If you want more than that then SQL Standard edition is best choice.The one mentioned $1199
I beleive is for just 1 server. If ypu need addition CAL's then it will be more.The one mentioned as $9500 iI believe is for 1 processor with unlimited CAL's.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question