Solved

MS SQL Licensing question

Posted on 2011-09-09
4
312 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
  • 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 500 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
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…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now