Solved

MS SQL Licensing question

Posted on 2011-09-09
4
301 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Detach & Attach 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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

758 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

20 Experts available now in Live!

Get 1:1 Help Now